This repository demonstrates manual functional testing and backend data validation for a sample Order Management System (OMS). The objective is to ensure data accuracy, consistency, and correct business logic by executing structured test cases and SQL validation queries.
- Validate core workflows such as customer creation and order placement.
- Ensure UI and backend database values align.
- Identify functional defects and document them clearly.
- Demonstrate SQL-based validation for data quality assurance.
- Customer creation
- Order placement
- Order detail verification
- Backend data validation
- Manual Functional Testing
- Smoke Testing
- Regression Testing
- SQL-based Data Validation
- Manual testing with structured test cases
- SQL validation queries (selects, joins, group checks)
- Excel for test case and defect documentation
A simple Order Management System with the following data components:
Customers
- customer_id
- customer_name
- created_date
Orders
- order_id
- customer_id
- order_date
- order_status
- total_amount
| Folder | Description |
|---|---|
Test_Plan/ |
High-level test approach and strategy |
Test_Cases/ |
Detailed test case documentation |
SQL_Validation/ |
SQL queries for backend data validation |
Defect_Reports/ |
Logged defects and observations |
- Open the test plan to understand scope and strategy.
- Use the test cases to execute manual functional testing.
- Run SQL validation queries against the database.
- Log any defects found in the defect log.
- Creating well-structured manual test cases
- Verifying backend data via SQL queries
- Documenting defects with clear steps to reproduce
- Following a test strategy from start to exit
Annapurna Matlapudi
Junior QA Analyst – Entry Level