Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

The Temple Of Django Database Performance

Authors: Andrew Brookins

1st Edition

1734303700, 978-1734303704

More Books

Students also viewed these Databases questions