Example (Tree Schema SU->WH->IT)

Supplier SU

Warehouse WH

Item IT

Only one warehouse of one supplier can supply a particular part in this (over-simplified) model.

Each arrow implies a foreign

key in each child table record.

Non-key fields::

Vendor name

Expiration date of price quotation

(Phone number and address)

(Non-key fields: ourItemNo, vendorPartNo, unitPrice, unitQuantity, and description)

Previous slide

Next slide

Back to first slide

View graphic version