2- Data Management

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.: 24013642
Unit Name: Data Management
Unit Code: DATA5001
Tutor’s name: VIUMKTHI
Assignment No.: Assessment 1
Assignment Title: Data Analysis
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:

ASSESSMENT
ONE
REPORT
BY

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 6
B.6.4 Student Assessment Totals 6

 
Entity Relationship Diagram

Part A: Analysis

1. Client Business Rules
•
•
•
•

2. Assumptions Made

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:
–
–
– Etc

4. Data Types Chosen

 
Part B: Testing Queries

B.6.1 Workshop Enrolment List
Query:
Paste your actual query here (not a screenshot)

Result:

B.6.2 Workshop Count List
Query:

Result:

B.6.3 Student Transcripts
Query:

Result:

B.6.4 Student Assessment Totals
Query:

Result: