Assuming you have beenprovided the following tables of data (PT stands for perso

Question

Assuming you have beenprovided the following tables of data (PT stands for personaltrainer)

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)

Recommend a design for aread-only database that would support the followingneeds:

a. Enable trainersto ensure that their clients are members of the club.
b. Enable the club to assess the populairty of varioustrainers.
c. Enable class instructors to determine if the attendees totheir classes have paid.

Explanation / Answer

a. Enable trainers to ensure that their clients are members of theclub. PT_SESSION (Trainer, ClientNumber,ClientName, Date, Time, MembershipType, EndingDate) b. Enable the club to assess the popularity of varioustrainers. There are two parts to this – client sessions and classenrollees. This will require two tables: TRAINER_CLIENT (Trainer, ClientNumber,ClientName, Date, Time) TRAINER_CLASS_MEMBERSHIP (Trainer, ClassName, StartDate, Time,ClientNumber, ClientName) c. Enable class instructors to determine if the attendees to theirclasses have paid. CLASS_MEMBER (ClassName, Trainer, StartDate,Time, ClientNumber, ClientName, AmtPaid)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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