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 100-B 200-A FIGURE 2-33 Sample Data for Regional Labs Employee Name Eric Jones Donna Smith Donna Smith Eric Jones Employee Salary 64,000.00 70,000.00 70,000.00 64,000.00

icon
Related questions
Question
100%
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
F.
G.
H.
I.
Is ProjectID a determinant? If so, based on which functional dependencies in part A?
Is EmployeeName a determinant? If so, based on which functional dependencies
in part A?
Is (ProjectID, Employee Name) a determinant? If so, based on which functional
dependencies in part A?
Is Employee Salary a determinant? If so, based on which functional dependencies in part
A?
Transcribed Image Text:F. G. H. I. Is ProjectID a determinant? If so, based on which functional dependencies in part A? Is EmployeeName a determinant? If so, based on which functional dependencies in part A? Is (ProjectID, Employee Name) a determinant? If so, based on which functional dependencies in part A? Is Employee Salary a determinant? If so, based on which functional dependencies in part A?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions