DAT 390 Wk 3 – Apply: Labs

Complete zyLab 3.8 and 3.9 in zyBooks. You have unlimited attempts in Develop mode. Toggle to Submit mode for a grade.

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:

   • 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 for Feb 1, 2020 with the lesson date/time, student’s first and last names, and the horse’s registered name. Order the results in ascending order by lesson date/time, then by the horse’s registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results.