Database Design Assignment Help

General Information of Database Design 5915 and Database Design G 6672 Assignment 

The purpose of this assignment is to provide you with experience in analysing and designing a database for a given problem. It will help you to understand the nature and purpose of database analysis and design.

This assignment is an individual assignment. There are no restrictions on the use of word processors or similar tools for the production of submissions for this assignment.

Be sure to maintain regular back-ups for any models or material prepared with the aid of software. Loss of files will not be accepted as an excuse for non-completion of this assignment.

Submit your assignment to the Moodle site of this subject. Marked assignments will be available from Moodle website of this subject.

  1. Problem Description

The Magic Fitness Centre (MFC) was established recently. It has two branches in Canberra. MFC requires your team to design a database system to enable more smooth operation of the gym by providing timely information system to the MFC staff. The details of the branches of MFC are:

Branch nameAddressTelephone number
CF Dickson150 Camilla Way, Dickson, 2662, ACT62126666, 62127777
CF City121A Nortbourne Ave, Braddon 2612, ACT62612222

MFC database will record and store the data about each of its clients and gym instructors including first and last name, email address, home address (street number, street name, suburb, post-code, city, state), gender, date of birth and type of gym classes a client is enrolled in. The name (first and last name), contact telephone number and address (street number, street name, suburb, post-code, city, state) of client’s next-of-kin is also stored in MFC database.

MFC offers several types of gym classes. Gym classes are managed under class development section of MFC. There exist several types of gym classes. These are namely Body Balance, Body Pump and Yoga classes. A client can be enrolled in up to five different classes at anytime. Full gym membership price for a year is $800 for all normal clients and $400 for senior clients of MFC. Senior client is a person who is over 65 years old. There are also three and six months Gym memberships. The details and cost of MFC gym memberships are:

Gym membership IDGym membership typeCost (normal client)Cost (senior client)
M112 Months$800$400
M26 Months$400$200

There are casual rates for non-members of MFC too attend a class. Casual class rates are:

Class typeCost per hour
Body Balance$10 per class
Body Pump$10 per class
Yoga$8 per class

If a casual client wants to attend a class then the client should make a payment for his/her class before he/she can attend that class.

The payment for causal clients is made at MFC branches. Before the first class, a client is required to attend an interview with his/her instructor to access the client’s needs. The interview takes 10 minutes before the class.

When a client joins MFC he or she is assigned a client number and his/her details are recorded. Every client is provided with a client number and the rules of MFC.

Clients are not required to book for each class. However the detail of each client attending each class is stored by MFC. These details are Class type, Date, Time, Client number as well as the client first and last name.

MFC has several staff members in each branch. For each staff member the following data is stored in the database system of MFC: staff first and last name, staff number, position, gender, date of birth, name of the section he/she works in, branch telephone numbers and branch number.

For each instructor the following data is stored in MFC database: staff first and last name, instructor number, position, gender, date of birth, type of classes that an instructor can teach (i.e. Body Balance, Body Pump, Aqua aerobics, Yoga), branch telephone number and branch number of all branches in which the instructor teaches a class.

The information about each branch: branch name, address, telephone and fax number. Class time tables are stores in MFC database.

The instructor’s identity is established with their ID number and it is used to retrieve the details of the classes they teach. The details of each class (class number, Instructor ID number, date and time) are stored in the MFC database.

MFC website provides the class timetable and instructor availability facilities where a client can check the availability of a certain classes with the details of the class instructors teaching that class. The weekly timetable of classes is:

MondayTuesdayWednesdayThursdayFridaySaturday
9:00–10:00am
Body Balance Instructor: Mary Douglas
9:00–10:00am
Body Balance Instructor:Mary Douglas
9:00–10:00am
YogaInstructor:

Mary Douglas

9:00–10:00am
YogaInstructor:

Mary Douglas

9:00–10:00am
Body Balance  Instructor:Jim Lee
9:00–10:00am
Body Balance  Instructor:Arif Khan
10:00–11:00am
Yoga Instructor: John Bossy
10:00–11:00am
YogaInstructor:

John Bossy

10:00–11:00am
Body Pump Instructor:Sue Jones
10:00–11:00am
Body PumpInstructor:

John Bossy

10:00–11:00am
YogaInstructor: Andrew Low
10:00–11:00am
YogaInstructor:

John Bossy

1:00-2:.00pm
Body Pump Instructor: Jane Pontiac
1:00-2:.00pm
Body Pump Instructor:Jane Pontiac
1:00-2:.00pm
Body  Balance
Instructor:David Holden
1:00-2:.00pm
Body  Balance
Instructor:Jane Pontiac
1:00-2:.00pm
Body Pump
Instructor:Jane Pontiac
1:00-2:.00pm
Body Pump
Instructor:Helen Ford
5:00-6:00pm
Yoga Instructor:Ali Khan
5:00-6:00pm
YogaInstructor:

Ali Khan

5:00-6:00pm
YogaInstructor:

Jane Jones

5:00-6:00pm
YogaInstructor:

Jane Jones

5:00-6:00pm
YogaInstructor:

Helen Ford

5:00-6:00pm
YogaInstructor:

John Bossy

MFC keeps track of maintenance schedules for each of their gym equipment. A MFC staff contacts gym equipment suppliers as soon as a fault is report for any gym equipment to repair the equipment. The details of the faulty equipments as well as the staff umber of MFC staff that reported the fault to a supplier, with the date and time of equipment fault report is stored in MFC database. MFC has several gym equipment suppliers. For each supplier the following data is stored in the database system of MFC: supplier name, supplier number, address, telephone number. Equipment details are also stored in MFC database. These details are: equipment number, equipment name, cost and date of purchase as well as supplier number.

MFC has two seminar rooms. These seminar rooms are rented to any customer that wants to organise a seminar. The cost of hire of a seminar room is $400 per day. Seminar room details are stored in MFC database. The seminar room details are room number, room size, room location and rental price per day. Detail of customers that hire a seminar room is also stored in the MFC database. These details are customer number, customer first and last name, dates for which a seminar room is hired (i.e. start date and end date). MFC provides food if required for any seminar booked at MFC. The details stored about all seminar rooms hired and food provided is recorded in the MFC database. For each seminar, the number of guests is recorded in the MFC database and the type and price of food ordered for each seminar is also recorded in the database of MFC. Order Now

Maddox Smith

Hey,
Greetings for the day !
Hope that you’re well !

We want to introduce ourselves as a team of professionals who are into academic writing for the last 10+ years. We can provide assignment assistance in all subjects. Our experts can provide solutions across all the topics right from Management, HR, Marketing, Finance & Accounts, Statistics, IT, childcare, nursing, law, and general writing. We provide plagiarism free work and also send a ‘Turnitin’ report along with completed work. Our services are available at reasonable cost; we entertain amendment requests from clients without any extra charges.

Our Feature Included

Ø Every assignment includes graphical representation like pie chart, bar graph, smart art and all.
Ø Free 0% plagiarism report
Ø Expert team for technical work as well.
Ø On time delivery
Ø Multiple rework facility
Ø Huge team of expert in each subject
Ø Referencing like: Harvard, APA, MLA, Oscola, automatic referencing all are familiar to our experts.

Subject we cover: Math , finance, economics, accounts, civil engineering, mechanical engineering, IT, Computer science, electrical and electronics engineering, history, geography, political science, sociology, physiology, philosophy, biology, microbiology, biotechnology, biotechnology, B-school assignments, project report, psychology, nursing assignments, medical assignments, Tourists and travelling assignments all kinds of dissertation and so on

Best Regards:
Oz Paper Help
WhatsApp:+1 585-666-2225
Email:ozpaperhelp@gmail.com
www.ozpaperhelp.com
www.cheapassignmenthelp.co.uk
www.freeassignmenthelp.com

https://www.ozpaperhelp.com/
1 Step 1
GET INSTANT ASSIGNMENT HELP BY PHD EXPERTS FROM UNITED KINGDOM
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right