This report presents an analysis of a student enrolment database system designed for Southern Cross University. The assignment involved creating and testing a database in MySQL using PhpMyAdmin, based on a provided scenario and entity-relationship diagram. The report details client business rules, assumptions made during the design process, and the data types chosen for each database column. It includes the creation and testing of various SQL queries to retrieve information, such as workshop enrolment lists, workshop counts, student transcripts, and student assessment totals. The report also contains a bibliography of relevant resources. The student implemented the database to meet the requirements of the university's student enrolment system, focusing on the efficient storage and retrieval of student data.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
