Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Plz if you know exactly An Engineering Company Enterprise 1) Each engineer works on a number of projects. For every engineer a record is kept
Plz if you know exactly
An Engineering Company Enterprise 1) Each engineer works on a number of projects. For every engineer a record is kept of his/her number, name, title and salary. 2) For every project a record is kept of its number, name, budget and location. Additionally, the responsibility each engineer has on a particular project and the amount of time spent on the project is noted. 3) Clients contract these projects. The clients name, address and phone number must be recorded. The contract date, i.e. the date at which the client signs the contract for a specific project is also noted. 4) A record is also kept of the machinery being used for a particular project. The name, amount and the date the machinery is needed for the project is recorded. 5) Engineers can have three levels of insurance: Premier, Economy, and Basic. An engineer can also choose not to have any insurance. Associated with each insurance policy is an engineer's spouse, children, and a unique policy number. 6) The company is divided into departments and an engineer works in a specific department. A department has a manager, name, unique ID number, and maintains the total number of employees working in that department as well. Draw the Entity-Relationship diagram for this application. Specify key attributes of each entity and structural constraints on each relationship. Note any unspecified requirements, and make appropriate assumptions so as to make the specification complete. In order to avoid losing credit, your ER diagram should either be computer-generated or hand-drawn very neatlyStep 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