This report presents a comprehensive solution to a database systems assignment (CSC72001) focusing on a student enrolment database for Southern Cross University. The report includes an analysis of client business rules, assumptions made, and naming conventions. It details the chosen data types for each table and presents an Entity Relationship Diagram. The core of the report lies in testing queries, with examples for workshop enrolment lists, workshop counts, student transcripts, and student assessment totals. The queries are provided along with their results. The report also includes a bibliography of relevant resources. The assignment aimed to create and test a database in MySQL using PhpMyAdmin, meeting specific requirements for student enrolment data management, as detailed in the assignment brief.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
