Question: 2 . 2 1 LAB - Create LessonSchedule table with FK constraints The database contains a Horse table, with columns: ID - integer, primary key

2.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:
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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!