Minimum no. of tables for the e-r diagram

Asked Dec 05 '17 at 18:52

Active Dec 16 '17 at 15:33

Viewed 261 times

Consider there is a binary relationship R(with no attributes of its own) between two entities A and B in an e-r diagram. Suppose B to A has a many - one cardinality constraint and B has a total participation in R.

How many minimum tables are required to depict this in relational model?
Can i merge R and B ? Why or Why not?

edited Dec 16 '17 at 15:33

Bhargav Rao

45,811
27
120
136

asked Dec 05 '17 at 18:52

aditya kuppa

That's a many to many relation there @ghlomali – aditya kuppa Dec 08 '17 at 02:37
Many to one or many to many? Your comment is introducing confusion, @adityakuppa. – reaanb Dec 09 '17 at 06:52
Please show what you have been able to do. We are not here to do your homework. "Merge" isn't a technical term, what are you trying to say? – philipxy Dec 09 '17 at 08:58
many to many OR many to one???? can you give a ER Model instead of explaining? – Gholamali-Irani Dec 09 '17 at 12:19
If you have many-to-many, I should delete my answer. Then your answer is just 3 Tables and you can not reduce them to 2. – Gholamali-Irani Dec 09 '17 at 12:22
I deleted my answer, because I thought many-to-one relationship. – Gholamali-Irani Dec 09 '17 at 12:30

Minimum no. of tables for the e-r diagram

0 Answers0