recategorized by
6,321 views

2 Answers

Best answer
0 votes
0 votes

Ans : B

Second Normal Form (2NF)

As per the Second Normal Form there must not be any partial dependency of any column on primary key. It means that for a table that has concatenated primary key, each column in the table that is not part of the primary key must depend upon the entire concatenated key for its existence. If any column depends only on one part of the concatenated key, then the table fails Second normal form.

0 votes
0 votes
After Removing Partial Dependency we get 2NF

PD: Prime-attribute ----->non-prime

Related questions

1 votes
1 votes
1 answer
1
rishu_darkshadow asked Sep 17, 2017
900 views
Match the following :$\begin{array}{clcl} \text{(1)} & \text{Determinants} & \text{(a)}\ & \text{No attribute can be added} \\ \text{(2)} & \text{Candidate key} & \t...
1 votes
1 votes
1 answer
2
rishu_darkshadow asked Sep 17, 2017
2,074 views
Analysis of large database to retrieve information is called(A) OLTP(B) OLAP(C) OLDP(D) OLPP
5 votes
5 votes
4 answers
3
rishu_darkshadow asked Sep 17, 2017
6,339 views
Specialization is __________ process.(A) top-down(B) bottom up(C) both (A) and (B)(D) none of these
2 votes
2 votes
4 answers
4
rishu_darkshadow asked Sep 17, 2017
4,615 views
The E-R model is expressed in term ofI. EntitiesII. The relationship among entities.III. The attributes of the entities.IV. Functional relationship.(A) I, II(B) I, II, IV...