2
Tables (4)
EMPLOYEE
- Key (SSn) — Primary key — NOT NULL
- Key (Name) — Foreign key → Untitled.Key — NOT NULL
- Field (Fname)
- Minit
- Field2 (Lname)
- Field (Bdate)
- Field2 (NAME)
- Field3 (Address)
- Field4 (Salary)
- Field (SEX)
- Field (SUPERVISION)
- Field (DEPENDENTS_of)
Untitled (DEPARTMENT)
- Key (Name) — Primary key — NOT NULL
- Key (Number) — Primary key — NOT NULL
- Key (SSn) — Foreign key → EMPLOYEE.Key — NOT NULL
- Key2 (Number2) — Foreign key → Untitled.Key2 — NOT NULL
- Field (Locations)
- Field (WORKS_FOR)
- Field (MANAGERS)
- Field (Start_date)
- Field (CONTROLS)
Untitled (PROJECT)
- Key (Name) — Primary key — NOT NULL
- Key2 (Number) — Primary key — NOT NULL
- Field (Location)
- Field (WORKS_ON)
- Field (Hours)
Untitled (DEPENDENT)
- Key (Name) — Primary key — NOT NULL
- Field (Sex)
- Field (Birth_date)
- Field (Relationships)