CREATE TABLE Employee ssn CHAR (10) NOT NULL, first_name VARCHAR2 (20), last_name VARCHAR2 (20), birth_date DATE, salaried CHAR (5) gender CHAR(1), phone CHAR (12), PRIMARY KEY (ssn)); CREATE TABLE Department ( dept_no NUMBER NOT NULL, dept_name VARCHAR(220), budget NUMBER, PRIMARY KEY (dept_no)); CREATE TABLE Works In ssn CHAR (10) NOT NULL, dept_no NUMBER NOT NULL, PRIMARY KEY (ssn, dept_no), FOREIGN KEY (ssn) REFERENCES Employee (ssn), FOREIGN KEY (dept_no) REFERENCES Department (dept_no)); CREATE TABLE Manager ( ssn CHAR (10) NOT NULL, dept_no NUMBER NOT NULL, PRIMARY KEY (ssn, dept_no), FOREIGN KEY (ssn) REFERENCES Employee (ssn), FOREIGN KEY (dept_no) REFERENCES Department (dpet_no)); CREATE TABLE Employee ssn CHAR (10) NOT NULL, first_name VARCHAR2 (20), last_name VARCHAR2 (20), birth_date DATE, salaried CHAR (5) gender CHAR(1), phone CHAR (12), PRIMARY KEY (ssn)); CREATE TABLE Department ( dept_no NUMBER NOT NULL, dept_name VARCHAR(220), budget NUMBER, PRIMARY KEY (dept_no)); CREATE TABLE Works In ssn CHAR (10) NOT NULL, dept_no NUMBER NOT NULL, PRIMARY KEY (ssn, dept_no), FOREIGN KEY (ssn) REFERENCES Employee (ssn), FOREIGN KEY (dept_no) REFERENCES Department (dept_no)); CREATE TABLE Manager ( ssn CHAR (10) NOT NULL, dept_no NUMBER NOT NULL, PRIMARY KEY (ssn, dept_no), FOREIGN KEY (ssn) REFERENCES Employee (ssn), FOREIGN KEY (dept_no) REFERENCES Department (dpet_no))