Refining the COMPANY database schema by introducing relationships

Posted by AJ × 03:37

By examining the requirements, six relationship types are identified.

All are binary relationships( degree 2)

Listed below with their participating entity types:

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)

Widget by HandBit

All Syllabus