Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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) FIGURE 2-33 ProjectID 100-A Employee Name Eric Jones Employee Salary 64,000.00 Sample Data for 100-A Donna Smith 70,000.00 Regional Labs 100-B Donna Smith 70,000.00 200-A Eric Jones 64,000.00 200-B Eric Jones 64,000.00 200-C Eric Parks 58,000.00 200-C Donna Smith 70,000.00 200-D Eric Parks 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? a. Employee Name → Employee Salary b. ProjectID → EmployeeSalary O c. Employee Salary → ProjectID d. ProjectID → Employee Name e. EmployeeSalary → (ProjectID, EmployeeName)

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) FIGURE 2-33 ProjectID 100-A Employee Name Eric Jones Employee Salary 64,000.00 Sample Data for 100-A Donna Smith 70,000.00 Regional Labs 100-B Donna Smith 70,000.00 200-A Eric Jones 64,000.00 200-B Eric Jones 64,000.00 200-C Eric Parks 58,000.00 200-C Donna Smith 70,000.00 200-D Eric Parks 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? a. Employee Name → Employee Salary b. ProjectID → EmployeeSalary O c. Employee Salary → ProjectID d. ProjectID → Employee Name e. EmployeeSalary → (ProjectID, EmployeeName)

Management, Loose-Leaf Version
Management, Loose-Leaf Version
13th Edition
ISBN:9781305969308
Author:Richard L. Daft
Publisher:Richard L. Daft
Chapter7: Planning And Goal Setting
Section: Chapter Questions
Problem 2ED
See similar textbooks
icon
Related questions
Question
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) FIGURE 2-33 ProjectID 100-A Employee Name Eric Jones Employee Salary 64,000.00 Sample Data for 100-A Donna Smith 70,000.00 Regional Labs 100-B Donna Smith 70,000.00 200-A Eric Jones 64,000.00 200-B Eric Jones 64,000.00 200-C Eric Parks 58,000.00 200-C Donna Smith 70,000.00 200-D Eric Parks 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? a. Employee Name → Employee Salary b. ProjectID → EmployeeSalary O c. Employee Salary → ProjectID d. ProjectID → Employee Name e. EmployeeSalary → (ProjectID, EmployeeName)
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, EmployeeName, EmployeeSalary) FIGURE 2-33 ProjectID 100-A Employee Name Eric Jones Employee Salary 64,000.00 Sample Data for 100-A Donna Smith 70,000.00 Regional Labs 100-B Donna Smith 70,000.00 200-A Eric Jones 64,000.00 200-B Eric Jones 64,000.00 200-C Eric Parks 58,000.00 200-C Donna Smith 70,000.00 200-D Eric Parks 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? a. Employee Name → Employee Salary b. ProjectID → EmployeeSalary O c. Employee Salary → ProjectID d. ProjectID → Employee Name e. EmployeeSalary → (ProjectID, EmployeeName)
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Management, Loose-Leaf Version
Management, Loose-Leaf Version
Management
ISBN:
9781305969308
Author:
Richard L. Daft
Publisher:
South-Western College Pub
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS