Quick Ref.
Functions
date
number
string
Data Types
date
number
string

Southwind database

Southwind Entity relation diagram

Graduated questions

southwind.mdb

ER diagram for the Southwind database:

tprod(code, dscr, pric)
tcust (code, firm, addr)
tpurc (cust, recv)
tpurcd (cust, recv, prod, qnty)
tship (cust,recv,addr,shpd)
tshipd (cust, recv, shpd, prod, qnty)
tsupl (code, addr)
tdlvr (supl, recv)
tdlvrd (supl, recv, prod, qnty)
tretn (cust, recv, prod, qnty, expl)
tstck (chck, prod, qnty)
0a. The table tpurcdgives details of all products ordered. This table gives details of all purchase orders.

Results
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).

Results