Quick
Ref.
Functions
- date
- number
- string
Data Types
- date
- number
- string
Southwind database
Graduated questions
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
|