Question: 2 . 2 1 LAB - Create LessonSchedule table with FK constraints The database contains a Horse table, with columns: ID - integer, primary key
LAB Create LessonSchedule table with FK constraints
The database contains a Horse table, with columns:
ID integer, primary key
RegisteredName variablelength string
The database contains a Student table, with columns:
ID integer, primary key
FirstName variablelength string
LastName variablelength string
Create a third table, named LessonSchedule, with columns:
HorseID integer with range to thousand, not NULL, foreign key references HorseID
StudentID integer with range to thousand, foreign key references StudentID
LessonDateTime datetime 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
