Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ITECH 1006 Database Management System

tag 0 Download 6 Pages / 1,360 Words tag 09-07-2021

Question:

You have been commissioned to create a database for TopFit, a company that runs a gym in Albury. TopFit offers a variety of fitness, strength and conditioning courses for members at various times. The gym provides top quality teachers and excellent equipment for the training of members.

All of TopFit’s courses consist of several classes, taught by TopFit staff. Each course has a number of classes with a maximum number of participants and some courses have prerequisites (for example, to enrol in “Advanced Cardio-fit”, members have to have successfully completed “Introductory Cardio-fit”). Anyone can sign up as a member and enrol in one or more courses at TopFit. Members can pay by different methods, either by monthly membership, or per day (they can attend as many classes as they wish on any given day).

The following business rules and information gathered about the current business activities will allow you to derive entities. Your submission is not expected to have many to many relationships left unresolved.  You may add entities or attributes as you see fit. Assumptions can be made to include further entities and their relationships, but referential integrity and normalisation processes must be adhered to. Reasons should be given for any relation that is not maintained in 3NF.

  • TopFit employs many staff members, keeping track of their unique ID, name, phone number, address and email, as well as tax number, job title and weekly rate of pay.
  • Course types run by TopFit have a name, number of classes, a course description and a maximum student number. Some course types have another course type as prerequisite.
  • Courses run by TopFit from time to time belong to a course type, are assigned to a supervising staff member and have a starting and end date. They also allow staff to records notes about the course.
  • Members are recorded by name, address, email, phone number, date of birth and notes about special requirements (dietary or health problems). An emergency contact name and number are also recorded. Additionally, the date of joining up is recorded, and if the member has left, the date of leaving as well. Current members have a joining date but no leaving date.
  • If the member makes regular monthly payments, the following details need to be stored: bank name, account type (savings, cheque or credit), account number and account name.
  • Members can enrol in one or more of TopFit gym courses, and they can attend as many classes as they wish on any day.
  • Members have 3 different methods of paying. All payments recorded by staff include a date paid, amount paid and the member’s ID. Additionally:
    • If the payment method is “Automatic Monthly”, then success or failure of the direct debit is recorded (if the payment failed, staff will contact the member).
    • If the payment method is “Single Day”, the payment method is recorded.
    • If the payment method is “Multiple Pass”, then the number of days on the pass is recorded (this can be 10, 20 or 50), as well as the payment method.
  • TopFit tracks every class, recording the id of the staff member who taught the class (this can be any staff member, not just the supervisor for the course), the date and time, the id of the course it belongs to, the room used and any notes the teacher wishes to record.
  • The participation of each member in each class is recorded.
  • Members can earn awards for successful completion of courses or for other achievements. TopFit has many award types (for example: “Monthly Hero”, “Most improved Beginner” and “Successful completion of Level 3 Strength Training”). For each award type, the gym has an id, name and description of competencies.
  • TopFit also maintain a register of all awards earned by members, showing the date awarded, member, award type and special notes. If the award is for a completed course, then the course id is recorded as well, so that a certificate can be issued to the member.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 6 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). ITECH 1006 Database Management System. Retrieved from https://myassignmenthelp.com/free-samples/itech1006-database-management-system/relationship-diagram.html.

"ITECH 1006 Database Management System." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/itech1006-database-management-system/relationship-diagram.html.

My Assignment Help (2021) ITECH 1006 Database Management System [Online]. Available from: https://myassignmenthelp.com/free-samples/itech1006-database-management-system/relationship-diagram.html
[Accessed 07 February 2023].

My Assignment Help. 'ITECH 1006 Database Management System' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/itech1006-database-management-system/relationship-diagram.html> accessed 07 February 2023.

My Assignment Help. ITECH 1006 Database Management System [Internet]. My Assignment Help. 2021 [cited 07 February 2023]. Available from: https://myassignmenthelp.com/free-samples/itech1006-database-management-system/relationship-diagram.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.