db 20,21
Tables (5)
DEPARTMENT (Untitled)
- depID (Key) — char(5) — Primary key — NOT NULL
- name (Field) — char(30)
- manager (Field2) — char(30)
- startDate (Field3) — date
- location (Field4) — char(10)
- managerSsn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled4)
- dependentName (Key) — char(30) — Primary key — NOT NULL
- gender (Field) — char(5)
- birthDate (Field2) — date
- relationship (Field3) — char(10)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled3)
- ssn (Key) — char(14) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(50)
- pay (Field3) — char(10)
- gender (Field4) — char(5)
- birthDate (Field5) — date
- depID (Key2) — char(5) — Foreign key → DEPARTMENT.depID — NOT NULL
- dependentName (Key3) — char(30) — Foreign key → DEPENDENT.dependentName — NOT NULL
- projectID (Key4) — char(5) — Foreign key → PROJECT.projectID — NOT NULL
PROJECT (Untitled2)
- projectID (Key) — char(5) — Primary key — NOT NULL
- projectName (Field) — char(20)
- description (Field2) — text
- duration (Field3) — char(30)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
- depID (Key3) — char(5) — Foreign key → DEPARTMENT.depID — NOT NULL
WORKSON (Untitled5)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
- projectID (Key) — char(5) — Foreign key → PROJECT.projectID — NOT NULL