Register

ISRO-2013-25

8,972 views
11 11 votes

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

1 Answer

Best answer
16 16 votes
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
• selected by
Voting & Accepting an answer helps improve the community
Answer:
← Previous · ISRO-2013-24Next → · Facts about AVL tree
← Previous in category · ISRO-2013-24Next in category → · ISRO-2013-26
Position:
Show:

Related questions

9 9 votes
5 answers 5 answers
9.9k
9.9k views
Misbah Ghaya asked May 2, 2016
9,862 views
ISRO-2013-61, ISRO CSE 2008 | Question: 35
Embedded pointer providesA secondary access pathA physical record keyAn inverted indexA primary key
9 9 votes
2 answers 2 answers
6.6k
6.6k views
Misbah Ghaya asked Apr 27, 2016
6,625 views
ISRO-2013-27
The physical location of a record determined by a formula that transforms a file key into a record location isHashed file$B$-Tree fileIndexed fileSequential file
9 9 votes
2 answers 2 answers
10.9k
10.9k views
Misbah Ghaya asked Apr 27, 2016
10,898 views
ISRO-2013-26
Calculate the order of leaf ($P_{leaf}$) and non leaf (P) nodes of a $B^{+}$ tree based on the information given below.Search key field = $12$ fieldRecord pointer = $10$ ...
6 6 votes
2 answers 2 answers
9.2k
9.2k views
Misbah Ghaya asked Apr 26, 2016
9,207 views
ISRO-2013-24
Consider the following relational schema:Suppliers (sid:integer, sname:string, saddress:string)Parts (pid:integer, pname:string, pcolor:string)Catalog (sid:integer, pid:i...