Question: The relation ( second ) with S$ as key is: S$ status city S 1 2 0 London S 2 1 0 Paris S 3

The relation (second) with S$ as key is:
S$ status city
S120 London
S210 Paris
S310 Paris
S420 London
S530 New York
There is a dependency of status from the city. (functional dependency)(f.e. all the suppliers in London must have the status 20). The status and city are not functionally depended on the key S$. Status and city are not mutually independent
a. Examine if it is : 1NF,2NF,3NF, BCNF (give explanation).
b. If it is not a 3NF how we can take a 3NF ?

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 Databases Questions!