MadeEasy Subject Test: Databases - Er Diagram

Question

Comments

I think this should be the config

Tables are

E1R2(A, B,C,D) A IS CK

R1(AD) AD IS CK

E2R4(DED') D IS CK

R3(DFGH) DF IS CK

Foreign Keys

E1R2.D
R1.A

R1.D

E2R4.D'

R3.D

No of foreign keys are 5.

---

 Shubhanshu 
Shouldn't Ans be 5 )
As,
E1R2  has  D as Foreign key
R1 has A & D both as foreign key 
E2R4 has D' as Foreign key
R3 has D as Foreign key 

---

Yup, I missed it.

Answer 1

Minimum 5 foreign Keys are required