Weak Entities

• Cannot exist without another entity with which it has a relationship

  • line items require an order to exist

• Has a primary key derived from the parent entity

  • line item key = order number +line item number

• Shown as a double rectangle

Order

Line Item

contains

• customer no.

• order no.

• order no.

• item no.

1

N

Previous slide

Next slide

Back to first slide

View graphic version