1
Tables (4)
DEPARTMENT (Untitled)
- dep ID (Key) — int — Primary key — NOT NULL
- name (Field) — char
- locations (Field2) — char
- number (Field3) — int
EMPLOYEE (Untitled2)
- SSN (Key) — int — Primary key — NOT NULL
- name (Field) — char
- gender (Field2) — char
- address (Field3) — char
PROJECT (Untitled3)
- projNo (Key) — Primary key — NOT NULL
- name (Field)
- location (Field2)
- Field3
- dep ID (Key2) — int — Foreign key → DEPARTMENT.dep ID — NOT NULL
WOERKS-ON (Untitled4)
- SSN (Key) — int — Foreign key → EMPLOYEE.SSN — NOT NULL
- projNo (Key2) — Foreign key → PROJECT.projNo — NOT NULL