(Solved): SQL CREATE TABLE data definition statements for defining the COMPANY schema from Figure 5.7 (Fig. 6. ...

SQL CREATE TABLE data definition statements for defining the COMPANY schema from Figure 5.7 (Fig. 6.1) CREATE TABLE EMPLOYEE (Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno PRIMARY KEY (Ssn), CREATE TABLE DEPARTMENT (Dname Dnumber Mgr_ssn Mgr_start_date CREATE TABLE DEPT_LOCATIONS VARCHAR(15) CHAR, VARCHAR(15) CHAR(9) DATE, VARCHAR(30), CHAR, DECIMAL (10,2), CHAR(9), INT (Dnumber Dlocation VARCHAR(15) PRIMARY KEY (Dnumber), UNIQUE (Dname), FOREIGN KEY (Mgr_ssn) REFERENCES EMPLOYEE(S)); INT CHAR(9) DATE, INT VARCHAR(15) NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, PRIMARY KEY (Dnumber, Dlocation), FOREIGN KEY (Dnumber) REFERENCES DEPARTMENT (Dnumber)); NOT NULL, NOT NULL, continued on next stide