DAT/390 Database Integration with Other Systems The Latest Version A+ Study Guide **********************************************
DAT 390 Entire Course Link https://www.onlinehelp123.com/dat-390 ********************************************** 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: o
ID - primary key o RegisteredName o Breed o Height o BirthDate 2. Student with columns: o
ID - primary key o FirstName o LastName o Street o City o State o Zip o Phone o EmailAddress 3. LessonSchedule with columns: o o o
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.