J. K. Does this relation contain a transitive dependency? If so, what is it? Redesign the relation to eliminate modification anomalies.

icon
Related questions
Question
100%
J.
K.
Does this relation contain a transitive dependency? If so, what is it?
Redesign the relation to eliminate modification anomalies.
Transcribed Image Text:J. K. Does this relation contain a transitive dependency? If so, what is it? Redesign the relation to eliminate modification anomalies.
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, Employee Name, EmployeeSalary)
ProjectID
100-A
100-A
FIGURE 2-33
Sample Data for
Regional Labs
100-B
200-A
200-B
200-C
200-C
200-D
EmployeeName
Eric Jones
Donna Smith
Donna Smith
Eric Jones
Eric Jones
Eric Parks
Donna Smith
Eric Parks
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
Transcribed Image Text: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, Employee Name, EmployeeSalary) ProjectID 100-A 100-A FIGURE 2-33 Sample Data for Regional Labs 100-B 200-A 200-B 200-C 200-C 200-D EmployeeName Eric Jones Donna Smith Donna Smith Eric Jones Eric Jones Eric Parks Donna Smith Eric Parks 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer