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