$3\mathrm{.}9$ LAB $-$ Create LessonSchedule table with FK constraints

The database contains a Horse table, with columns:

ID $-$ integer, primary key

RegisteredName $-$ variable$-$length string

The database contains a Student table, with columns:

ID $-$ integer, primary key

FirstName $-$ variable$-$length string

LastName $-$ variable$-$length string

Create a third table, named LessonSchedule, with columns:

HorseID $-$ integer with range $0$ to $65$ thousand, not NULL, foreign key references Horse$($ID$)$

StudentID $-$ integer with range $0$ to $65$ thousand, foreign key references Student$($ID$)$

LessonDateTime $-$ date$/$time$,$ not NULL

Primary key is $($HorseID$,$ LessonDateTime$)$

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.

Notes: Table and column names are case sensitive in the auto$-$grader. Your SQL code does not display any results in Develop mode. Use

Submit mode to test your code.