Database Systems (CSC72001) Assignment 3 Report: Analysis and Design

This document is a report for a Database Systems assignment (CSC72001) at Southern Cross University. The report covers the analysis and design of a database system, including client business rules, assumptions, and naming conventions. The report outlines the business rules for a club management system, detailing relationships between clubs, managers, facilities, instructors, and classes. Assumptions made during the database design process are outlined, focusing on membership and personal training tracking. Furthermore, the report specifies naming conventions used for entities and attributes. The assignment includes an Entity Relationship Diagram to visually represent the database schema. This report is a valuable resource for students studying database design and implementation. The assignment also includes an overview of the naming conventions followed in the database design.

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 3
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 3 Report Page 1

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

Table of contents:
Contents
Table of contents:........................................................................................................................................3
Entity Relationship Diagram........................................................................................................................4
Part A: Analysis and Design.........................................................................................................................5
1. Client Business Rules.......................................................................................................................5
2. Assumptions Made..........................................................................................................................5
3. Naming Conventions........................................................................................................................5
<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> CSC72001 Assessment 3 Report Page 3

Entity Relationship Diagram
Part A: Analysis and Design
1. Client Business Rules
 One club may have many managers but one manager can work at one club only
 Many clubs provide many facilities but a facility may not be provided by any club
<Student name and ID> CSC72001 Assessment 3 Report Page 4

 One instructor can take class at specific club on specific time but many classes on same
time in different clubs can be taken by many instructors
 One club can provide many or only two compulsory facilities, one facility can be offered
by many clubs
 One club can provide many classes, one class can be offered by many clubs
 Each class must be instructed by an instructor
2. Assumptions Made
The main assumption made during the database design is that database will record personal
training count and class only membership count through views. The child entities of
member entity will not have any attribute as they only differ by name and other differences
happen in operational level which not concern of database. Third assumption is that
organization will not record which member is coming to which club, instead database will
only record the home club id.
3. Naming Conventions
- First letter of entity is always in capital
- Attributes are in singular form. It entails that attributes are atomic
- If combination of two or more words are used then first letter of attribute is small
caption and first letter of later words are in capital caption
<Student name and ID> CSC72001 Assessment 3 Report Page 5