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

 1/*
 2REM
 3REM
 4REM Employee-cre.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11CREATE TABLE Employee(fname VARCHAR(12) NOT NULL,
12                      minit CHAR,
13                      lname VARCHAR(16) NOT NULL, 
14                      ssn CHAR(9) NOT NULL,
15                      bdate CHAR(9),
16                      address VARCHAR(24),
17                      sex CHAR,
18                      salary FLOAT,
19                      superssn CHAR(9),
20                      dno INTEGER NOT NULL,
21          PRIMARY KEY(ssn));