Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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. For faculty employees we store rank. Only Faculty employees can work on projects
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