Yurttas/PL/DBL/mysql/F/01/00/Company-A/WorksOn-cre.sql

 1/*
 2REM
 3REM
 4REM WorksOn-cre.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11CREATE TABLE WorksOn(essn CHAR(9) NOT NULL,
12                     pno INTEGER NOT NULL,
13                     hours FLOAT NOT NULL,
14         PRIMARY KEY(essn, pno),
15         FOREIGN KEY(essn) REFERENCES Employee(ssn),
16         FOREIGN KEY(pno) REFERENCES Project(pnumber));