Yurttas/PL/DBL/oracle/F/01/Company-A/Department-def.sql
Jump to navigation
Jump to search
1REM
2REM
3REM Department-def.sql
4REM
5REM
6
7CREATE TABLE Department(dname VARCHAR2(16) NOT NULL,
8 dnumber INTEGER NOT NULL,
9 mgrssn CHAR(9) NOT NULL,
10 mgrstartdate CHAR(9),
11 PRIMARY KEY(dnumber),
12 FOREIGN KEY(mgrssn) REFERENCES Employee(ssn));