Yurttas/PL/DBL/oracle/F/01/Company-A/WorksOn-def.sql

 1REM
 2REM
 3REM WorksOn-def.sql
 4REM
 5REM
 6
 7CREATE TABLE WorksOn(essn CHAR(9) NOT NULL,
 8                     pno INTEGER NOT NULL,
 9                     hours NUMBER(4,1) NOT NULL,
10         PRIMARY KEY(essn, pno),
11         FOREIGN KEY(essn) REFERENCES Employee(ssn),
12         FOREIGN KEY(pno) REFERENCES Project(pnumber));