A. Task Description
Your task is to create and test a database in MySQL using PhpMyAdmin. You are
provided with a scenario and supporting documents, describing the requirements that
Southern Cross University may have for a database to handle their student enrolments.
You are provided with most of the design for such a database and will need to create a
relational database to meet the client needs. You will also need to add sample data and
create SQL queries to provide results suitable for reporting.
Southern Cross University provides a variety of Bachelor degrees to students studying
internally across campuses at Coffs Harbour, Lismore and the Gold Coast, as well as by
distance education. Student enrolments and their progress in units need to be stored in
a database. A systems analyst has partially designed this database (see Entity
Relationship Diagram provided). You have been brought into the project to finish
creating and testing the database to support SCU needs.
Additional to the ERD, SCU has provided you with some lists and details about what
information needs to be stored for enrolment and recording of student results. Some of
the data for each of these lists has been provided in the file
DATA2001_Assessment2_SampleData.xlsx, included with this assessment. The client
had provided you with as much as they know about the data requirements. As with
most client-provided data, much information is duplicated in the sample data (the data
is not normalised), and the spreadsheets do not reflect the finished database table
design. You will have to decide on and set the datatypes and lengths, as well as finish
the design of the database.
In addition to storage of information about students, courses (such as Bachelor of IT),
units (such as DATA2001), staff and workshops, you must allow for the following:
A.2.1 Record student enrolment in a course, including enrolment date;
A.2.2 Record student enrolment in a unit, including the Session and the type of
enrolment (internal or external);
A.2.3 Record student enrolment in a workshop;
A.2.4 Record student assessment submission, with date submitted and marks given.
B. Assessment Requirements
B.1 Report 2 marks
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 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 5 marks
Create a MySQL database using phpMyAdmin. You must name this database as your
username followed by A2. For example: rmason10A2.
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.
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.
B.5 Proof of Testing 1 mark
The results of your report queries should be added to your report (see B1). This can be a
screen dump of each query result inserted into your report, but MUST be readable. You
should paste each query into your report, then the results of that query.
EasyDue™ 支持PayPal, AliPay, WechatPay, Taobao等各种付款方式!
E-mail: firstname.lastname@example.org 微信:easydue