Project Inc

Tables (5)

Department (DEPARTMENT)

  • Key (Department Name) — Primary key — NOT NULL
  • Field (Phone#)
  • Field (Fax#)

Employee (EMPLOYEE)

  • Key (Employee#) — Primary key — NOT NULL
  • Key (Department Name) — Foreign key → Department.Key — NOT NULL
  • Field (Name)
  • Field (Adress)
  • Field (Start Date)
  • Field ({Skill})
  • Key (Spouse) — Foreign key → Employee.Key — NOT NULL

MANAGER (Untitled)

  • Employee (Field)

Project (PROJECT)

  • Key (Project-id) — Primary key — NOT NULL
  • Field (Project title)
  • Field (Start Date)
  • Field (Duration)
  • Field (Budget)
  • Field (Project Roles)
  • Field (Employee)
  • Field (Skill)

Skill (SKILL)

  • Key (Skill Code) — Primary key — NOT NULL
  • Field (Description)