Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions

Question

I need 2 NF normalization of this table data urgent pleaase

Answered: 1 week ago

Question

2. Define communication.

Answered: 1 week ago