Home /
Expert Answers /
Computer Science /
3-14-lab-select-lesson-schedule-with-multiple-joins-the-database-has-three-tables-for-tracking-h-pa598
(Solved):
3.14 LAB - Select lesson schedule with multiple joins The database has three tables for tracking h ...
3.14 LAB - Select lesson schedule with multiple joins The database has three tables for tracking horse-riding lessons: 1. Horse with columns: o ID-primary key o Registered Name o Breed o Height o Birth Date 2. Student with columns: o ID-primary key o FirstName o LastName o Street o City o State o Zip o Phone o Email Address 3. LessonSchedule with columns: • HorselD - partial primary key, foreign key references Horse (ID) • StudentID - foreign key references Student(ID) o LessonDate Time - partial primary key