Wgu - D427 Data Management - Applications Zybooks Labs 7 And 8 Study Guide Rated A+

7.9 LAB - Create 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 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 {Ans: CREATE TABLE LessonSchedule( HorseID SMALLINT UNSIGNED NOT NULL, StudentID SMALLINT UNSIGNED, LessonDateTime DATETIME NOT NULL, PRIMARY KEY (HorseID, LessonDateTime), CONSTRAINT fk_HorseID FOREIGN KEY (HorseID) REFERENCES Horse(ID) ON DELETE CASCADE, CONSTRAINT fk_StudentID FOREIGN KEY (StudentID) REFERENCES Student(ID) ON DELETE SET NULL ); or CREATE TABLE LessonSchedule( HorseID SMALLINT UNSIGNED NOT NULL, StudentID SMALLINT UNSIGNED, LessonDateTime DATETIME NOT NULL, PRIMARY KEY (HorseID, LessonDateTime), FOREIGN KEY (HorseID) REFERENCES Horse(ID) ON DELETE CASCADE, FOREIGN KEY (StudentID) REFERENCES Student(ID) ON DELETE SET NULL );}7.5 LAB - Select horses with logical operators The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name,