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?
$\begingroup$
$\endgroup$
5
-
$\begingroup$ I believe rectangles represent entities in ER diagrams. $\endgroup$Rinkesh P– Rinkesh P2022-11-15 03:18:06 +00:00Commented 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$Suchet Saxena– Suchet Saxena2022-11-15 06:13:38 +00:00Commented 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– Rinkesh P2022-11-15 06:30:07 +00:00Commented 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– Rinkesh P2022-11-15 06:36:26 +00:00Commented 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$Suchet Saxena– Suchet Saxena2022-11-15 08:26:28 +00:00Commented Nov 15, 2022 at 8:26
Add a comment
|