Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
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

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

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer