2.21 LAB - Create LessonSchedule table with FK constraintsTwo 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 Create the LessonSchedule table 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

The objective of the question is to create a new table named 'LessonSchedule' in a relational…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

2.21 LAB - 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

Create the LessonSchedule table 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 NULL
Primary 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

AI-Generated Solution

AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.