Keys
August 9, 2024Database-Management-System
August 9, 2024GATE 2008
|
Question 83
|
Consider the following ER diagram

Which of the following is a correct attribute set for one of the tables for the correct answer to the above question?
|
{M1, M2, M3, P1}
|
|
|
{M1, P1, N1, N2}
|
|
|
{M1, P1, N1}
|
|
|
{M1, P1}
|
Question 83 Explanation:
Possible set of attributes is
For M = {M1, M2, M3, P1}
P = {P1, P2}
N = {N1, N2, P1}
For M = {M1, M2, M3, P1}
P = {P1, P2}
N = {N1, N2, P1}
Correct Answer: A
Question 83 Explanation:
Possible set of attributes is
For M = {M1, M2, M3, P1}
P = {P1, P2}
N = {N1, N2, P1}
For M = {M1, M2, M3, P1}
P = {P1, P2}
N = {N1, N2, P1}
