Which of the following is a correct attribute set for one

Home » Database » Database miscellaneous » Question

Direction: 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?

1. {M₁, M₂, M₃ P₁}
2. {M₁, P₁, N₁, N₂}
3. {M₁, P₁, N₁}
4. {M₁, P₁}

Correct Option: A

Two tables in the scenario will be M₁ ,M₂ ,M₃ ,P₁ which is for relation R₁ &N₁ ,N₂ ,P₁ ,P₂ with P₁ as primary key N₁ is a weak entity set. This is for relation R₂.