3 9 LAB Select lesson schedule with inner join The database has three tables for tracking horse riding lessons Horse with columns ID primary key RegisteredName Breed Height BirthDate Student with columns ID primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns HorseID partial primary key, foreign key references Horse(ID) StudentID foreign key references Student(ID) LessonDateTime partial primary key Write a SELECT statement to create a lesson schedule with the lesson date time, horse ID, and the student's first and last names Order the results in ascending order by lesson date time, then by horse ID Unassigned lesson times (student ID is NULL) should not appear in the schedule Hint Perform a join on the Student and LessonSchedule tables, matching the student IDs 3 9 LAB Select lesson schedule with inner join The database has three tables for tracking horse riding lessons 1 Horse with columns ID primary key RegisteredName Breed Height BirthDate 2 Student with columns ID primary key FirstName LastName Street City State Zip Phone EmailAddress 3 LessonSchedule with columns HorselD partial primary key, foreign key references Horse(ID) StudentID foreign key references Student(ID) LessonDateTime partial primary key Write a SELECT statement to create a lesson schedule with the lesson date time, horse ID, and the student's first and last names Order the results in ascending order by lesson date time, then by horse ID Unassigned lesson times (student ID is NULL) should not appear in the schedule Hint Perform a join on the Student and LessonSchedule tables, matching the student IDs

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 10, 2024

3.9 LAB - Select lesson schedule with inner join The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key

3.9 LAB - Select lesson schedule with inner join

The database has three tables for tracking horse-riding lessons:

Horse with columns:

ID - primary key

RegisteredName

Breed

Height

BirthDate

Student with columns:

ID - primary key

FirstName

LastName

Street

City

State

Zip

Phone

EmailAddress

LessonSchedule with columns:

HorseID - partial primary key, foreign key references Horse(ID)

StudentID - foreign key references Student(ID)

LessonDateTime - partial primary key

Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.

Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.

image text in transcribed

3.9 LAB - Select lesson schedule with inner join The database has three tables for tracking horse-riding lessons: 1. Horse with columns: ID - primary key RegisteredName Breed Height BirthDate 2. Student with columns: - ID - primary key - FirstName - LastName - Street - City - State Zip Phone EmailAddress 3. LessonSchedule with columns: - HorselD - partial primary key, foreign key references Horse(ID) - StudentID - foreign key references Student(ID) - LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs