edited by
825 views

1 Answer

Best answer
5 votes
5 votes
I assume following dependencies for 4(a)

Book-id->Book-category, Author

Author-> Nationality-of-Author

so it is in 2NF since no partial dependency but not in 3NF because the non-prime attribute Author is deriving Nationality

b) If book-title and Author-name is the key then it will be in 1NF because

book-title->book-id

Author-Name->Author-Address,Nationality can be derived

if Address is multivalued attribute then it is not in 1NF also
selected by

Related questions

31 votes
31 votes
8 answers
2
Kathleen asked Sep 25, 2014
10,223 views
Which normal form is considered adequate for normal relational database design?$2NF$$5NF$$4NF$$3NF$
9 votes
9 votes
2 answers
3
Deepthi_ts asked Apr 26, 2017
579 views
IF a relation R(A,B,C,D,E) whereAB is the key andADE->Cso is this in 2NF or not?Do Partial dependency exist??? because C is derived from ADE (A is part of key AB)
0 votes
0 votes
1 answer
4
jatinkumar asked Jan 25, 2017
356 views
plz explain why the answer is occupation ????