CREATE TABLE student 
( enrollment_no INT(12) NOT NULL, 
s_firstname varchar(50) NOT NULL, 
s_lastname varchar(50) NOT NULL, 
branch CHARACTER(20) NOT NULL); 
CREATE TABLE employees 
( employee_number INT(10) NOT NULL, 
employee_name varchar(50) NOT NULL, 
department_id INT(10), 
CONSTRAINT employees_pk PRIMARY KEY (employee_number) 
); 
CREATE TABLE faculty 
( faculty_id INT(10) NOT NULL, 
faculty_name varchar(50) NOT NULL, 
department CHARACTER(20) NOT NULL 
); 
CREATE TABLE departments 
( department_id INT(10) NOT NULL, 
department_name varchar(50) NOT NULL, 
CONSTRAINT departments_pk PRIMARY KEY (department_id) 
);