The Elliot Bay Sports Club owns and operates three sports club facilities in Hou

Question

The Elliot Bay Sports Club owns and operates three sports club facilities in Houston, Texas. Each facility has a large selection of modern exercise equipment, weight rooms, and rooms for yoga and other exercise classes. Elliot Bay offers 3-month and 1-year memberships. Members can use the facilities at any of the three club locations.

Elliot Bay maintains a roster of personal trainers who operate as independent consultants. Approved trainers can schedule appointments with clients at Elliot Bay facilities, as long as their client is a member of the club. Trainers also teach yoga, Pilates, and other 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, Email, Fee, ClientLastName, ClientFirstName,

ClientPhone, ClientEmail, Date, Time)

CLUB_MEMBERSHIP (ClientNumber, ClientLastName, ClientFirstName, ClientPhone,

ClientEmail, MembershipType, EndingDate, Street, City, State, Zip)

CLASS (ClassName, Trainer, StartDate, EndDate, Time, DayOfWeek, Cost)

QUESTION:

Determine whether each table is either BCNF or in 4NF. State your assumptions

Explanation / Answer

possible multivalued dependencies in these Tables.

PT_SESSION.Trainer ->> PT_SESSION.Phone

PT_SESSION.ClientName ->> PT_SESSION.ClientPhone

CLUB_MEMBERSHIP.ClientNumber ->> CLUB_MEMBERSHIP.ClientPhone

CLUB_MEMBERSHIP.ClientName ->> CLUB_MEMBERSHIP.ClientPhone

possible functional dependencies in these tables.

FOR PT_SESSION:
PT_SESSION.Trainer -> PT_SESSION.EMail

PT_SESSION.Trainer -> PT_SESSION.Fee

PT_SESSION.ClientName -> PT_SESSION.ClientEmail

PT_SESSION.(Trainer, Date, Time) -> PT_SESSION.ClientName.

FOR CLUB_MEMBERSHIP:
CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.ClientName

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.ClientEmail

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.MembershipType

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.EndingDate

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.Street

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.City

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.State

CLUB_MEMBERSHIP.ClientNumber -> CLUB_MEMBERSHIP.Zip

FOR CLASS
CLASS.(ClassName, Trainer, StartDate, Time) -> CLASS.EndDate

CLASS.(ClassName, Trainer, StartDate, Time) -> CLASS.DayOfWeek

CLASS.(ClassName, Trainer, StartDate, Time) -> CLASS.Cost

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.