Database Design and Analysis: CSC72001 Assessment 3 Report

This report details the analysis, design, and implementation of a database system for CSC72001. It begins with an analysis of client business rules and assumptions, followed by the creation of an Entity Relationship Diagram (EERD) to model the database structure. The report covers the application form for a fitness club member and the SQL commands for granting privileges to other users to access the database. The report also demonstrates the development of entities (tables) with correct attributes, supertypes and their associated subtypes, and normalized relations. The focus is on creating a fully normalized database design, and the report includes SQL queries to provide results suitable for reporting. The assignment aims to provide experience in database design and development using MySQL and PhpMyAdmin.