2023910139

Tables (7)

Department

  • Key (DepartmentID) — char(5) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (Location) — Char(30)
  • Field (managerStartDate) — date
  • Key (manegerEmpID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Employee)

  • Key (eployeeID) — char(10) — Primary key — NOT NULL
  • Field (ssn) — char(12)
  • Field2 (name) — char(30)
  • Field3 (gender) — char(1)
  • Field4 (adress) — char(50)
  • Field (degree) — char(50)
  • Field (salary) — int(10)
  • Field (birthDate) — date
  • Field (phone) — char(12)
  • Key (workforDepartmentID) — char(5) — Foreign key → Department.Key — NOT NULL
  • Key (supervisoreployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Project)

  • Field (projectID) — int — Primary key
  • Field (name) — char(70)
  • Field2 (description) — text
  • Field (StartDate) — Date
  • Field (FinishDate) — Date

Untitled (Workson)

  • Field (hours) — float
  • Key (eployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (projectID) — int — Foreign key → Untitled.Field

Untitled (DEPENDENT)

  • Key (ssn) — char(12) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (gender) — char(1)
  • Field (birthdate) — date
  • Field (relationship) — char(20)
  • Key (eployeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (LOCATION)

  • Key (locationID) — char(10) — Primary key — NOT NULL
  • Field (locationName) — char(30)
  • Field (address) — char(50)

Untitled (ISAT)

  • Key (DepartmentID) — char(5) — Foreign key → Department.Key — NOT NULL
  • Key (locationID) — char(10) — Foreign key → Untitled.Key — NOT NULL