Relationship Types of COMPANY Database

Six Relationship Types are identified:
  • WORKS_FOR (between EMPLOYEE, DEPARTMENT)
  • MANAGES (also between EMPLOYEE, DEPARTMENT)
  • CONTROLS (between DEPARTMENT, PROJECT)
  • WORKS_ON (between EMPLOYEE, PROJECT)
  • SUPERVISION (between EMPLOYEE (as subordinate), EMPLOYEE (as supervisor)) DEPENDENTS_OF (between EMPLOYEE, DEPENDENT)

Database Management System