DTB91001 Data Management Systems Assignment 3 2022

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: Data Management Systems
Unit Code: DTB91001
Tutor’s name:
Assignment No.: Assignment 3
Assignment Title: Practical Skills – Database
Development and Testing
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:
DTB91001: Assignment 3 Report Page 1

Assignment 3
REPORT
BY <Insert your name>
DTB91001: Assignment 3 Report Page 2

Table of contents:
Contents
Table of contents:....................................................................................................... 3
Enhanced-Entity Relationship Diagram (EERD)..........................................................4
Part A: Analysis and Design........................................................................................ 5
1. Client Business Rules........................................................................................ 5
2. Assumptions Made............................................................................................ 5
3. Naming Conventions......................................................................................... 5
4. Data Types Chosen........................................................................................... 6
Part B: Testing Queries............................................................................................... 6
1. Club Facilities...................................................................................................... 6
2. Members list for a class....................................................................................... 7
3. Counting club members...................................................................................... 7
4. Personal trainers................................................................................................. 7
5. Club manager information...................................................................................8
6. Trainers specialised in weight loss......................................................................8
7. Members statistic................................................................................................ 9
8. Club timetable..................................................................................................... 9
DTB91001: Assignment 3 Report Page 3