AFM241 Midterm: 053106484695053106484695_27

This establishes a new entity named BACK_ORDER. This relation is optional because most

products are not usually out of stock

An invoice may generate more than one back order so a 1:M relation exists between

INVOICE and BACK_ORDER

A product can appear in many back orders, and back orders can include many products, thus

creating a M:N (think the textbook meant M:M) relation. Since the implementation of this

kind of relation should be avoided, the M:N will be split up using the BACK_ORD_LINE entity.

BlueBikes Database: All Three Modules

find more resources at oneclass.com