772 views
1 votes
1 votes

Number of tables required in above ER diagram will be _____________


Is $R_{1}$ create separate table or not?? and $R_{2}$ look like if we remove loop from it??

Answer given for table $E_{1}R_{1}$ Key will be $AC$ , with $C$ foreign key.

And for $E_{2}R_{2}$ Key will be $C$ and $C_{1}$ foreign key.

But I think $E_{2}$ itself $2$ Entities. So, it will add one extra table.

I already read https://gateoverflow.in/229580/madeeasy-test-series-number-of-tables-required

Please log in or register to answer this question.

Related questions

2 votes
2 votes
1 answer
1
0 votes
0 votes
1 answer
2
sh!va asked Nov 7, 2016
311 views
Is there any way to establish a Relation between tables in different databases??
0 votes
0 votes
1 answer
3
Mrityudoot asked Jan 12
128 views
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
1 votes
1 votes
1 answer
4
Sajal Mallick asked Nov 5, 2023
336 views
Unique not null is equivalent to primary key.Relational Algebra and SQL has same expressive power.Which of the above statements are False?