$2\mathrm{.}21$ 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:

HorselD $-$ 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 $($HorselD$,$ 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 SOL code does not display any results in Develop mode. Use

Submit mode to test your code

LAB

$2\mathrm{.}21\mathrm{.}1$: LAB $-$ Create LessonSchedule table with FK constraints

$\frac{0}{10}$

Search

aphas

is

$P=$

c

$90$