Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the below business rules of a consultancy company that has many departments. * Each employee belongs to only one department. Each employee has

Consider the below business rules of a consultancy company that has many departments. * Each employee belongs to only one department. Each employee has a unique email address. * Each department has one manager and many employees. * Each project is owned by one department. * An employee can work on many projects with different roles but has one role for each project. * A project can have many employees and they can be from different departments. * The progress of projects is evaluated once a week by department managers. The evaluation of a project on a particular date has a rating, which is an integer between 0 (very bad) to 5 (excellent). Consider the below relational database schema of five relations for managing projects of the company. Possibly due to an ER model not well designed or incorrect mapping from the ER to relational model, the database schema is not fully in 3NF and contains data redundancy. Some example tuple is given to explain the meaning of attributes The Project Management Database Department(deptiD, deptName, manager, empID) Employee(empID, empName, deptiD, email) Project(projID, startYear, deptID) EmpProj(empID, projID, role) Evaluation (projID, manager, evalDate, rating)

Step by Step Solution

3.28 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

STEP 1 lets analyze each given relation and apply the necessary steps to reach the 3NF Given Relations 1 DepartmentdeptID deptName manager empID Functional dependencies deptID deptName manager empID d... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

13th edition

1337627909, 978-1337627900

More Books

Students also viewed these Databases questions