Question: Why is this the right answer? Please really motivate so it's understandable, thanks. Question 7 Which relational schema corresponds best to the following ER diagram?

Why is this the right answer? Please really motivate so it's understandable, thanks.
Question 7 Which relational schema corresponds best to the following ER diagram? A1 A2 A1 A2 N 1 E1 R E2 A E1(A1, A2), E2 (A1, A2) R(E1, E2) (with R.E1 FK ref. E1 A1 and R.E2 FK ref. E2.A1) BE1A1, A2), E2 (A1, A2), R(E1, E2) (with R.E1 FK ref. E1 A1 and R.E2 FK ref. E2 A1) CE1A1, A2), E2(A1, A2, E1) (with E2.E1 FK ref. E1.A1) D E1 (E2, A1, A2), E2 (A1, A2) (with E1 E2 FK ref. E2 A1) E E1A1, A2, E2), E2 (A1, A2)(with E1 E2 FK ref. E2.A1) F None of the other answers Answer e
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
