Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
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)

icon
Related questions
Question
100%
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: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
E. F. Describe two modification anomalies that affect PROJECT. Is ProjectID a determinant? If so, based on which functional dependencies in part A?
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
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer