DROP TABLE IF EXISTS enrolled DROP TABLE IF EXISTS achedule DROP TABLE IF EXISTS Class DROP TABLE IF EXISTS atudent: DROP TABLE IF EXISTS professori DROP TABLE IFEXISTS majora DROP TABLE IF EXISTS najor_classes CREATE TABLE class id int (11) NOT NULL AUTO INCRENENT sane varchar (45) NOT NULL CREATE TABLE majo id int (11) NOT NULL AUTO INCREENT nane varchar (45) NOT NULL UNT CCE CREATE TABLE professor id int (31) NOT NULL AUTO INCRENT flest nane varchar (45) NOT NULL last nane varchar (45) NOT ULL PRtMARYKEY 41d) CREATE TABLE student id int (11) NOT NULL AUTO INCREMENT first name varchar (45) NOT NUL laat nane vazchar (45) NOT NULL year in school int (11) major id int (11) PRIMARY KEY (Ld) CREATE TABLE ajoeelasses id int (1) NOT NLL AUTO INCRENENT ajor id Lat (11) class id int (11) EMARY KEY (d). OREIGN KEY najor id) REFERENCEs majorLd) CREATE TABLE Schedule id int (11) NOT NULLAUTO INCREMENT. elass id Lnt (11) NOT NULL professor id inti11) NOT NULL quar ter int (11) NOT LL, PRIMARY KEY (d) OREIGN KEY elass id) REFERENCES class Ld) POREIGN KEY (professor id) REFERENCES proessor (id) CREATE TABLE enEolled d intii) NOT NULL AUTO TINCRENENT. student ld Int (11) class oftered id inta) grade char (2) PRIMARY KEY d) ORE TON KEY (student id) REFERENCES student id) OREG EY (class offered id) REFERENCES schedale d 2