#DBMS ER Model - Minimum Number of tables

Question

What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?

 

 

Comments

2

1

2

1

2

---

Can anyone tell what is the correct answer !

Also I am unable to understand questions based on number of tables given ER diagram ( even from the links)

Please mention any resource / any way so that we can find the answer to these kind of questions easily!

---

2.1.2.1.1

Answer 1

A)2

B)3

C)3

D)2

E)2

Answer 2

As Relationship (1:M or 1:1 or 1:N) we require only 2 tables, but there is condition that no multi valued attribute is attached with any entity.

But in (M:N) relationship we require 3 tables same condition also holds then it is true.

Comments

youwrong on the case of1:1 because if both side partial participation then the number of table is 2

---

Please refer to https://gateoverflow.in/77410/doubt for correct explanation

Answer 3

2

1

2

1

2

Answer 4

Answer will be 2 3 3 1 1.