create foreign key constraints for the appropriate tables in your Chicago_School_DB database from the CLI in MySQL. Since your tables have already been created, this will need to be accomplished through the Alter Table command. For a deliverable, take a screen shot of each alter table command successfully being executed.

Chicago School DB relations:

School relation
schoolNumber	name	address	phoneNumber	built	size

Student relation
studentNumber	firstName	lastName	birthdate	schoolNumber

Teacher relation
teacherID	firstName	lastName	hireDate	supervisor

Subject relation
subjectNumber	Name	gradeLevel

Class relation
teacherID	studentNumber	subjectNumber	grade

Administrator relation
employeeNumber	schoolNumber	firstName	lastName	phoneNumber	officerNumber

CREATE DATABASE IF NOT EXISTS `chicago_school_db`; USE `chicago_school_db`;

DROP TABLE IF EXISTS `teacher`; CREATE TABLE `teacher` ( `teacherID` int NOT NULL, `firstname` varchar(50) DEFAULT NULL, `lastname` varchar(50) DEFAULT NULL, `hireDate` date DEFAULT NULL, `supervisor` int DEFAULT NULL, PRIMARY KEY (`teacherID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `teacher` WRITE; INSERT INTO `teacher` VALUES (4,'James','Bond','2010-01-24',150), (16,'Chadwick','Boseman','2008-06-19',4), (18,'Danai','Gurira','2008-08-14',16), (24,'Paul','Rudd','2007-08-16',18), (25,'Gemma','Chan','2006-02-14',4), (52,'Mark','Ruffalo','2016-04-12',138), (60,'Chris','Evans','2016-07-01',138), (76,'Ryan','Reynolds','2001-05-18',101), (77,'Brie','Larson','2003-02-20',18), (89,'Tom','Hiddleston','2020-06-05',101), (101,'Chris','Pratt','2008-06-19',172), (119,'Tom','Holland','2017-11-07',138), (138,'Robert','Downey','2003-07-09',52), (146,'Scarlett','Johansson','2020-06-05',4), (150,'Anthony','Mackie','2015-02-26',18), (172,'Benedict','Cumberbatch','2006-02-14',18), (193,'Jeremy','Renner','2014-07-11',101); UNLOCK TABLES;

DROP TABLE IF EXISTS `subject`; CREATE TABLE `subject` ( `subjectNumber` int NOT NULL, `name` varchar(100) DEFAULT NULL, `gradeLevel` varchar(2) DEFAULT NULL, PRIMARY KEY (`subjectNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `subject` WRITE; INSERT INTO `subject` VALUES (9,'Astronomy','9'), (13,'US History','12'),(23,'Geography','10'), (33,'Biology','10'),(35,'Entomology','9'), (43,'Algebra II','10'), (53,'Self Defense','12'), (62,'Algebra','9'), (67,'Literature','12'), (70,'Norse Mythology','10'), (78,'World History','11'), (83,'Legal Studies','11'), (85,'Introduction to Computer Science','11');

UNLOCK TABLES;

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` ( `studentNumber` int NOT NULL, `schoolNumber` int NOT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `birthDate` date DEFAULT NULL, PRIMARY KEY (`studentNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `student` WRITE;

INSERT INTO `student` VALUES (1093,45,'Hermione','Granger','2006-11-24'), (1217,45,'Ron','Weasley','2005-08-17'), (1440,345,'Britta','Perry','2006-05-21'), (1448,93,'Jessie','Spano','2007-02-15'), (1601,54,'Eric','Mathews','2005-08-22'), (1803,119,'Tyra','Collette','2007-08-02'), (1927,93,'Kelly','Kapowski','2009-02-22'), (1972,93,'Samuel','Powers','2007-04-14'), (2036,345,'Annie','Edison','2006-05-25'), (2056,119,'Taylor','Kitsch','2009-08-08'), (2168,119,'Zach','Gilford','2005-08-02'), (2213,119,'Jason','Street','2006-01-17'), (2258,54,'Topanga','Lawrence','2008-03-05'), (2411,45,'Harry','Potter','2006-09-15'), (2492,345,'Jeff','Winger','2008-08-10'), (2600,45,'Neville ','Longbottom','2007-11-01'), (2725,54,'Shawn','Hunter','2008-05-31'), (2732,93,'Zack','Morris','2008-02-18'), (2895,54,'Cory','Mathews','2007-02-17'), (2932,345,'Abed','Nadir','2007-04-15');

UNLOCK TABLES;

DROP TABLE IF EXISTS `school`;

CREATE TABLE `school` ( `schoolNumber` int NOT NULL, `name` varchar(200) DEFAULT NULL, `address` varchar(95) DEFAULT NULL, `phoneNumber` varchar(10) DEFAULT NULL, `built` date DEFAULT NULL, `size` int DEFAULT NULL, PRIMARY KEY (`schoolNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `school` WRITE;

INSERT INTO `school` VALUES (45,'Hogwarts Scool of Witchcraft and Wizardry','738 North Williams Ave.','5056448362','2000-11-14',414000), (54,'John Adams High School','8226 Selby Lane','5056444088','2012-12-13',118500), (93,'Bayside High','7914 Aspen Drive','5057756575','2000-08-20',175645), (119,'Dillon High School','475 South University Ave.','5058672818','2006-10-03',102598), (345,'Green Dale High','772 Grand St.','5056624410','2009-09-17',250345);

UNLOCK TABLES;

DROP TABLE IF EXISTS `class`;

CREATE TABLE `class` ( `teacherID` int NOT NULL, `studentNumber` int NOT NULL, `subjectNumber` int NOT NULL, `grade` int DEFAULT NULL, PRIMARY KEY (`teacherID`,`studentNumber`,`subjectNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `class` WRITE;

UNLOCK TABLES;

DROP TABLE IF EXISTS `administrator`;

CREATE TABLE `administrator` ( `employeeNumber` int NOT NULL, `schoolNumber` int NOT NULL, `firstName` varchar(50) DEFAULT NULL, `lastName` varchar(50) DEFAULT NULL, `phoneNumber` varchar(10) DEFAULT NULL, `officeNumber` varchar(3) DEFAULT NULL, PRIMARY KEY (`employeeNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `administrator` WRITE;

INSERT INTO `administrator` VALUES (430,45,'Albus','Dumbledore','2072087222','201'), (161,345,'John','Oliver','4255510706','321'), (241,54,'Eli','Williams','4344641774','502'), (253,93,'Dennis','Haskins','5056465505','987'),