Given the following relation that stores details of  employees and their projects:

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter14: Introduction To Swing Components
Section: Chapter Questions
Problem 10PE
icon
Related questions
Question

Given the following relation that stores details of  employees and their projects:

 

ProjectID
EmployeeName
EmployeeSalary
100-A
Salim Housni
2000
100-A
Taleb Maashani
1800
100-B
Taleb Maashani
1800
200-A
Salmi Alrisi
2000
200-B
Salmi Alrisi
2000
200-C
Salmi Alrisi
1350
200-C
Taleb Maashani
1800
200-D
Salim Housni
1350
If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE.
ProjectID > EmployeeName|
ProjectID > EmployeeSalary |
ProjectID, EmployeeName → EmployeeSalary
EmployeeName → EmployeeSalary
EmployeeSalary → ProjectID|
EmployeeSalary → EmployeeName , ProjectID
Transcribed Image Text:ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salmi Alrisi 2000 200-B Salmi Alrisi 2000 200-C Salmi Alrisi 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. ProjectID > EmployeeName| ProjectID > EmployeeSalary | ProjectID, EmployeeName → EmployeeSalary EmployeeName → EmployeeSalary EmployeeSalary → ProjectID| EmployeeSalary → EmployeeName , ProjectID
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Arrays
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage