Database Design and Implementation: ER Diagram and Relational Schema

This report details the design of a database, starting with an Entity Relationship (ER) diagram that visually represents entities like staff, courses, members, and their relationships. The report then proceeds to normalize the database through three normal forms (1NF, 2NF, and 3NF), eliminating redundant data and ensuring data integrity. The normalization process resulted in the creation of several relational schemas, including tables for staff, courses, course types, course prerequisites, members, enrollment, classes, member classes, member accounts, payments, awards, and member awards. Each table's attributes, data types, and constraints are defined, along with primary and foreign keys. The report explains the rationale behind the normalization steps, ensuring that the database design is efficient and avoids data anomalies. The conversion of the ER diagram to a relational schema is also outlined, specifying the attributes, data types, and constraints for each table.