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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3f5b12f9-6c64-402a-97c9-7da04028a60b%2F77599e7d-9821-4256-b5e9-3504a1178793%2Fsi2dke7j_processed.png&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)