Question
For each department the database contains a department number (unique), a budget value, and the department managers employee number (unique). For each department the database
For each department the database contains a department number (unique), a budget value, and the department managers employee number (unique). For each department the database also contains information about all employees working in the department, all projects assigned to the department, and all offices occupied by the department. The employee information consists of employee number (unique), the number of the project on which he or she is working, and his or her office number and phone number; the project information consists of project number (unique)and a budget value; and the office consists of an office number (unique) and the area of the office in square feet. Also, for each employee the database contains the title of each job the employee has held, together date and salary for distinct salary received in that job; and for each office it contains the numbers (unique) of all phones in that office. Design an Entity-Relationship diagram for this problem
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started