Southern Cross University CSC00228 Assessment 2 Report
VerifiedAdded on 2020/05/28
|8
|682
|165
Report
AI Summary
This report is a comprehensive assessment of a Database Systems assignment, likely for a course at Southern Cross University (CSC00228). It includes a cover sheet with student details, followed by a table of contents and an Entity Relationship Diagram. The report is divided into two main parts: Part A focuses on analysis, covering client business rules, assumptions, naming conventions, and data types. Part B presents and tests SQL queries, including workshop enrollment lists, workshop count lists, student transcripts, and student assessment totals. Each query is accompanied by its result, demonstrating the functionality and output of the database system. The report showcases the student's understanding of database design, SQL, and data management principles. The report provides a good example of a database assignment solution.

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: CSC00228
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> CSC00228 Assessment 2 Report Page 1
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: CSC00228
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> CSC00228 Assessment 2 Report Page 1
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

ASSESSMENT TWO
REPORT
BY <Insert your name>
<Student name and ID> CSC00228 Assessment 2 Report Page 2
REPORT
BY <Insert your name>
<Student name and ID> CSC00228 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..........................................................................................................................5
Part B: Testing Queries................................................................................................................................6
B.6.1 Workshop Enrolment List........................................................................................................6
B.6.2 Workshop Count List................................................................................................................6
B.6.3 Student Transcripts..................................................................................................................7
B.6.4 Student Assessment Totals......................................................................................................8
<Remove this text before submission of your assessment>
<After you have completed your assessment, right-click on the table of contents above and click
“Update Field” then “Update Page numbers only”. This will build the table of contents for you.>
<Student name and ID> CSC00228 Assessment 2 Report Page 3
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..........................................................................................................................5
Part B: Testing Queries................................................................................................................................6
B.6.1 Workshop Enrolment List........................................................................................................6
B.6.2 Workshop Count List................................................................................................................6
B.6.3 Student Transcripts..................................................................................................................7
B.6.4 Student Assessment Totals......................................................................................................8
<Remove this text before submission of your assessment>
<After you have completed your assessment, right-click on the table of contents above and click
“Update Field” then “Update Page numbers only”. This will build the table of contents for you.>
<Student name and ID> CSC00228 Assessment 2 Report Page 3
⊘ This is a preview!⊘
Do you want full access?
Subscribe today to unlock all pages.

Trusted by 1+ million students worldwide

Entity Relationship Diagram
<Student name and ID> CSC00228 Assessment 2 Report Page 4
<Student name and ID> CSC00228 Assessment 2 Report Page 4
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

Part A: Analysis
1. Client Business Rules
<rule 1>
<rule 2>
<rule 3>
<rule 4>
2. Assumptions Made
<information about your assumptions goes here>
3. Naming Conventions
To keep consistency, the database will use strict naming conventions that will allow easy
implementation and maintenance of the database when completed. The following
conventions apply:
- <convention 1>
- <convention 2>
- Etc
4. Data Types Chosen
<Information about why you have chosen the data types you have chosen for your
database.>
<Student name and ID> CSC00228 Assessment 2 Report Page 5
1. Client Business Rules
<rule 1>
<rule 2>
<rule 3>
<rule 4>
2. Assumptions Made
<information about your assumptions goes here>
3. Naming Conventions
To keep consistency, the database will use strict naming conventions that will allow easy
implementation and maintenance of the database when completed. The following
conventions apply:
- <convention 1>
- <convention 2>
- Etc
4. Data Types Chosen
<Information about why you have chosen the data types you have chosen for your
database.>
<Student name and ID> CSC00228 Assessment 2 Report Page 5

Part B: Testing Queries
B.6.1 Workshop Enrolment List
Query:
SELECT
ue.session,ue.unitcode,ue.unitName,w.location,w.weekday,w.classTimes,
w.teacher ,ue.student ,ue.firstname, ue.lastname FROM
`UNIT_ENROLLMENT` ue
join `UNITS` u on ue.unitcode=u.unitcode
left outer join `WORKSHOPS` w on w.unitcode=u.unitcode
where ue.session=1 and ue.Year=2015
order by ue.unitcode ASC, w.location ASC,w.weekday ASC,w.classtimes
ASC,ue.firstname ASC,ue.lastname ASC;
Result:
B.6.2 Workshop Count List
Query:
SELECT ue.session,we.unitcode,ue.unitName,w.location,
w.teacher ,COUNT(we.studentCode) AS "Total students enrolled"
FROM `WORKSHOP_ENROLLMENT` we
join `UNIT_ENROLLMENT` ue on ue.unitcode=we.unitcode
left outer join `WORKSHOPS` w on w.unitcode=we.unitcode
where ue.Year=2014
GROUP BY we.unitCode
order by ue.unitcode ASC, w.location ASC,w.weekday
ASC,w.classtimes ASC;
Result:
<Student name and ID> CSC00228 Assessment 2 Report Page 6
B.6.1 Workshop Enrolment List
Query:
SELECT
ue.session,ue.unitcode,ue.unitName,w.location,w.weekday,w.classTimes,
w.teacher ,ue.student ,ue.firstname, ue.lastname FROM
`UNIT_ENROLLMENT` ue
join `UNITS` u on ue.unitcode=u.unitcode
left outer join `WORKSHOPS` w on w.unitcode=u.unitcode
where ue.session=1 and ue.Year=2015
order by ue.unitcode ASC, w.location ASC,w.weekday ASC,w.classtimes
ASC,ue.firstname ASC,ue.lastname ASC;
Result:
B.6.2 Workshop Count List
Query:
SELECT ue.session,we.unitcode,ue.unitName,w.location,
w.teacher ,COUNT(we.studentCode) AS "Total students enrolled"
FROM `WORKSHOP_ENROLLMENT` we
join `UNIT_ENROLLMENT` ue on ue.unitcode=we.unitcode
left outer join `WORKSHOPS` w on w.unitcode=we.unitcode
where ue.Year=2014
GROUP BY we.unitCode
order by ue.unitcode ASC, w.location ASC,w.weekday
ASC,w.classtimes ASC;
Result:
<Student name and ID> CSC00228 Assessment 2 Report Page 6
⊘ This is a preview!⊘
Do you want full access?
Subscribe today to unlock all pages.

Trusted by 1+ million students worldwide

B.6.3 Student Transcripts
Query:
select student, concat (firstName, " ",lastname) AS "STUDENT
NAME", year, session, unitCode, unitName, finalGrade
from UNIT_ENROLLMENT
group by student,finalgrade
order by lastname asc,firstname asc,year asc,session asc,
unitcode asc;
Result:
B.6.4 Student Assessment Totals
Query:
<Student name and ID> CSC00228 Assessment 2 Report Page 7
Query:
select student, concat (firstName, " ",lastname) AS "STUDENT
NAME", year, session, unitCode, unitName, finalGrade
from UNIT_ENROLLMENT
group by student,finalgrade
order by lastname asc,firstname asc,year asc,session asc,
unitcode asc;
Result:
B.6.4 Student Assessment Totals
Query:
<Student name and ID> CSC00228 Assessment 2 Report Page 7
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

select ar.firstname,ar.lastname,ar.unit,SUM(marksAwarded) AS
"TOTAL MARKS",ue.finalGrade from ASSIGNMENT_RESULTS ar
join UNIT_ENROLLMENT ue on ue.lastName=ar.lastName
where ue.year=2014
group by ar.lastName
order by ar.lastname asc ,ar.firstname asc,ue.session,ar.unit;
Result:
<Student name and ID> CSC00228 Assessment 2 Report Page 8
"TOTAL MARKS",ue.finalGrade from ASSIGNMENT_RESULTS ar
join UNIT_ENROLLMENT ue on ue.lastName=ar.lastName
where ue.year=2014
group by ar.lastName
order by ar.lastname asc ,ar.firstname asc,ue.session,ar.unit;
Result:
<Student name and ID> CSC00228 Assessment 2 Report Page 8
1 out of 8
Related Documents

Your All-in-One AI-Powered Toolkit for Academic Success.
+13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
Unlock your academic potential
Copyright © 2020–2025 A2Z Services. All Rights Reserved. Developed and managed by ZUCOL.