Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The database contains a Horse table, with columns:ID - integer, primary keyRegisteredName - variable - length stringThe database contains a Student table, with columns:ID -

The database contains a Horse table, with columns:ID - integer, primary keyRegisteredName - variable-length stringThe database contains a Student table, with columns:ID - integer, primary keyFirstName - variable-length stringLastName - variable-length stringCreate 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 NULLPrimary key is (HorseID, 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions