w2WRHXnr

1DROP TABLE IF EXISTS WORKER;
2DROP TABLE IF EXISTS MANAGER;
3
4CREATE TABLE IF NOT EXISTS WORKER(
5    FNAME VARCHAR(50),
6    LNAME VARCHAR(50),
7    EID SMALLINT,
8    AGE SMALLINT,
9    DEPARTMENTNAME VARCHAR(50),
10    PRIMARY KEY(EID)
11);
12
13CREATE TABLE IF NOT EXISTS MANAGER(
14    FIRSTNAME VARCHAR(50),
15    LASTNAME VARCHAR(50),
16    DEPARTMENT VARCHAR(20),
17    MID SMALLINT,
18    AGE SMALLINT,
19    PRIMARY KEY(MID)
20);
21
22INSERT INTO WORKER VALUES('Bob', 'Zane', 1, 20, 'Waste');
23INSERT INTO WORKER VALUES('Reed', 'Cage', 2, 33, 'Marketing');
24INSERT INTO WORKER VALUES('Alfred', 'Law', 3, 26, 'Escalation');
25INSERT INTO WORKER VALUES('Jess', 'Wing', 4, 35, 'HR');
26
27INSERT INTO MANAGER VALUES('Bob', 'Granger', 'HR', 1, 33);
28INSERT INTO MANAGER VALUES('Isaac', 'Kent', 'Testing', 2, 31);
29INSERT INTO MANAGER VALUES('Rick', 'Gennaro', 'Marketing', 3, 48);
30INSERT INTO MANAGER VALUES('Nafiz', 'N', 'Blank', 300, 2);