in Databases
771 views
1 vote
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

in Databases
by
771 views

4 Comments

if both arrow in same direction, then meaning changes. Then it doesnot mean two $E_{2}$ table and in between one $R_{2}$ relation.

Meaning totally changes and it act as single arrow with total participation
1
1
yes right
so is it referencing?

a table referring to itself
so there should be foreign key then
0
0
foreign key? why??

Same primary key for both tables.
0
0

Please log in or register to answer this question.