Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3.8 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: ID - integer, primary key RegisteredName - variablelength
3.8 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: ID - integer, primary key RegisteredName - variablelength string 2. Student with columns: ID - integer, primary key FirstName - variable-length string - LastName - variable-length string Create the LessonSchedule table with columns: - HorselD - integer with range 0 to 65 thousand, not NULL, par tial 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. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. Note: Table and column names are case sensitive in the auto-grader
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started