MySQL Database Project – Manual QA

Project Overview

This project demonstrates Manual QA testing for a MySQL database.
The database simulates a simple e-commerce system with users, products, orders, and order items.
The project contains test cases, bug reports, and SQL scripts to fully test the database functionality.

---

Database Description

Tables:

1. users – stores user accounts
   • id, email, password, created_at, is_active
2. products – stores products in the system
   • id, name, price, stock, is_active
3. orders – stores orders made by users
   • id, user_id, status, total_price, created_at
4. order_items – stores individual products in each order
   • id, order_id, product_id, quantity, price

Constraints used:

• Primary Keys, Foreign Keys
• NOT NULL, UNIQUE, CHECK constraints
• ENUM for order status

---

How to Use This Project

1. Setup Database

1. Open MySQL Workbench or any MySQL client.
2. Run schema.sql to create the database and tables:

SOURCE database/schema.sql;

3. Load test data from test_data.sql:

SOURCE database/test_data.sql;

2. Running Test Cases

1. Open test-cases/test-cases.md to view all test cases.
2. Execute SQL queries from the Steps column in MySQL.
3. Compare actual results with Expected Results.

3. Bug Reporting

1. Bugs discovered during testing are stored in bug-reports/.
2. Each bug contains:
   • Related test case;
   • Steps to reproduce (SQL);
   • Expected vs Actual result;
   • Severity and priority;
3. Screenshots are stored in screenshots/ folder.

4. Cleanup database

To clean up the database after testing, run:

SOURCE database/cleanup.sql;

---

Notes

• All SQL queries in test cases are fully reproducible.
• Test data is designed to allow both positive and negative testing.
• This repository can be directly used as part of a QA portfolio