Southern Cross University Assignment

SOUTHERN CROSS UNIVERSITY
ASSIGNMENT COVER SHEET
For use with online submission of assignments
Please complete all of the following details and then make this sheet the first page of
each file of your assignment – do not send it as a separate document.
Your assignments must be submitted as either Word documents, text documents
with .rtf extension or as .pdf documents. If you wish to submit in any other file format
please discuss this with your lecturer well before the assignment submission date.
Student Name:
Student ID No.:
Unit Name: Database Systems
Unit Code: CSC72001
Tutor’s name:
Assignment No.: Assessment 2
Assignment Title:
Due date:
Date submitted:
Declaration:
I have read and understand the Rules Relating to Awards (Rule 3 Section
18 – Academic Misconduct Including Plagiarism) as contained in the SCU
Policy Library. I understand the penalties that apply for plagiarism and
agree to be bound by these rules. The work I am submitting electronically is
entirely my own work.
Signed:
(please type
your name)
Date:
<Student name and ID> CSC72001 Assessment 2 Report Page 1

ASSESSMENT
TWO
REPORT
BY <Insert your name>
<Student name and ID> CSC72001 Assessment 2 Report Page 2

Table of contents:
Contents
Table of contents:............................................................................................3
Entity Relationship Diagram............................................................................4
Part A: Analysis................................................................................................5
1. Client Business Rules..............................................................................5
2. Assumptions Made..................................................................................5
3. Naming Conventions...............................................................................5
4. Data Types Chosen.................................................................................6
Part B: Testing Queries..................................................................................14
B.6.1 Workshop Enrolment List................................................................14
B.6.2 Workshop Count List.......................................................................14
B.6.3 Student Transcripts.........................................................................15
B.6.4 Student Assessment Totals.............................................................16
Bibliography:..................................................................................................17
<Student name and ID> CSC72001 Assessment 2 Report Page 3

Entity Relationship Diagram
<Student name and ID> CSC72001 Assessment 2 Report Page 4