📚 Library Management System SQL QA Project

Project Overview

This project demonstrates manual database testing and SQL validation for a Library Management System using MySQL. The project was developed as part of a Software Quality Assurance (SQA) portfolio to showcase practical SQL skills, database validation techniques, and professional QA documentation.

---

Project Objectives

• Design and create a relational database
• Validate database structure
• Verify data insertion
• Execute SQL queries
• Test database relationships
• Perform data validation
• Document test cases and execution results
• Demonstrate SQL knowledge for Software QA

---

Technologies Used

• MySQL
• MySQL Workbench
• Microsoft Excel
• Microsoft Word
• Git
• GitHub

---

Database Tables

The project contains the following tables:

• Authors
• Books
• Members
• Staff
• Borrow_Records

These tables are connected using Primary Keys and Foreign Keys to maintain relational integrity.

---

SQL Topics Covered

• CREATE DATABASE
• CREATE TABLE
• PRIMARY KEY
• FOREIGN KEY
• INSERT
• SELECT
• WHERE
• ORDER BY
• LIMIT
• DISTINCT
• COUNT
• SUM
• AVG
• MIN
• MAX
• GROUP BY
• HAVING
• INNER JOIN
• LEFT JOIN

---

QA Validation Performed

The following database validations were executed:

• Database creation verification
• Table creation verification
• Data insertion validation
• Primary Key validation
• Foreign Key validation
• Record retrieval validation
• Filtering validation
• Sorting validation
• Aggregate function validation
• JOIN validation
• Duplicate record validation
• Data integrity verification

---

Project Documentation

The repository includes:

• SQL_Test_Plan.docx
• SQL_Test_Cases.xlsx
• SQL_Test_Execution_Report.xlsx
• Library_Database.sql
• SQL_Queries.sql

---

Folder Structure

Library-Management-SQL-QA
│
├── README.md
├── Library_Database.sql
├── SQL_Queries.sql
├── SQL_Test_Plan.docx
├── SQL_Test_Cases.xlsx
├── SQL_Test_Execution_Report.xlsx
│
├── Database_Screenshots
│   ├── 01_Create_Database.png
│   ├── 02_Create_Authors_Table.png
│   ├── 03_Create_Books_Table.png
│   ├── 04_Create_Members_Table.png
│   ├── 05_All_Tables_Created.png
│   ├── 06_Insert_Authors_Data.png
│   ├── 07_Insert_Books_Data.png
│   ├── 08_Insert_Members_Data.png
│   ├── 09_Insert_Staff_Data.png
│   └── 10_Insert_Borrow_Records.png

---

Learning Outcomes

Through this project I gained hands-on experience in:

• Relational Database Design
• SQL Query Writing
• Manual Database Testing
• Database Validation
• Test Case Design
• Test Execution Reporting
• GitHub Portfolio Development

---

Author

Muhammad Hassnain Raza

Software Quality Assurance (SQA) Portfolio Project

July 2026