CREATE TABLE Department
(
DepartmentNo int not null default 0,
DepartmentName varchar(20) not null default ''
)
CREATE TABLE ShiftDetail
(
ShiftNo int not null default 0,
ShiftName varchar(20) not null default '',
StartTime varchar(8) not null default '08:00:00',
EndTime varchar(8) not null default '16:00:00'
)
CREATE TABLE Employee
(
EmployeeId int not null default 0,
FirstName varchar(20) not null default '',
...
