[Solved]Create Erd Silver Gym Athletics Facility Offers Monthly Memberships Weight Training Studen Q37249182

CREATE AN ERD

Silver Gym is an athletics facility that offers monthlymemberships for weight-training to students, staff and faculty. Thefollowing are facts established in a preliminary phone interviewwith the owners:

• There are 11 certified Nutrition and Athletic Well-Being Advisorson staff.
• In addition to a full-size basketball court and an Olympic-gradelap pool, there are 57 independent exercise machines as well asover 85,000 pounds in free-weights.
• There is a gender-neutral sauna and free towel service after 3:00PM on week days
• The facility has 4 racquetball courts that can be converted topickle ball if reservations are made a day prior
• The 25-bike spin room and yoga floor has a side-entrance toRoosevelt Avenue.
• Anyone registering for the 3-month Yoga for Life and Beauty classis eligible for complimentary child-care at ‘Teeny-Toddlers’ acrossthe street.

The owners of Silver Gym would like a database designed to keeptrack of staff, members, their visits, exercise equipment,all maintenance and any incidents arising during operatinghours. One of their primary goals is to lower the occurrence ofinjuries related to faulty equipment. Design a database ERD in 3NFthat will allow them to better operate the business. Do not includepayroll or accounting.

Expert Answer

---

Answer to CREATE AN ERD Silver Gym is an athletics facility that offers monthly memberships for weight-training to students, staff… . . .