Minimum number of tables to represent ER-Diagram

Question

How many minimum relations required for given ER diagram ?

Comments

@Satbir
I have a few questions.
1>while converting for ER-model to relational model foreign keys can only point to candidate keys.?
2>if we have a table X(A,B) where A and B are the attributes and A and B form the compound keys,then  if we have a table Y(P,Q,R) where R is the foreign key of Y  we can have (PQ ) as the foreign key in Y which points to the compund key (AB).?

3>foreign keys cannot point to non-key attributes.right?

Please answer.

 

---

foreign keys point to primary keys , not candidate keys.

A candidate key is a key which has the capability to become a primary key, but there is only 1 primary key in a table.

https://stackoverflow.com/questions/42268886/how-to-have-a-foreign-key-pointing-to-two-primary-keys

---

https://csedoubts.gateoverflow.in/16478/self-doubt-dbms-er-diagrams

That mean here RELATIONAL MODEL no.1  is correct .right?

Answer 1

Answer should be 5

(E1,R4,E4), R1, R2, (E2,R3,E3,R5), (R6,E5)

Answer 2

Min No of tables : 7

1.E5R6(H,F,I ,J)

2.R3E2(D,E,F)

3.E3(F,G)

4.R1(A,D)

5.E1R1(A,B,C,D)

6.R2(D,D)

7.E4R4(K,L,A) 

 

Answer 3

Min No of tables : SEVEN

1.E5R6(H,F,I ,J)

2.R3E2(D,E,F)

3.E3(F,G)

4.R1(A,D)

5.E1R1(A,B,C,D)

6.R2(D,D)

7.E4R4(K,L,A) 

 

Answer 4

Minimum No of tables : Seven

1.E5R6(H,F,I ,J)

2.R3E2(D,E,F)

3.E3(F,G)

4.R1(A,D)

5.E1R1(A,B,C,D)

6.R2(D,D)

7.E4R4(K,L,A)