Question: Question3. (42 points) Consider a company database. Suppose that after the requirements collection and analysis phase, the database designers provide the following description. - Employee

 Question3. (42 points) Consider a company database. Suppose that after the

Question3. (42 points) Consider a company database. Suppose that after the requirements collection and analysis phase, the database designers provide the following description. - Employee Attributes: Name, Id, Address, Gender, Dob and Doj. - Department Attributes: D_no, Name and Location. - Project Attributes: P_No, Name and Location. - Dependent Attributes : D_name, Gender and relationship. - An employee works in only one department but can work on several projects. - Every department must have one manager. - One department has many projects and a project can come under at least one departments. A. Design an ER model to present the above information. B. Change the ER model to include the following: - An employee can be a staff or a faculty. For staff employees we store position. Fo faculty employees we store rank. Only Faculty employees can work on projects

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!