Company
Tables (9)
Employee
- ssn — Primary key — NOT NULL
- name (fname)
- Field (sex)
- Field (salary)
- Field (address)
- Field (minit)
- Field (lname)
- Field (birthdate)
Untitled (Manages)
- Key (startdate) — Primary key — NOT NULL
- ssn — Foreign key → Employee.ssn — NOT NULL
Untitled (Department)
- Key (number) — Primary key — NOT NULL
- ssn — Foreign key → Untitled.ssn — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field (locations)
Untitled (Control)
- Key (number) — Foreign key → Untitled.Key — NOT NULL
- ssn — Foreign key → Untitled.ssn — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- Key (name) — Foreign key → Untitled.Key — NOT NULL
Untitled (Project)
- Key (name) — Primary key — NOT NULL
- Field (location)
Untitled (Work_On)
- ssn — Foreign key → Employee.ssn — NOT NULL
- Key (name) — Foreign key → Untitled.Key — NOT NULL
- Field (hours)
Untitled (Dependent)
- Key (name) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- Field (sex)
- Field (realationship)
Untitled (Work_For)
- Key (number) — Foreign key → Untitled.Key — NOT NULL
- ssn — Foreign key → Employee.ssn — NOT NULL
- ssn (ssn2) — Foreign key → Untitled.ssn — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
Untitled (Dependents_Of)
- ssn — Foreign key → Employee.ssn — NOT NULL
- Key (name) — Foreign key → Untitled.Key — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL