Database Design and Queries (AMC)

This document presents a comprehensive database project, including business rules, entity-relationship diagrams (ERD), a normalized schema, database schema, foreign key constraints, and SQL queries. The project details the design of a database for a store, covering entities like stores, customers, departments, employees, payslips, products, suppliers, and orders. The document includes a detailed normalized schema with attribute descriptions, data types, and primary/foreign key designations. It also provides a series of SQL queries with their outputs, demonstrating how to retrieve and manipulate data from the designed database. The report section discusses the challenges faced during the database design process, particularly in handling many-to-many relationships, and the solutions implemented. The project aims to provide a practical understanding of database design principles and SQL query writing.