Database Assignment: Normalization, SQL Queries, and Design

This assignment delves into the core concepts of database design, normalization, and SQL queries, using a fitness center scenario as a practical example. It begins with an explanation of database normalization, specifically focusing on the transition from a single, unnormalized table to a 3NF (Third Normal Form) structure to eliminate data redundancy and improve data integrity. The assignment then presents a case study of a fitness center, outlining its requirements and designing an Entity-Relationship Diagram (ERD) to model the data. Following the ERD, the assignment provides SQL scripts to create tables in 3NF, insert sample data, and execute various SQL queries to retrieve and analyze information, such as the number of managers, customers, and members, as well as profit calculations and customer details. Finally, the assignment includes references to relevant database systems literature.