edited by
1,312 views
5 votes
5 votes

Consider the following E-R diagram:

 

What is the minimum relations required which satisfied the 2nd normal form?

A) 1
B) 2
C) 3
D) 4
edited by

3 Answers

6 votes
6 votes

There will be 4 tables as follows:

$E_1$(A,C) (for mutivalued attribute C)

$E_1$(A,B)  

$E_2$(D,E,F) 

R(A,D)  (for m:n relationship )

edited by

Related questions

3 votes
3 votes
4 answers
3
ashish pal asked Nov 18, 2017
1,248 views