Mission 2 CSC72001 – Database Methods Net web page 1 of 4
College of Enterprise and Tourism
Database Methods (CSC72001)
Mission 2: Scholar Enrolment Database
Due Date: 11.30pm Friday Week 7
Submission: Add report (along with Question Assignment outcomes) and SQL script by means of MySCU
Weight: 15% of normal unit analysis
A. Exercise Description
A.1. Overview
Your exercise is to create and try a database in MySQL using PhpMyAdmin. You are provided
with a state of affairs and supporting paperwork, describing the requirements that Southern Cross
School may have for a database to take care of their scholar enrolments. You are provided
with lots of the design for such a database and would possibly need to create a relational database to
meet the consumer needs. Moreover, you will have in order so as to add sample information and create SQL queries to
current outcomes applicable for reporting.
A.2 State of affairs
Southern Cross School provides a variety of Bachelor ranges to varsity college students studying
internally all through campuses at Coffs Harbour, Lismore and the Gold Coast, along with by on-line
coaching. Scholar enrolments and their progress in objects should be saved in a database.
A strategies analyst has partially designed this database (see Entity Relationship Diagram
provided). You’ve got been launched into the mission to finish creating and testing the database
to Help SCU needs. Further to the ERD, SCU has provided you with some lists and
particulars about what knowledge should be saved for enrolment and recording of scholar
outcomes. A number of of the information for each of these lists has been provided throughout the file
SCUStudentEnrolment.xlsx, included with this analysis. The consumer had provided you with
as quite a bit as they know regarding the information requirements. As with most client-provided information, quite a bit
knowledge is duplicated throughout the sample information (the knowledge is not normalised), and the
spreadsheets do not replicate the finished database desk design.
You may should resolve on and set the data-types and lengths, along with finish the design of
the database. Together with storage of particulars about school college students, applications (paying homage to Bachelor
of IT), objects (paying homage to CSC72001), staff and workshops, you have to to allow for the subsequent:
A.2.1 Doc scholar enrolment in a course, along with enrolment date;
A.2.2 Doc scholar enrolment in a unit, along with the Session and the form of enrolment
(inside or exterior);
A.2.three Doc scholar enrolment in a workshop;
A.2.4 Doc scholar analysis submission, with date submitted and marks given.
Mission 2 CSC72001 – Database Methods Net web page 2 of 4
B. Analysis Requirements
B.1 Mission 2 Report 2 marks
Using the ERD offered and the knowledge requirements provided throughout the Excel file, you have to to
analyse the database needs of the consumer. You want to current an proof of your
database alternatives or information you’re feeling is expounded in your Mission 1 report. Some beneficial
headings for this report are included throughout the report template (obtainable on this
job folder):
 Client Enterprise Tips
 Assumptions Made
 Naming Conventions
 Info types chosen
B.2 MySQL database 5 marks
Create a MySQL database using phpMyAdmin. You might determine this database as your
username adopted by A2. As an illustration: eyuwon10A2.
You may assemble the required tables, columns, information types and relationships primarily based in your
analysis. You are free in order so as to add any tables you’re feeling are needed or would enhance the system.
You might embrace, nevertheless often usually are not restricted to, the consumer’s specific information requirements. You might
choose in order so as to add additional information columns to retailer totally different particulars about school college students, lecturers,
and so forth if you wish to take motion.
B.three Examine Info 1 mark
You might current adequate reliable information in your database to run the SQL queries beneath
effectively with not lower than 5-10 ensuing rows. Significantly, affiliation tables will should be
sufficiently populated to supply vital check out outcomes. You might seek advice from the provided sample
information for references on the knowledge format. Nonetheless, it is important analyse and rework the
sample information to be applicable in your database, e.g. you could be required to utilize your
assumption on some fields that are not obtainable throughout the sample information.
B.4 Export Script 1 mark
You might create an export script (.sql) to create a backup of all database constructions, along with
desk definitions and information.
B.5 Proof of Testing 1 mark
The outcomes of your report queries must be added to your Mission 2 report (see B1).
That is often a show dump of each Question Assignment finish end result inserted into your report, nevertheless MUST be
readable. You want to paste each Question Assignment into your report, then the outcomes of that Question Assignment.
Mission 2 CSC72001 – Database Methods Net web page three of 4
B.6 SQL Queries:
B.6.1 Workshop enrolment itemizing 1 mark
Create a Question Assignment to point out the workshop enrolment lists for all school college students enrolled in
Session three, 2019. The top end result must embrace the session, unit code, unit determine, campus
location, workshop day & time, tutor determine, scholar amount and scholar determine. The
finish end result must be sorted by the unit code, campus location, workshop day and time
then scholar ultimate determine and first determine.
B.6.2 Workshop rely itemizing 1 mark
Create a Question Assignment to point out the number of school college students who had been enrolled in workshops in
all durations for 2019. The top end result must embrace the session, unit code, unit determine,
campus location, tutor determine and the entire rely of students enrolled. The top end result
must be sorted by the Session, unit code, campus location and workshop day & time.
B.6.three Scholar Transcripts 1 mark
Create a Question Assignment to point out the information required for a Scholar Transcript. The top end result
must embrace the student amount, scholar determine, yr, session, unit
B.6.4 Scholar Analysis Totals 2 marks
Create a Question Assignment to point out the entire marks for each scholar’s assessments in all durations
for 2019. The top end result must embrace the student names, unit code, the sum of marks
given for his or her assessments and the final word grade given. It must be sorted by the
scholar’s ultimate determine and first determine, session, and unit code. Bear in mind: the final word grade is
entered by the unit assessor into the database, not calculated robotically from the
full.
C. Completely different Notes
C.1 Marking Requirements
Marking Requirements shall be made obtainable by means of a rubric on the MySCU site.
C.2 Submission Format
You might be required to submit your job provides every on the Infotech server, and by means of
the MySCU unit site. Your job submission must be inside the kind of a Phrase doc
and a SQL script textual content material file. Your Phrase doc must be named as your username_A2.doc
or username_A2.docx. (eg: eyuwon10_A2.docx) Your SQL script must be named as your
username_A2.sql (eg: eyuwon10_A2.sql).
C.three Distinctive work
This job should be achieved individually and should be your private distinctive work.
Alternate of ideas with totally different people can be thought-about educationally treasured nonetheless
excessive collaboration shall be considered plagiarism, which is a School offence. For
occasion, the copying of great components of a doc (or database) even when subsequently
modified, is plagiarism. Such tutorial dishonesty shall be penalised in accordance with the
School’s tips and legal guidelines. The analysis course of may require some school college students to
attend an interview in an effort to make clear components of their job.
Mission 2 CSC72001 – Database Methods Net web page 4 of 4
C.4 Retain duplicate copy
You are strongly prompt to retain a reproduction of distinctive work, and progressive variations of your
work in the middle of the Session. Throughout the event of any uncertainty regarding the submission of
analysis objects, it is doable you may be requested to breed a remaining copy and/or any earlier
variations of your work.
C.5 Penalty for late submission
A penalty of 10% per calendar day shall be utilized to all late assignments. An extension of time
will solely be thought-about (not primarily accredited) when a written request is submitted with
relevant supporting documentation and in accordance with School pointers.
C.6 Marks and Strategies
Marks and ideas suggestions shall be returned by means of your MySCU site for this unit.

Published by

Write

View all posts