HELP DESCRIBE EMPLOYEE;
HELP DESCRIBE DEPARTMENT;
INSERT INTO WORKS VALUES (700,11);
INSERT INTO WORKS VALUES (777,11);
INSERT INTO WORKS VALUES (700,20);
INSERT INTO WORKS VALUES (122,20);
INSERT INTO WORKS VALUES (321,30);
INSERT INTO WORKS VALUES (778,30);
INSERT INTO WORKS VALUES (779,30);
SELECT * FROM SALARY;
DELETE FROM SALARY;
SELECT * FROM SALARY;
DROP TABLE SALARY;
UPDATE EMPLOYEE SET address='230 S Wabash Ave 22001';
CREATE SUBSCHEMA EMPLOYEE ename,address,sex;
CREATE USER userB2 User-B;
DELETE FROM WORKS WHERE enum=700 AND projnum=11;
DROP TABLE DEPARTMENT;
SELECT ename, dname FROM EMPLOYEE, WORKS, PROJECT, DEPARTMENT WHERE ssn=enum AND projnum=pnum AND dep=dnum;
QUIT;
