The Gateway to Computer Science Excellence
+6 votes
2.5k views

Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation.

ISBN $\rightarrow$ Title

ISBN $\rightarrow$ Publisher

Publisher $\rightarrow$ Address

  1. First Normal Form
  2. Second Normal Form
  3. Third Normal Form
  4. BCNF
in Databases by Boss (30.9k points) | 2.5k views

1 Answer

+8 votes
Best answer
The relation is in second normal form .

We first need to find Candidate key by taking closure of attributes = ISBN

Now with ER modelling we get relation in 1 NF .

for 2nf , we shouldnt have any partial dependency ( A non key shouldnt be fully functionally dependent on a subset of Ck )

Since our Ck is 1 attribute only we wont have that partial dependency

But now for 3nf , if you see we have Address which is transitively dependent on ISBN . Hence Transitive dependency exists .

So relation is in 2nf and not in 3nf
by Loyal (9.9k points)
selected by
+1

A non key shouldnt be fully functionally dependent on a subset of Ck 

It must be "PROPER subset". But what's the significance of "fully" here?

0
Fully functionally dependent mean it shouldnt have any redundant attribute
0
Yes and Proper subset is MUST .
Answer:

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,391 answers
198,591 comments
105,442 users