You have been asked to design a database for a company that operates a gym in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been asked to design a database for a company that operates a gym in Canterbury. The database will store information about members, staff, day passes purchased, and scheduled classes. The gym employs fitness trainers who give classes, and some administrative staff with various job roles, e.g., manager, receptionist, etc. The data stored for each member of staff will include a unique staff number, their forename and surname, date of birth, gender, contact phone number and address, their starting date, and their leaving date. For trainers, their area of speciality will be recorded, while other members of staff will have their role recorded. Members may register at the gym as a monthly contract member or a pay per use member. Each member has a unique member number, and their forename, surname, date of birth, address, contact phone number, and summary details of medical conditions will also be recorded. For monthly contract members, the start date, price paid monthly, day of the month the payment is taken, and end date of the contract is recorded. No extra information is required for pay per use members. Pay per use members purchase day passes to use the gym and must purchase at least one when they register. For a day pass, the start date, number of days the pass is valid for, and the price paid for the day pass are recorded. The gym offers fitness classes every day with the possibility of a class being run more than once on a day. Each class is given by a single trainer, admin staff do not give classes. The maximum number of spaces and the level the class is for, i.e., beginner, intermediate, advanced, is also recorded. After members register with the gym, they can book scheduled classes. 1. [25 marks] Design a conceptual data model for the given scenario. a) Construct an ER diagram in UML. The diagram should show all entities, attributes of each entity, relationships between the entities with appropriate multiplicity constraints, and the coverage properties for any hierarchical relationships you have identified. b) State any assumptions necessary to resolve ambiguities in the scenario. Pay special attention to cardinalities and participation constraints. You have been asked to design a database for a company that operates a gym in Canterbury. The database will store information about members, staff, day passes purchased, and scheduled classes. The gym employs fitness trainers who give classes, and some administrative staff with various job roles, e.g., manager, receptionist, etc. The data stored for each member of staff will include a unique staff number, their forename and surname, date of birth, gender, contact phone number and address, their starting date, and their leaving date. For trainers, their area of speciality will be recorded, while other members of staff will have their role recorded. Members may register at the gym as a monthly contract member or a pay per use member. Each member has a unique member number, and their forename, surname, date of birth, address, contact phone number, and summary details of medical conditions will also be recorded. For monthly contract members, the start date, price paid monthly, day of the month the payment is taken, and end date of the contract is recorded. No extra information is required for pay per use members. Pay per use members purchase day passes to use the gym and must purchase at least one when they register. For a day pass, the start date, number of days the pass is valid for, and the price paid for the day pass are recorded. The gym offers fitness classes every day with the possibility of a class being run more than once on a day. Each class is given by a single trainer, admin staff do not give classes. The maximum number of spaces and the level the class is for, i.e., beginner, intermediate, advanced, is also recorded. After members register with the gym, they can book scheduled classes. 1. [25 marks] Design a conceptual data model for the given scenario. a) Construct an ER diagram in UML. The diagram should show all entities, attributes of each entity, relationships between the entities with appropriate multiplicity constraints, and the coverage properties for any hierarchical relationships you have identified. b) State any assumptions necessary to resolve ambiguities in the scenario. Pay special attention to cardinalities and participation constraints.
Expert Answer:
Related Book For
Advanced Financial Accounting
ISBN: 978-0137030385
6th edition
Authors: Thomas Beechy, Umashanker Trivedi, Kenneth MacAulay
Posted Date:
Students also viewed these programming questions
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Under the fair labor standards act - are covered and must be paid at least the minimum wage
-
A deposit of $4000 is made into an account that earns 11% annual simple interest. How much additional money must be deposited into an account that pays 14% annual simple interest so that the total...
-
Mary Granola loves to consume two goods, grapefruits and avocados. (a) On the graph below, the slope of an indifference curve through any point where she has more grapefruits than avocados is 2. This...
-
Discuss why NoSQL databases have gained huge popularity in recent years.
-
According to the National Health Statistics Reports, 16% of American women have one child, and 21% have two children. Is the probability that a woman has either one or two children equal to 0.16 +...
-
Capital budgeting methods, no income taxes. Riverbend Company runs hardware stores in a tri-state area. Riverbends management estimates that if it invests $160,000 in a new computer system, it can...
-
Harry sends amazing snapshottoher friend Lisa across the country. Briefly discuss the scenario of the communication networksinvolved.
-
On 1 August 2018, he joined his brother's company as a director of controlled company. Below are the income and benefits received during the year 2018: a. Monthly director fees of RM15,000. b....
-
Is private equitystyle investing consistent with the cardinal principles of Islamic finance?
-
What can regular education teachers who are concerned that they have not been adequately prepared for students with disabilities in the classroom do to protect themselves from liability?
-
What is pay back period? Also, discuss the utility of the pay back period in determining the internal rate of return.
-
Explain clearly the concept of block of assets vis-a-vis depreciation in the context of replacement situations of capital budgeting.
-
How does the firms level of risk aversion impact its propensity to hedge currency risk?
-
1. The December 31, 2009 balance sheet shows net fixed assets of $150,000 and the December 31, 2010 balance sheet shows net fixed assets of $250,000. Depreciation expense for 2009 is $25,000 and...
-
For what reason might an exporter use standard international trade documentation (letter of credit, draft, order bill of lading) on an intrafirm export to its parent or sister subsidiary?
-
Derive Maxwell's relations.
-
(a) The heat capacity at \(1 \mathrm{~atm}\) pressure of solid magnesium in the temperature range of 0 to \(560^{\circ} \mathrm{C}\) is given by the expression \[ C_{P}=6.2+1.33 \times 10^{-3} T+6.78...
-
A spherical balloon of \(1 \mathrm{~m}\) diameter contains a gas at \(120 \mathrm{kPa}\). The gas inside the balloon is heated until the pressure reaches \(360 \mathrm{kPa}\). During heating the...
Study smarter with the SolutionInn App