Yurttas/PL/DBL/mysql-f-2010/01/Company-A/Dependent-cre.sql

 1/*
 2REM
 3REM
 4REM Dependent-cre.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11CREATE TABLE Dependent(essn CHAR(9) NOT NULL,
12                       dependentname VARCHAR(16) NOT NULL,
13                       sex CHAR,
14                       bdate CHAR(9),
15                       relationship VARCHAR(8),
16           PRIMARY KEY(essn, dependentname),
17           FOREIGN KEY(essn) REFERENCES Employee(ssn));