3

I have designed an er-diagram and have an entity without any attributes. I need this entity (Item) to create a many-to-many relationshop but I guess there is a way to make this more efficient and getting rid of the entity without attributes.

ER DIAGRAM:

enter image description here

Thanks

fbid
  • 1,570
  • 2
  • 18
  • 29

2 Answers2

2

As I can see from your diagram your Item isn't just entity without attributes. It's a base type for your BAGEL and DRINK (you can think of this relationship as inheritance in OOP languages).

There are some techniques to work with inheritance in database world. So this Item is not a problem for ER-diagram.

Community
  • 1
  • 1
alexander.polomodov
  • 5,396
  • 14
  • 39
  • 46
1

ITEM should have at least one attribute - an identifier. A supertype's primary key can be reused as a foreign primary key in its subtypes.

reaanb
  • 9,806
  • 2
  • 23
  • 37