#doubt in ERD to relational DB

Question

E1 and E2 are strong entities with 1:m relationship via R.

we take 1 separate table for each strong entity => so 2 tables
But if there is 1 : n relationship, then we take 1 side entity into many side  => so it should be 1 table, not 2 as 1:n is given

please explain which one is correct? 

Comments

2 is correct , the thing that u are saying , if i  have interpreted it correct is you are thiking that as we can move relationship table to one side , so it should be 1 right?? but that 2 answer we got itself by subtracting 1 because in ERD we first basically make table for evreything (here everything refers to entity and relationship) , after that we try to reduce. as it is one to many relationship so the table which we need to built for relationship can be merge to many side. so thatis reduction of one table. therefor we need 2 tables here. as 2 tables ae strong entity asnd these entities will have their seprate attribute set. so there is no logic to converge them into single table. i hope you get the point. let me know in case of problem.

---

Thank you Mohit for your answer.

Answer 1

2 Tables are needed. For 2 strong entities, we make 2 tables, and then for reducing we shift R towards the many side of 1: m relationship i.e. we don’t require to build a separate table for relationship R.