Regional Labs is a company that conducts research and development work on a contract bas 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 (ProiectID EmployeeName EmployeeSalary)
Regional Labs is a company that conducts research and development work on a contract bas 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 (ProiectID EmployeeName EmployeeSalary)
Related questions
Question
100%
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, Employee Name, EmployeeSalary)
ProjectID
100-A
100-A
FIGURE 2-33
Sample Data for
Regional Labs
100-B
200-A
200-B
200-C
200-C
200-D
EmployeeName
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
70,000.00
58,000.00
Transcribed Image Text:E.
F.
Describe two modification anomalies that affect PROJECT.
Is ProjectID a determinant? If so, based on which functional dependencies in part A?
Expert Solution
Step 1: about the sql
SOLUTION -
From the Given table -
we have given a table PROJECT with ProductId, EmployeeName, EmployeSalary and it trying to determine various aspects of its functional dependencies and normal form
Step by step
Solved in 3 steps
