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 Databases made-easy-test-series databases + – srestha 1.6k views answer comment Share Follow Print See all 10 Comments 10 10 Comments reply Show 7 previous comments srestha commented Jun 10, 2019 reply Follow flag 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 replyShare aditi19 commented Jun 10, 2019 reply Follow flag yes right so is it referencing? a table referring to itself so there should be foreign key then 0 0 replyShare srestha commented Jun 10, 2019 reply Follow flag foreign key? why?? Same primary key for both tables. 0 0 replyShare Please log in or register to add a comment.