Yurttas/PL/DBL/oracle/F/01/Company-A/Dependent-def.sql
Jump to navigation
Jump to search
1REM
2REM
3REM Dependent-def.sql
4REM
5REM
6
7CREATE TABLE Dependent(essn CHAR(9) NOT NULL,
8 dependentname VARCHAR2(16) NOT NULL,
9 sex CHAR,
10 bdate CHAR(9),
11 relationship VARCHAR2(8),
12 PRIMARY KEY(essn, dependentname),
13 FOREIGN KEY(essn) REFERENCES Employee(ssn));