DROP SCHEMA IF EXISTS f17i3335; CREATE SCHEMA f17i3335; USE f17i3335; CREATE TABLE IF NOT EXISTS Employee ( EmployeeId INT, -- add data type. FName VARCHAR(30), LName VARCHAR(30), SSN VARCHAR(11), Phone VARCHAR(12), EMail VARCHAR(12), CONSTRAINT Employee_EmployeeId_pk PRIMARY KEY (EmployeeId), CONSTRAINT Employee_SSN_ck UNIQUE (SSN) -- not required in HW #5 ); CREATE TABLE IF NOT EXISTS Request ( RequestId INT, -- add data type. Description VARCHAR(300), Request VARCHAR(30), EmployeeId INT, StatusId INT, CONSTRAINT Request_RequestId_pk PRIMARY KEY (RequestId), CONSTRAINT Request_EmployeeId_fk FOREIGN KEY (EmployeeId) REFERENCES Employee(EmployeeId)); );