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));