DROP TABLE CLASS;
INSERT INTO EMPLOYEE VALUES (122,'William Seymour','456 12th St 34567','M');
INSERT INTO EMPLOYEE VALUES (778,'Christine White','456 12th St 34567','F');
INSERT INTO EMPLOYEE VALUES (125,'Bart Williams','305 N University St 47907','T');
INSERT INTO EMPLOYEE VALUES ('-110','John Doe','456 12th St 34567','M');
INSERT INTO PROJECT VALUES (11,'Assistive Tech',33);
INSERT INTO PROJECT VALUES (20,'Training1',44);
INSERT INTO PROJECT VALUES (30,'Department Intro',110);
UPDATE DEPARTMENT SET location='WLafayette' WHERE dnum=110;
UPDATE EMPLOYEE SET address='305 N University St 47907',ename='W. Seymour' WHERE ssn=122;
CREATE TABLE SALARY(empnum INT, empsalary INT, PRIMARY KEY(empnum), FOREIGN KEY(empnum) REFERENCES EMPLOYEE(ssn));
INSERT INTO SALARY VALUES('-122',50000);
INSERT INTO SALARY VALUES (122,40000);
INSERT INTO SALARY VALUES (778,60000);
HELP CREATE TABLE;
HELP DROP TABLE;
HELP INSERT;
HELP DELETE;
HELP UPDATE;
QUIT;
