E-R Diagram

Tables (5)

Department (1)

  • Number (Key) — Number — Primary key — NOT NULL
  • Name (Field) — Char
  • Manager_Start_Date (Field2) — Date

Dependent (4)

  • SSN (Key2) — Number — Foreign key → Employee.SSN — NOT NULL
  • Number (Key3) — Number — Foreign key → Employee.Number — NOT NULL
  • Name (Field) — Char
  • Gender (Field2) — Char
  • Birthdate (Field3) — Date

Employee (3)

  • SSN (Key) — Numer — Primary key — NOT NULL
  • Number (Key3) — Number — Foreign key → Department.Number — NOT NULL
  • Address (Field) — Char
  • Salary (Field2) — Number
  • Birthdate (Field6) — Date

Project (2)

  • Number (Key2) — Number — Foreign key → Department.Number — NOT NULL
  • SSN (Key) — Numer — Foreign key → Employee.SSN — NOT NULL
  • Name (Field)

Works_on (5)

  • Number (Key2) — Number — Foreign key → Project.Number — NOT NULL
  • SSN (Key) — Numer — Foreign key → Project.SSN — NOT NULL
  • Hours_per_week (Field2)