LAB

$2\mathrm{.}21\mathrm{.}1$: LAB $-$ Create LessonSchedule table with FK constraints

Main.sql

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