LAB - Make a LessonSchedule table with FK constraints Two tables are created:... 1 answer below »

LAB - Make a LessonSchedule table with FK constraints

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

Make 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

CREATE TABLE Horse (

          ID       SMALLINT UNSIGNED AUTO_INCREMENT,

          RegisteredName VARCHAR(15),

          PRIMARY KEY (ID)

);

CREATE TABLE Student (

          ID      SMALLINT UNSIGNED AUTO_INCREMENT,

          FirstName   VARCHAR(20),

          LastName               VARCHAR(30),

          PRIMARY KEY (ID)

);

-- Your SQL statements go here