I am creating a database on students' interests using the Entity-Relationship Model for a University assignment.

Should I implement the circled stuff as attribute, or an entity set? ER Diagram for Student Interest Database

  • $\begingroup$ I believe rectangles represent entities in ER diagrams. $\endgroup$
    – Rinkesh P
    Commented Nov 15, 2022 at 3:18
  • $\begingroup$ Yes, you are correct. But my query is whether to implement it as a multi-valued attribute or an entity set. Kind of seems arbitrary to me. $\endgroup$ Commented Nov 15, 2022 at 6:13
  • $\begingroup$ It is arbitrary, there is no wrong or right way as long as you are following the normalisation procedures. Only you know what kind of relationships exist between entities and how to implement them $\endgroup$
    – Rinkesh P
    Commented Nov 15, 2022 at 6:30
  • $\begingroup$ A note, ER diagram necessarily doesn't translate to an efficient database implementation, details of which are beyond the scope of this question. $\endgroup$
    – Rinkesh P
    Commented Nov 15, 2022 at 6:36
  • $\begingroup$ I know about Normal Forms, but my goal is not to make the most efficient database implementation. I just want to show my professor that I did some work. $\endgroup$ Commented Nov 15, 2022 at 8:26


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.