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
    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$ 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
    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
    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$ Nov 15, 2022 at 8:26


Your Answer

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

Browse other questions tagged or ask your own question.