CSCI A114 / INFO I111
Lecture Notes Eleven

First semester 2001-2002

More database design.

Problem for today is: You own a store. Merchandise that you sell includes:

dek001 for US $10.00 a copy
dek002 for US $15.00 a copy
hpb001 for US $20.00 a copy
con001 for US $25.00 a copy
con002 for US $30.00 a copy

One day lbird came and bought 2 copies of dek001, and a copy of dek002. Later that day mjordan came and bought 3 copies of hpb001. Next day tkukoc came and bought dek001, dek002, and hpb001, a copy of each. The day after that, lbird came and bought a copy of con001.

Design a database that could store this data.

Then think what it takes to answer the following questions:

what's the average purchase order?
what's the average purchase order per customer?
list the orders above average
list all the books that have been bought, sorted by quantity
list all the books that have not been purchased yet

We'll also talk about the homework.

Last updated: October 2, 2001 by Adrian German for A114/I111

CSCI A114 / INFO I111 Lecture Notes Eleven

CSCI A114 / INFO I111
Lecture Notes Eleven