DB0921
Tables (5)
DEPARTMENT (Untitled2)
- deptNo (Key) — integer — Primary key — NOT NULL
- name (Field2) — char(20)
- manager (Field3) — char(20)
- manageStartDate (Field) — date
- location (Field5) — char(20)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPENDANT (Untitled3)
- depenID (Key) — char(14) — Primary key — NOT NULL
- name (Field) — char(20)
- birthDate (Field2) — date
- ssn (Field3) — char(14)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- ssn (Key) — char(14) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(50)
- phone (Field3) — char(11)
- depID (Field4) — char(14)
- depenID (Key2) — char(14) — Foreign key → DEPENDANT.depenID — NOT NULL
PROJECT (Untitled)
- projNo (Key) — integer — Primary key — NOT NULL
- name (Field) — char(20)
- contolDeptNo (Field2) — integer
- controlDeptName (Field3) — char(20)
- depenID (Key2) — char(14) — Foreign key → DEPENDANT.depenID — NOT NULL
WORKSON (Untitled4)
- wonID (Key) — CHAR(20) — Primary key — NOT NULL
- SSN (Field) — char(14)
- projectID (Field2) — char(10)
- hours (Field3) — float
- projNo (Key2) — integer — Foreign key → PROJECT.projNo — NOT NULL
- ssn (Key3) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL