Yurttas/PL/DBL/oracle/F/01/Company-A/Project-def.sql
1REM
2REM
3REM Project-def.sql
4REM
5REM
6
7CREATE TABLE Project(pname VARCHAR2(16) NOT NULL,
8 pnumber INTEGER NOT NULL,
9 plocation VARCHAR2(24),
10 dnum INTEGER NOT NULL,
11 PRIMARY KEY(pnumber),
12 FOREIGN KEY(dnum) REFERENCES Department(dnumber));