Data and Information Management: Relational Database Design Report

This report presents a comprehensive database design for the Australian Institute of Music (AIM), addressing the need to computerize its existing paper-based data. The report begins with an Entity-Relationship (ER) data model, visually representing the entities (Student, Staff, Course, Instrument, etc.) and their relationships. It outlines the business rules and assumptions guiding the database design, such as lesson durations, student and staff details, and payment information. The second part focuses on the relational database implementation, detailing the normalization process to achieve the third normal form and ensure data integrity. The report includes a relational schema, defining tables with their attributes and primary/foreign keys, followed by screenshots of the MS Access database tables. Finally, it provides SQL queries to retrieve specific information, such as students under 18, lessons starting within a week, and student attendance statistics. The report demonstrates a strong understanding of database design principles and practical implementation using MS Access.