A Gentle Introduction to


Pick an engine:

Southwind database

Graduated questions


ER diagram for the Southwind database:

Entity relation diagram er3

0a The table tpurcdgives details of all products ordered. This table gives details of all purchase orders.

0b Some of the tables are joined by a composite foreign key. For example to link shipment details to a shipment record we must join on (cust,shpd).