1,619 views
1 1 vote

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.

Position:
Show:

Related questions

1 1 vote
0 0 answers
733
733 views
Shreyas_Jadhav asked Jan 23, 2025
733 views
In the Entity-Relationship (ER) model, what is the cardinality ratio that represents a relationship where each entity instance in one entity set is associated with exactl...
2 2 votes
1 1 answer
2.9k
2.9k views
srestha asked May 13, 2019
2,859 views
Consider the following statement below:$A)$ A clustered index may be either sparse or dense.$B)$ Every $B^{+}$ tree index is dense.Which of the above statement is true?Is...
0 0 votes
1 1 answer
534
534 views
sh!va asked Nov 7, 2016
534 views
Is there any way to establish a Relation between tables in different databases??
0 0 votes
0 0 answers
464
464 views
DTYDHTB asked Dec 12, 2025
464 views
Consider a database system where transactions are executed concurrently. If transaction T1 holds an exclusive lock on resource R1 and requests a shared lock on resource R...