Db management ch4 no1
0 likes22 views
This document outlines different entities and their relationships in an organization. It describes departments that employ employees who may be assigned to projects, with employees working in divisions and potentially managing or being managed by other employees on projects. Departments, employees, projects, and divisions are all defined with unique identifiers and attributes.
Db management ch4 no1
- 1. DEPARTMENT EMPLOYEE ROVER DIVISION PROJECT DEPARTMENT_IDPK Department Name Department Code EMPLOYEE_IDPK DEPARTMENT_IDFK Employee Name employs ROVER_IDPK Rover Name May Not BeAssisned DIVISION_IDPK Division Name Operates PROJECT_NAMEPK EMPLOYEE_IDFK Employee Name Asssigned Manages Managed by Runs