Employee Salary 64,000.00 70,000.00 70,000.00 64,000.00 64,000.00 58,000.00 70,000.00 58,000.00 ProjectID 100-A EmployeeName Eric Jones Donna Smith Donna Smith Eric Jones Eric Jones Eric Parks Donna Smith Eric Parks 100-A 100-B 200-A 200-B 200-C 200-C 200-D
Regional Labs is a company that conducts research and development work on a contract
basis for other companies and organizations. Figure 2-33 shows data that Regional Labs
collects about projects and the employees assigned to them.
This data is stored in a relation (table) named PROJECT:
PROJECT (ProjectID, EmployeeName, EmployeeSalary)A. Assuming that all functional dependencies are apparent in this data, which of the following are true?
1. ProjectID → EmployeeName
2. ProjectID → EmployeeSalary
3. (ProjectID, EmployeeName) → EmployeeSalary
4. EmployeeName → EmployeeSalary
5. EmployeeSalary → ProjectID
6. EmployeeSalary → (ProjectID, EmployeeName)
B. What is the primary key of PROJECT?
C. Are all the nonkey attributes (if any) dependent on the primary key?
D. In what normal form is PROJECT?
E. Describe two modification anomalies that affect PROJECT.
F. Is ProjectID a determinant? If so, based on which functional dependencies in part A?
G. Is EmployeeName a determinant? If so, based on which functional dependencies in
part A?
H. Is (ProjectID, EmployeeName) a determinant? If so, based on which functional dependencies in part A?
I. Is EmployeeSalary a determinant? If so, based on which functional dependencies in
part A?
J. Does this relation contain a transitive dependency? If so, what is it?
K. Redesign the relation to eliminate modification anomalies.
![Employee Salary
64,000.00
70,000.00
70,000.00
64,000.00
64,000.00
58,000.00
70,000.00
58,000.00
ProjectID
100-A
EmployeeName
Eric Jones
Donna Smith
Donna Smith
Eric Jones
Eric Jones
Eric Parks
Donna Smith
Eric Parks
100-A
100-B
200-A
200-B
200-C
200-C
200-D](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fcfd39f92-9dae-47eb-ba4e-15a276bae42f%2F5da56a4e-c543-49ba-8510-6ab3b5d44954%2Fvlfq4vl_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)