Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4.43 should be the final schema (word version of the table w/ attributes) of tables resulting from the normalization process. TABLENAME(PrimaryKey(s), Foreign Key(s) , OtherField(s))
4.43 should be the final schema (word version of the table w/ attributes) of tables resulting from the normalization process.
TABLENAME(PrimaryKey(s), Foreign Key(s), OtherField(s)) Order doesn't really matter other than Primary Key(s) should be first.
dern exercise equip The Quincy Bay Sports Club owns and operates three sports club facilities in Boston bridge, and Quincy, Massachusetts. Each facility has a large selection of modern exercis ment, weight rooms, and rooms for yoga and other exercise classes. Quincy Bay offers 3-m and 1-year memberships. Members can use the facilities at any of the three club locatione Quincy Bay maintains a roster of personal trainers who operate as independent sultants. Approved trainers can schedule appointments with clients at Quincy Bay far as long as their client is a member of the club. Trainers also teach yoga, Pilates, and a classes. Answer the following questions, assuming you have been provided the following three tables of data (PT stands for personal trainer): PT SESSION (Trainer, Phone, EmailAddress, Fee, ClientLastName, ClientFirstName, ClientPhone, ClientEmailAddress, Date, Time) CLUB_MEMBERSHIP (Client Number, ClientLastName, ClientFirstName. ClientPhone, ClientEmailAddress, Membership Type, EndingDate, Street, City, State, ZIP) CLASS (ClassName, Trainer, StartDate, EndDate, Time, DayOfWeek, Cost) 4.39 Identify possible multivalued dependencies in these tables. 4.40 Identify possible functional dependencies in these tables. 4.41 Determine whether each table is either in BCNF or in 4NF. State your assumptions. 4.42 Modify each of these tables so that every table is in BCNF and 4NF. Use the assumptions you made in your answer to Question 4.41. Do not indicate primary or foreign keys. 4.43 Using these tables and your assumptions, recommend a design, including primary and foreign keys, for an updatable database. 4.44 Add a table to your answer to Question 4.43 that would allow Quincy Bay to assign members to particular classes. Include an Amount Paid column in your new table. 4.45 Recommend a design for a read-only database that would support the following needs: A. Enable trainers to ensure that their clients are members of the club. B. Enable the club to assess the popularity of various trainers. C. Enable the trainers to determine if they are assisting the same client. D. Enable class instructors to determine if the attendees to their classes have paidStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started