Question
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. PROJECT: 1)Assuming that all functional
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. PROJECT: 1)Assuming that all functional dependences are apparent in this data, which of the following are true: ProjectID -> EmployeeName ProjectID -> EmployeeSalary (ProjectID, EmployeeName) -> EmployeeSalary EmployeeName - > EmployeeSalary EmployeeSalary -> ProjectID EmployeeSalary -> (ProjectID, EmployeeName) What is the primary key of PROJECT Are all the nonkey attributes (if any) dependent on the primary key In what normal form (1NF, 2NF, 3NF) is PROJECT ? 5. Describe two modifications anomalies that effect PROJECT 6. Is ProjectID a determinant ? If so based on which functional dependency ? 7. Is EmployeeName a determinant if so, based on which functional dependencies in part A 8. Is (ProjectID, EmployeeName) a determinant ? If so, base on which functional dependencies in Part A 9. Is EmployeeSalary a determinant? If so, base on which functional dependancies in Part A 10. Does this relation contain a transitive dependency ? (if so, what is it ?) 11. Redesign the relation to eliminate modification anomalies
Step 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