ERD EX.00

Tables (7)

Untitled (Department)

  • Key (DepID) — int — Primary key — NOT NULL
  • Field (depName) — char30)
  • Field (StartDate) — date
  • Field
  • Key (EmpID) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (Employee)

  • Key (EmpID) — char(14) — Primary key — NOT NULL
  • Field (empName) — char(50)
  • Field (address) — char(70)
  • Field (salary) — int
  • Field (birthDate) — date
  • Field (gender) — char(1)
  • Field
  • Key (DepID) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Project_Employee)

  • Key — Primary key — NOT NULL
  • Key (ssn) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Key (ProNo) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Project)

  • Key (ProjectID) — int — Primary key — NOT NULL
  • Field (proName) — char(50)
  • Field (description) — text
  • Field
  • Key (DepID) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Dependent)

  • Key (DepID) — char(14) — Primary key — NOT NULL
  • Field (depname) — char(50)
  • Field2 (birthDate) — date
  • Field (relationship) — char(50)
  • Key (EmpID) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (Department_Location)

  • Key (DepID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (locationID) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (Location)

  • Key (locationID) — char(15) — Primary key — NOT NULL
  • Field (locName) — char(50)
  • Field (description) — text