Located on the Melbourne campus of Edvantage Institute Australia, Edvantage Sport is a fitness and aquatics...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Located on the Melbourne campus of Edvantage Institute Australia, Edvantage Sport is a fitness and aquatics centre that provide a wide range of facilities and programs to keep their members active and healthy. As a database designer, you are asked to help Edvantage Sport to create an efficient database management system to record all the relevant data collected in their daily operations and management. The manager shared their business process with you in the following statements: Edvantage Sport is open to both Edvantage Institute students, staff and anyone from local community. Membership can be categorized into three levels of access: Fitness (access to fitness centre and group fitness classes), Aquatics (swimming pool and swimming classes), and Fitness + Aquatics (Unlimited to all facilities and classes). Membership can be purchased as single access, single monthly access, 3-month access and 12-month access. Edvantage staff and students have 30% discount on all membership fees. Swimming classes are open for children and adults separately. Members can join any class at low, medium and high levels. Totally, six different swimming classes are organized. Edvantage Sport employs 10 instructors to take charge of these classes. Each class runs 1 hour three times every week. One instructor can take care of at most 5 members in each class. At most 10 members can join the same class at the same time. Fitness classes are set for Body fitness, Zumba, Abs, Yoga, Pilates and Cycle. Each class runs 1 hour three times a week, and one instructor takes charge of the class of maximum 15 members. Body fitness and Abs classes are conducted in the general gym room. Zumba, Yoga and Pilates classes use any of the two exercises rooms, and . the Cycle classes are run in the Cycle room only. Member needs to enrol into classes at least 10 minutes before it starts. If the class is full, it is closed for enrolment immediately. Edvantage Sport centre opens from 6am to 9pm every day. Members can use the fitness and aquatics facilities anytime within the business hours by scanning the barcode their membership card at the entrance. A unique member number is assigned automatically when a new member joins the centre. 1. Revise your ERD from Assessment 1 submission by fixing all the errors according to the sample ERD solution in the attachment. The revised ERD needs to include all the essential entities and the corresponding relationships. You can keep all the additional entities and relationship in your design. You cannot use the sample ERD solution directly. (10 marks) 2. Map the revised ERD into a set of relations in at least third Normal Forms (3NFs) via normalization techniques. The process of normalization needs to be clearly shown step-by-step using dependency diagrams. That is, you need to list all the relations in 1NF, 2NF and 3NF. (40 marks) 3. Design and create an appropriate data dictionary. In the data dictionary, all the entities and attributes are listed with the standard formats. (30 marks) 4. Implement your database to create all required relations in MySQL. You need to write appropriate SQL statements to create the relational database according to your design of ER diagram, 3NF relations, and data dictionary from the previous tasks. Populate your database with at least 10 data samples in each relation. (20 marks) Located on the Melbourne campus of Edvantage Institute Australia, Edvantage Sport is a fitness and aquatics centre that provide a wide range of facilities and programs to keep their members active and healthy. As a database designer, you are asked to help Edvantage Sport to create an efficient database management system to record all the relevant data collected in their daily operations and management. The manager shared their business process with you in the following statements: Edvantage Sport is open to both Edvantage Institute students, staff and anyone from local community. Membership can be categorized into three levels of access: Fitness (access to fitness centre and group fitness classes), Aquatics (swimming pool and swimming classes), and Fitness + Aquatics (Unlimited to all facilities and classes). Membership can be purchased as single access, single monthly access, 3-month access and 12-month access. Edvantage staff and students have 30% discount on all membership fees. Swimming classes are open for children and adults separately. Members can join any class at low, medium and high levels. Totally, six different swimming classes are organized. Edvantage Sport employs 10 instructors to take charge of these classes. Each class runs 1 hour three times every week. One instructor can take care of at most 5 members in each class. At most 10 members can join the same class at the same time. Fitness classes are set for Body fitness, Zumba, Abs, Yoga, Pilates and Cycle. Each class runs 1 hour three times a week, and one instructor takes charge of the class of maximum 15 members. Body fitness and Abs classes are conducted in the general gym room. Zumba, Yoga and Pilates classes use any of the two exercises rooms, and . the Cycle classes are run in the Cycle room only. Member needs to enrol into classes at least 10 minutes before it starts. If the class is full, it is closed for enrolment immediately. Edvantage Sport centre opens from 6am to 9pm every day. Members can use the fitness and aquatics facilities anytime within the business hours by scanning the barcode their membership card at the entrance. A unique member number is assigned automatically when a new member joins the centre. 1. Revise your ERD from Assessment 1 submission by fixing all the errors according to the sample ERD solution in the attachment. The revised ERD needs to include all the essential entities and the corresponding relationships. You can keep all the additional entities and relationship in your design. You cannot use the sample ERD solution directly. (10 marks) 2. Map the revised ERD into a set of relations in at least third Normal Forms (3NFs) via normalization techniques. The process of normalization needs to be clearly shown step-by-step using dependency diagrams. That is, you need to list all the relations in 1NF, 2NF and 3NF. (40 marks) 3. Design and create an appropriate data dictionary. In the data dictionary, all the entities and attributes are listed with the standard formats. (30 marks) 4. Implement your database to create all required relations in MySQL. You need to write appropriate SQL statements to create the relational database according to your design of ER diagram, 3NF relations, and data dictionary from the previous tasks. Populate your database with at least 10 data samples in each relation. (20 marks)
Expert Answer:
Related Book For
Operations management processes and supply chain
ISBN: 978-0136065760
9th edition
Authors: Lee J Krajewski, Larry P Ritzman, Manoj K Malhotra
Posted Date:
Students also viewed these databases questions
-
Discuss the procedures of decision making for a person with mental impairment
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Refer to Exercise. a. Are the required conditions satisfied? b. Is multicollinearity a problem? If so, explain the consequences.
-
What methods are used in practice to determine the extent of progress toward completion? Identify some input measures and some output measures that might be used to determine the extent of progress.
-
1. lim a, In n Vn
-
For the accounts of her business Rebecca Goumas uses sales, purchases, cash receipts, cash payments and general journals along with subsidiary ledgers for accounts receivable and accounts payable....
-
Newbirth Coatings Company purchased waterproofing equipment on January 2, 2009, for $380,000. The equipment was expected to have a useful life of four years, and a residual value of...
-
(a) The equity share of VCC Ltd. is quoted at Rs. 210. A 3-month call option is available at a premium of Rs. 6 per share and a 3-month put option is available at a premium of Rs. 5 per share....
-
1. What might Lewis have done to avoid the result in this case? Discuss. 2. Suppose that Lewis had already been reimbursed for the two vehicles that had been sold, and Whitney sought to obtain the...
-
Practice 2 You have the following index portfolio data Stock A B C Total As of December 31, 2020 Share Price # shares Market Value $10 $20 $60 $90 3,000 1,000 500 4,500 $30,000 $20,000 $30,000...
-
What is output by the following? A. 3 10 B. 3 12 C. 5 10 D. 5 12 E. The code does not compile. F. None of the above. 10: int m = 0, n = 0; 11: while (m < 5) { 12: 13: 14: 15: 16: 17: 18: 19: 20: 21:...
-
Assume there is a class Bouncer with a protected variable. Methods in which class can access this variable? A. Any subclass of Bouncer or any class in the same package as Bouncer B. Any superclass of...
-
Variables declared as which of the following are never permitted in a switch statement? (Choose two.) A. var B. double C. int D. String E. char F. Object
-
Given the following enum and class, which option fills in the blank and allows the code to compile? enum Season { SPRING, SUMMER, WINTER } public class Weather { } public int getAverage Temperate...
-
A local class can access which type of local variables? (Choose two.) A. final B. private C. effectively final D. static E. default F. const
-
Find the midpoint for each class. Midpoint = upper class limit + lower class limit 2 Number of College aslo ot oniqning Credits Completed 9-31 32-54 55-77 78-100 101-123 Frequency 15 15 53 13 4 6...
-
Rewrite the code of Figure 7.3 in Ada, Java, or C#. Figure 7.3: template class queue { item items [max_items]; int next_free, next_full, num_items; public: queue () : next_free (0), next_full(0),...
-
Sams Cat Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about...
-
Return to Problem 11 and the workforce schedule for part-rime loading dock workers. Suppose that each part- time worker can work only 3 days but the days must be consecutive. Devise an approach to...
-
Figure shows the BOMs for two products. A and B. Table shows the MPS quantity start date for each one. Table contains data from inventory records for items C, D, and E. There are no safety stock...
-
Discuss how a new brand manufacturer would go about defining their market segments and then begin to target them.
-
Go to www.kellogs.com, and examine the brands offered by Kelloggs. Using the BCG growth-share matrix, classify 10 brands as stars, question marks, cash cows, or dogs. Find at least one product you...
-
Diff Eyewear is a successful business built around a socially conscious mission. The company makes and sells stylish eyewear with comparable quality but a significantly lower price than luxury...
Study smarter with the SolutionInn App