Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
Assuming that all functional dependencies are apparent in this data, which of the following are true? 1. ProjectID →→ Employee Name 2. ProjectID →→ EmployeeSalary 3. EmployeeName → EmployeeSalary 4. EmployeeSalary → ProjectID 5. EmployeeSalary → (ProjectID, EmployeeName) TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE

Assuming that all functional dependencies are apparent in this data, which of the following are true? 1. ProjectID →→ Employee Name 2. ProjectID →→ EmployeeSalary 3. EmployeeName → EmployeeSalary 4. EmployeeSalary → ProjectID 5. EmployeeSalary → (ProjectID, EmployeeName) TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE

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 Sample Data for Regional Labs A. ProjectID 100-A 100-A 100-B 200-A 200-B 200-C 200-C 200-D Employee Name 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 1. ProjectID → Employee Name 2. ProjectID EmployeeSalary 3. EmployeeName → EmployeeSalary 4. EmployeeSalary → ProjectID 5. EmployeeSalary → (ProjectID, EmployeeName) 70,000.00 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE
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 Sample Data for Regional Labs A. ProjectID 100-A 100-A 100-B 200-A 200-B 200-C 200-C 200-D Employee Name 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 1. ProjectID → Employee Name 2. ProjectID EmployeeSalary 3. EmployeeName → EmployeeSalary 4. EmployeeSalary → ProjectID 5. EmployeeSalary → (ProjectID, EmployeeName) 70,000.00 58,000.00 Assuming that all functional dependencies are apparent in this data, which of the following are true? TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE TRUE / FALSE
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