Question: Two tables are created: 1. Horse with columns ID - integer, primary key RegisteredName - variable-length string 2. Student with columns. ID - integer,
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. HorseID - 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 (ID) 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
Step by Step Solution
3.45 Rating (161 Votes )
There are 3 Steps involved in it
Solutions Step 1 Below shows the table creation query for the tables Horse and Student CREATE TABEL ... View full answer
Get step-by-step solutions from verified subject matter experts
