Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer E through H Describe two modification anomaios that affect PROJECT F. Is ProjectID a determinant? If so, based on which functional dependencies in part
Answer E through H
Describe two modification anomaios that affect PROJECT F. Is ProjectID a determinant? If so, based on which functional dependencies in part A? Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 3-32 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT G. Is EmployoeName a deferminant? If so, based on which functional dependencies PROJECT (ProjectID, EmployeeName, EmployeeSalary) n part A7 H. Is (ProjectID. EmployeeName) a determinant? If so, based on which functional dependencies in part A? FIGURE 3-32 Sample Data for Regional Labs 100-A 100-A 100-B 200-A 200-B 200-C 200-C 200-D Eric Jones Donna Smith Donna Smith Eric Jones Eric Jones Eric Parks Donna Smith Eric Parks I.s EmployeeSalary a determinant? If so, based on which functional dependencies in part . Does this relation contain a transitive dependency? If so, what is it? K. Redesign the relation to eliminate modification anomalies. A. Assuming that all functional dependencies are apparent in this data, which of the following are true? ProjectDEmployeoName 2. ProjectiD EmployeeSalary 3. (ProjectiD, EmployeeName) EmployeeSalaryy 4 EmployeoNameEmployeeSalary 5. Em ployeeSalaryProjectiD 6. EmployeeSalary(ProjectiD, EmployeeName) B. What is the primary key of PROJECT? C. Are all the non-koy attributes (if any) dopondent on the primary key? D. In what normal form is PROJECTStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started