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
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
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
