Southern Cross University CSC72001 Assessment 2 Database Report

Verified

Added on  2022/08/26

|15
|1504
|30
Report
AI Summary
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.
chevron_up_icon
1 out of 15
circle_padding
hide_on_mobile
zoom_out_icon
Loading PDF…
[object Object]