2,738 views
1 votes
1 votes

Given answer is 2, but I think that for each multivalue attribute we need a relation and one for the main entity, therefore 3 should be the answer. Please correct me if I am wrong

1 Answer

Best answer
10 votes
10 votes

Minimum Table require 

1NF = 1 table  (Dno Dname Phone Office)
BCNF = 2 table (Dno Dname) (Dno Phone Office)
4Nf = 3 Table for each MVD one table  (Dno Dname) (Dno Phone) (Dno Office)

selected by
Answer:

Related questions

1 votes
1 votes
3 answers
1
ayushigupta asked Nov 21, 2015
2,669 views
3 votes
3 votes
4 answers
2
Himanshu1 asked Nov 5, 2015
2,572 views
3 votes
3 votes
1 answer
4
Manu Thakur asked Sep 17, 2017
1,862 views
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram: