a
Tables (4)
DEPARTMENT (CopyOfUntitled)
- departmentID (Key) — char(10) — Primary key — NOT NULL
- departmentName (Field) — char(30)
- departmentManager (Field2) — int(10)
- manageStartDate (Field3) — date
- ssn (Key2) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled)
- ssn (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(13)
- address (Field3) — char(50)
- departmentID (Key2) — char(10) — Foreign key → DEPARTMENT.departmentID — NOT NULL
PROJECT (Untitled2)
- projectID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
WORKS_ON (Untitled3)
- ssn (Key) — char(10) — Foreign key → EMPLOYEE.ssn — NOT NULL
- projectID (Key2) — char(10) — Foreign key → PROJECT.projectID — NOT NULL
- hours (Field) — float