Question: The following table relation lists sample staff data. 1 - Identify the functional dependencies represented by the attributes shown in the table. 2 - Normalize

The following table relation lists sample staff data.
1- Identify the functional dependencies represented by the attributes shown in the table.
2- Normalize the Staff table, generate the 1NF,2NF, and the 3 NF relations.
\table[[Staff,,,,,],[staffID staffName countryCode Country,,staffEmail companyID companyName,,,],[1,Helen,1,USA,helen@email.email 1,Apple],[2,Smith,1,USA,smith@email.email 1,Apple],[3,Tony,1,USA,tony@email.email 2,Google]]
The following table relation lists sample staff

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!