Hello, I need to create a sql table. The two first tables are already created. I need to create the 3rd table with the deleted function set to automatically. See the instructions below. Create LessonSchedule table with FK constraints Two tables are created:Horse with columns:ID - integer, primary keyRegisteredName - variable-length string Student with columns:ID - integer, primary keyFirstName - variable-length stringLastName - variable-length string "this one" -Create the LessonSchedule table with columnsHorseID - 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 keyIf 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.Thanks

In order to support the above operation we need to add CASCADE while defining the REFERENCES in the…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Create LessonSchedule table with FK constraints

Two tables are created:

Horse with columns:
- ID - integer, primary key
- RegisteredName - variable-length string
Student with columns:
- ID - integer, primary key
- FirstName - variable-length string
- LastName - variable-length string

"this one" -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.

If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.

Thanks

Expert Solution