project

Tables (5)

ASSIGNMENT

  • emp_id — VARCHAR(10) — Foreign key → EMPLOYEE.emp_id — NOT NULL
  • project_id (Key) — VARCHAR(10) — Foreign key → PROJECT.project_id — NOT NULL
  • hours — INT

DEPARTMENT (CopyOfDEPARTMENT)

  • dept_name (Key) — VARCHAR(50) — Primary key — NOT NULL
  • dept_phone — VARCHAR(20)

EMPLOYEE

  • emp_id — VARCHAR(10) — Primary key — NOT NULL
  • emp_name — VARCHAR(50)
  • dept_name (Key) — VARCHAR(50) — Foreign key → DEPARTMENT.dept_name — NOT NULL

MANAGER (CopyOfMANAGER)

  • manager_name (Key) — VARCHAR(50) — Primary key — NOT NULL
  • manager_phone — VARCHAR(20)

PROJECT

  • project_id (Key) — VARCHAR(10) — Primary key — NOT NULL
  • project_name — VARCHAR(100)
  • manager_name (Key2) — VARCHAR(50) — Foreign key → MANAGER.manager_name — NOT NULL