Question

12.6 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, 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. 289852.1856990.qx3zqy7 LAB ACTIVITY 12.6.1: LAB - Create LessonSchedule table with FK constraints 1 CREATE TABLE Horse ( 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4 PRIMARY KEY (ID) 5); 6 7 CREATE TABLE Student ( 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 LastName VARCHAR(30), 11 PRIMARY KEY (ID) 12); 13 14 Your SQL statements go here 15 16 17 Main.sql 0/10 Load default template...

          12.6 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, 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.
289852.1856990.qx3zqy7
LAB
ACTIVITY
12.6.1: LAB - Create LessonSchedule table with FK constraints
1 CREATE TABLE Horse (
2	ID	SMALLINT UNSIGNED AUTO_INCREMENT,
3	RegisteredName VARCHAR(15),
4	PRIMARY KEY (ID)
5);
6
7 CREATE TABLE Student (
8	ID	SMALLINT UNSIGNED AUTO_INCREMENT,
9	FirstName VARCHAR(20),
10	LastName VARCHAR(30),
11	PRIMARY KEY (ID)
12);
13
14
Your SQL statements go here
15
16
17
Main.sql
0/10
Load default template...

12.6 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, 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.
289852.1856990.qx3zqy7
LAB
ACTIVITY
12.6.1: LAB - Create LessonSchedule table with FK constraints
1 CREATE TABLE Horse (
2 ID SMALLINT UNSIGNED AUTOINCREMENT,
3 RegisteredName VARCHAR(15),
4 PRIMARY KEY (ID)
5);
6
7 CREATE TABLE Student (
8 ID SMALLINT UNSIGNED AUTOINCREMENT,
9 FirstName VARCHAR(20),
10 LastName VARCHAR(30),
11 PRIMARY KEY (ID)
12);
13
14
Your SQL statements go here
15
16
17
Main.sql
0/10
Load default template...

Added by Ramon W.

Question

Please give Ace some feedback