edited by
2,207 views

3 Answers

6 votes
6 votes
Given ER diagram is 1:M relation.

For $R_2$ we need single table as we can combine $R_2$ with $R_{12}$

$T_1=(R_2,R_{12})$

Entity $R_1$ and attribute $B$ which is a multivalued attribute need a separate table.

$T_2=(R_1)$,

$T_3=(B)$

So total $3$ tables required.

Option $(3)$ is correct.
edited by
0 votes
0 votes
Correct answer will be 4

Considering best deisgn with no null values allowed in the tables

So B is the answer

Related questions

1 votes
1 votes
2 answers
2
4 votes
4 votes
6 answers
4
soujanyareddy13 asked May 12, 2021
1,869 views
The Boolean expression $AB+A \overline{B}+\overline{A}C+AC$ is unaffected by the value of the Boolean variable _________.$A$$B$$C$$A, B$ and $C$