Project 2 CSC72001 – Database Techniques Web page 1 of four
Faculty of Enterprise and Tourism
Database Techniques (CSC72001)
Project 2: Scholar Enrolment Database
Due Date: 11.30pm Friday Week 7
Submission: Add report (together with question outcomes) and SQL script by way of MySCU
Weight: 15% of general unit evaluation
A. Activity Description
A.1. Overview
Your activity is to create and take a look at a database in MySQL utilizing PhpMyAdmin. You’re supplied
with a situation and supporting paperwork, describing the necessities that Southern Cross
College could have for a database to deal with their scholar enrolments. You’re supplied
with a lot of the design for such a database and might want to create a relational database to
meet the shopper wants. Additionally, you will want so as to add pattern knowledge and create SQL queries to
present outcomes appropriate for reporting.
A.2 State of affairs
Southern Cross College supplies a wide range of Bachelor levels to college students learning
internally throughout campuses at Coffs Harbour, Lismore and the Gold Coast, in addition to by on-line
training. Scholar enrolments and their progress in items must be saved in a database.
A methods analyst has partially designed this database (see Entity Relationship Diagram
supplied). You have got been introduced into the mission to complete creating and testing the database
to help SCU wants. Extra to the ERD, SCU has supplied you with some lists and
particulars about what data must be saved for enrolment and recording of scholar
outcomes. A few of the knowledge for every of those lists has been supplied within the file
SCUStudentEnrolment.xlsx, included with this evaluation. The shopper had supplied you with
as a lot as they know in regards to the knowledge necessities. As with most client-provided knowledge, a lot
data is duplicated within the pattern knowledge (the information isn’t normalised), and the
spreadsheets don’t replicate the completed database desk design.
You’ll have to resolve on and set the data-types and lengths, in addition to end the design of
the database. Along with storage of details about college students, programs (reminiscent of Bachelor
of IT), items (reminiscent of CSC72001), workers and workshops, you will need to enable for the next:
A.2.1 Document scholar enrolment in a course, together with enrolment date;
A.2.2 Document scholar enrolment in a unit, together with the Session and the kind of enrolment
(inner or exterior);
A.2.three Document scholar enrolment in a workshop;
A.2.four Document scholar evaluation submission, with date submitted and marks given.
Project 2 CSC72001 – Database Techniques Web page 2 of four
B. Evaluation Necessities
B.1 Project 2 Report 2 marks
Utilizing the ERD provided and the information necessities supplied within the Excel file, you will need to
analyse the database wants of the shopper. You need to present an evidence of your
database selections or knowledge you are feeling is related in your Project 1 report. Some recommended
headings for this report are included within the report template (obtainable on this
task folder):
 Consumer Enterprise Guidelines
 Assumptions Made
 Naming Conventions
 Information sorts chosen
B.2 MySQL database 5 marks
Create a MySQL database utilizing phpMyAdmin. You could identify this database as your
username adopted by A2. For instance: eyuwon10A2.
You’ll construct the required tables, columns, knowledge sorts and relationships based mostly in your
evaluation. You’re free so as to add any tables you are feeling are wanted or would improve the system.
You could embrace, however usually are not restricted to, the shopper’s particular knowledge necessities. You could
select so as to add further knowledge columns to retailer different details about college students, lecturers,
and so forth if you want to take action.
B.three Check Information 1 mark
You could present sufficient legitimate knowledge in your database to run the SQL queries beneath
efficiently with not less than 5-10 ensuing rows. Particularly, affiliation tables will must be
sufficiently populated to offer significant take a look at outcomes. You could confer with the supplied pattern
knowledge for references on the information format. Nevertheless, it’s essential analyse and rework the
pattern knowledge to be appropriate on your database, e.g. you may be required to make use of your
assumption on some fields that aren’t obtainable within the pattern knowledge.
B.four Export Script 1 mark
You could create an export script (.sql) to create a backup of all database constructions, together with
desk definitions and knowledge.
B.5 Proof of Testing 1 mark
The outcomes of your report queries ought to be added to your Project 2 report (see B1).
This is usually a display dump of every question end result inserted into your report, however MUST be
readable. You need to paste every question into your report, then the outcomes of that question.
Project 2 CSC72001 – Database Techniques Web page three of four
B.6 SQL Queries:
B.6.1 Workshop enrolment listing 1 mark
Create a question to show the workshop enrolment lists for all college students enrolled in
Session three, 2019. The end result ought to embrace the session, unit code, unit identify, campus
location, workshop day & time, tutor identify, scholar quantity and scholar identify. The
end result ought to be sorted by the unit code, campus location, workshop day and time
then scholar final identify and first identify.
B.6.2 Workshop depend listing 1 mark
Create a question to show the variety of college students who had been enrolled in workshops in
all periods for 2019. The end result ought to embrace the session, unit code, unit identify,
campus location, tutor identify and the whole depend of scholars enrolled. The end result
ought to be sorted by the Session, unit code, campus location and workshop day & time.
B.6.three Scholar Transcripts 1 mark
Create a question to show the knowledge required for a Scholar Transcript. The end result
ought to embrace the coed quantity, scholar identify, yr, session, unit
B.6.four Scholar Evaluation Totals 2 marks
Create a question to show the whole marks for every scholar’s assessments in all periods
for 2019. The end result ought to embrace the coed names, unit code, the sum of marks
given for his or her assessments and the ultimate grade given. It ought to be sorted by the
scholar’s final identify and first identify, session, and unit code. Be aware: the ultimate grade is
entered by the unit assessor into the database, not calculated robotically from the
complete.
C. Different Notes
C.1 Marking Standards
Marking Standards shall be made obtainable by way of a rubric on the MySCU web site.
C.2 Submission Format
You may be required to submit your task supplies each on the Infotech server, and by way of
the MySCU unit web site. Your task submission ought to be within the type of a Phrase doc
and a SQL script textual content file. Your Phrase doc ought to be named as your username_A2.doc
or username_A2.docx. (eg: eyuwon10_A2.docx) Your SQL script ought to be named as your
username_A2.sql (eg: eyuwon10_A2.sql).
C.three Unique work
This task have to be accomplished individually and have to be your personal unique work.
Alternate of concepts with different individuals will be thought-about educationally precious nonetheless
extreme collaboration shall be thought to be plagiarism, which is a College offence. For
instance, the copying of serious elements of a doc (or database) even when subsequently
modified, is plagiarism. Such tutorial dishonesty shall be penalised in accordance with the
College’s guidelines and laws. The evaluation course of could require some college students to
attend an interview in an effort to clarify elements of their task.
Project 2 CSC72001 – Database Techniques Web page four of four
C.four Retain duplicate copy
You’re strongly suggested to retain a replica of unique work, and progressive variations of your
work in the course of the Session. Within the occasion of any uncertainty relating to the submission of
evaluation objects, it’s possible you’ll 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 essentially accredited) when a written request is submitted with
applicable supporting documentation and in accordance with College pointers.
C.6 Marks and Suggestions
Marks and suggestions feedback shall be returned by way of your MySCU web site for this unit.

Published by
Write
View all posts