10 likes | 178 Views
This document outlines the structure and relationships within an Employee and Project Management System. It includes key fields such as employee names, phone numbers, salaries, and addresses, along with project details, budgets, and management roles. The system defines how employees participate in various projects, mentors provide guidance, and the hierarchy of departments is established. Detailed information on start and end dates of projects, as well as dependencies and budget considerations, are also included to ensure effective management and tracking of resources.
E N D
csin cname caddress cage cphone field advises mentors cpwork esin ename salary eaddress ephone participates manages pnum start end budget works_in runs dnum dname building name age ER Diagram coop advisor advisee employees projects depends_on wsince children departments rsince