INF503 WEEK2 LAB SOLUTIONS
1. CREATE TABLE EMPLOYEE_UC(Ssn VARCHAR(5) NOT NULL PRIMARY KEY,Fname VARCHAR(15) NOT NULL,Minit VARCHAR(15) NOT NULL,Lname VARCHAR(15) NOT NULL,Bdate DATE,Address VARCHAR(30),Gender CHAR,Salary Decimal(10,2),Age INT); 2. CREATE TABLE DEPARTMENT_UC(Dptname VARCHAR(15),Dptnmbr INT NOT NULL PRIMARY KEY,Mgr_ssn CHAR(9),Mgr_start_date DATE,Mgr_last_date DATE,Ssn VARCHAR(5) FOREIGN KEY REFERENCES…