CSC72001 Database Concepts

Using the ERD supplied and the data requirements provided in the Excel file, you must analyse the database needs of the client. You should provide an explanation of your database decisions or data you feel is relevant in your Assignment 1 report. Some suggested headings for this report are included in the report template (available in this assignment folder):  Client Business Rules
Assumptions Made
 Naming Conventions
 Data types chosen
B.2 MySQL database
Create a MySQL database using phpMyAdmin. You must name this database as your username followed by A2. For example: eyuwon10A2.
You will build the required tables, columns, data types and relationships based on your analysis. You are free to add any tables you feel are needed or would enhance the system. You must include, but are not limited to, the client’s specific data requirements. You may choose to add additional data columns to store other information about students, teachers,
etc if you wish to do so.
B.3 Test Data 1 mark
You must provide enough valid data in your database to run the SQL queries below successfully with at least 5-10 resulting rows. In particular, association tables will need to be sufficiently populated to give meaningful test results. You may refer to the provided sample data for references on the data format. However, you need to analyse and transform the sample data to be suitable for your database, e.g. you will be required to use your assumption on some fields that are not available in the sample data.
B.4 Export Script 1 mark
You must create an export script (.sql) to create a backup of all database structures, including table definitions and data.