e0

Tables (7)

DEPARTEMENT (Untitled2)

  • departmentld (Key) — char(4) — Primary key — NOT NULL
  • employeeld (Key2) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
  • departmentld (Key22) — char(4) — Foreign key → EMPLOYEE.departmentld — NOT NULL
  • employeeld (Key222) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
  • departmentName (Field) — char(20)
  • departManager (Field2) — cjar(30)
  • manageStartDate (Field3) — date

DEPARTMENT_LOCATION (Untitled3)

  • departmentid (Key) — char(4) — Primary key — NOT NULL
  • locationID (Key2) — char(3) — Primary key — NOT NULL
  • departmentld (Key3) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
  • employeeld (Key22) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
  • departmentld (Key222) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
  • employeeld (Key2222) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
  • locationID (Key4) — char(3) — Foreign key → LOCATION.locationID — NOT NULL

DEPENDENT (Untitled)

  • dependentld (Key) — char(10) — Primary key — NOT NULL
  • employeeld (Key2) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
  • departmentld (Key22) — char(4) — Foreign key → EMPLOYEE.departmentld — NOT NULL
  • employeeld (Key222) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
  • dependentName (Field) — char(30)
  • ssn (Field2) — char(15)
  • gemder (Field3) — char(1)
  • birthment (Field4) — date
  • relation (Field5)

EMPLOYEE (Untitled4)

  • employeeld (Key) — char(5) — Primary key — NOT NULL
  • departmentld (Key2) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
  • employeeld (Key22) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
  • name (Field) — char(30)
  • birtdate (Field2) — date
  • phone (Field3) — char(11)
  • departmentld (Field4) — char(4)

LOCATION (Untitled6)

  • locationID (Key) — char(3) — Primary key — NOT NULL
  • locationName (Field) — char(20)
  • descrlption (Field2) — text

WORKSON (Untitled7)

  • worksonld (Key) — char(10) — Primary key — NOT NULL
  • projectid (Key2) — char(10) — Foreign key → project.projectid — NOT NULL
  • departmentld (Key22) — char(4) — Foreign key → project.departmentld — NOT NULL
  • employeeld (Key222) — char(5) — Foreign key → project.employeeld — NOT NULL
  • departmentld (Key2222) — char(4) — Foreign key → project.departmentld — NOT NULL
  • employeeld (Key22222) — char(5) — Foreign key → project.employeeld — NOT NULL
  • employeeld (Key3) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
  • departmentld (Key23) — char(4) — Foreign key → EMPLOYEE.departmentld — NOT NULL
  • employeeld (Key223) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL

project (Untitled5)

  • projectid (Key) — char(10) — Primary key — NOT NULL
  • departmentld (Key2) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
  • employeeld (Key22) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
  • departmentld (Key222) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
  • employeeld (Key2222) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
  • projectName (Field) — char(30)
  • description (Field2) — text