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