retagged by
985 views
3 votes
3 votes

how many tables will get generated for following E-R

I believe an answer is 3.

2 tables for 2 different multivalued attributes and one for entity "Dept.".

retagged by

3 Answers

5 votes
5 votes
I think it should be 3.
One for the entity and 2 for multivalued attributes.
5 votes
5 votes

Answer is 1 table , option A

NOTE:- A: Deptno, B: DName, C: Phone and D: Office

Q) min table for 1 NF?

Sol) 1 table Dept(ACDB)

ACD as CK

Q) min table for 2 NF/ 3 NF / BCNF?

Sol) 2 table Dept1(AB) and Dept2(ACD)

CK: A for Dept1 and for Dept2: ACD

Q) min table for 4 NF?

Sol) 3 table Dep1 (AB) , Dept2(AC), Dept3(AD)

CK: A

1 votes
1 votes
Hi , there are two multivalued attributes , so , for each of them we need 1 table .

so , total 3 tables , i guess

Related questions

1 votes
1 votes
2 answers
2
himanich asked Jun 22, 2016
2,452 views
Which of the following are true for relational database?Number of rows is cardinality, number of columns is degreeTuple is an entity, column is a relationRelation is an e...
1 votes
1 votes
3 answers
3
ayushigupta asked Nov 21, 2015
2,669 views
3 votes
3 votes
4 answers
4
Himanshu1 asked Nov 5, 2015
2,571 views