90-802 Computer Applications for Public Managers

Summer 1997

Homework Assignment #2 - Additional Problem



  1. For each of the tables from the Sweet Lil's database that appear on the reverse side of this handout, identify the following:
  2. Draw the E-R diagram for the 3 tables.

  3. Explain why or why not the table "Box Details" is a linking table.

Bonbons

Bonbon ID
Bonbon Name
Chocolate Type
Nut Type
Filling Type
Bonbon Description
Bonbon Cost
Picture
B01 Candlelight Ecstasy Bittersweet Cashew Mocha cream Cashew in mocha cream covered with bittersweet chocolate, to keep lovers down to earth. $0.30
B02 Bittersweet Blueberry Bittersweet None Blueberry Cascade Mountain blueberries covered with bittersweet chocolate, for that alpine touch. $0.25

Boxes

Box ID
Box Name
Size
Box Description
Box Price
Quantity on Hand
Discontinued
ALLS All Seasons 8 Blueberries, raspberries, and strawberries to enjoy all season, both bitter and sweet. $14.00 700 No
ALPI Alpine Collection 12 Straight from the high Cascades, alpine blueberries and strawberries in our best chocolate. $20.75 400 No
SWE2 Sweet Creams 12 Sweet creams for everyone who loves fine cream fillings--mocha, cherry, and peanut butter. $23.00 200 No

Box Details

Box ID
Bonbon ID
Quantity
SWE2 B01 6
SWE2 B02 2
ALPI B02 4