(Solved): 6.6 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with col ...

6.6 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: - ID-integer, primary key - RegisteredName - variable-length string 2. Student with columns: - ID-integer, primary key - FirstName - variable-length string - LastName - variable-length string Create the LessonSchedule table with columns: - HorselD - integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references Horse(ID) - StudentID - integer with range 0 to 65 thousand, foreign key references Student((D) - LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Note: Table and column names are case sensitive in the auto-grader.