7830TextProjectAnswersCh4

7830TextProjectAnswersCh4 - Chapter Four Database Design...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter Four Database Design Using Normalization Page 4-1 ANSWERS TO PROJECT QUESTIONS 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 three-month and one- 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 the 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, ClientName, ClientPhone, ClientEmail, Date, Time) CLUB_MEMBERSHIP (ClientNumber, ClientName, ClientPhone, ClientEmail, MembershipType, EndingDate, Street, City, State, Zip) CLASS (ClassName, Trainer, StartDate, EndDate, Time, DayOfWeek, Cost) 4.1 Identify possible multivalued dependencies in these tables. VARIABLE ANSWER - There are several true possible multivalued dependencies based on phone numbers, and these are shown below. There could also be a similar set for e-mail addresses, but we will not include these. However, your students may include them depending on their assumptions. PT_SESSION.Trainer ÆÆ PT_SESSION.Phone PT_SESSION.ClientName ÆÆ PT_SESSION.ClientPhone CLUB_MEMBERSHIP.ClientNumber ÆÆ CLUB_MEMBERSHIP.ClientPhone CLUB_MEMBERSHIP.ClientName ÆÆ CLUB_MEMBERSHIP.ClientPhone 4.2 Identify possible functional dependencies in these tables. VARIABLE ANSWER – Based on some assumptions that have to be made – which in the real world would be checked with Elliot Bay and clarified – and their answer to 4.39 above, your students may have a different solution to this question. ASSUMPTIONS: (1) In PT_SESSION, the Trainer’s Fee is a constant and is associated with the trainer. An alternate assumption might be that Fee depends on the Trainer and the type of training and length of the session. PT_SESSION (Trainer, Phone, Email, Fee, ClientName, ClientPhone, ClientEmail, Date, Time) 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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Chapter Four Database Design Using Normalization Page 4-2 CLUB_MEMBERSHIP (ClientNumber, ClientName, ClientPhone, ClientEmail, MembershipType, EndingDate, Street, City, State, Zip) 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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

7830TextProjectAnswersCh4 - Chapter Four Database Design...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online