Chapter 1 Exercise 19

19. Refer to the relationship/class diagram to explain what a Component is and how it is connected to a Bicycle. Give an example from the data.

Essentially a component is an item installed on a bicycle (pedals, tires, and so on). The Component table lists the possible components and prices. The BikeParts table lists the components that are specifically installed on each bicycle.

Bicycle(SerialNumber, ) -> BikeParts(SerialNumber,

ComponentID, Quantity, ) -> Component(ComponentID,).

You can pick almost any bicycle and trace the parts installed on it. The purpose of the assignment is to begin the familiarization process with the database. Bicycle Serial Number: 39158 (Mountain full)

CompID ProdNumber Category ListPrice
104910 HD-XTR900 Headset $99.00
214500 FD-XTR960 Front derailleur $150.00
314940 RD-XTR960 Rear derailleur $140.00
411400 LV-XTR965 Brakeset levers $475.00
514730 BR-XTR965 Brakes $400.00
618300 CR-XTR970 Crank $600.00
819200 CG-XTR960-2006 Rear cogs $175.00
919130 HB-Easton-EC90 CNT Handlebar $175.00
1021630 ST-Easton-EA70-ATB Stem $100.00
1116230 SP-Easton-EC90-MTB Seat post $235.00
1231700 SA-Italia1-Ti Saddle $90.00
1308440 CH-PC991 Chain $70.00
1426840 FK-Talas32 Fork $700.00
1514120 PD-EggTi Pedals $300.00
1607580 FW-XTR Front wheel $200.00
1718580 RW-XTR Rear wheel $250.00
1824730 TI-Pan-Trail-1.8 Tire $50.00
1824740 TI-Pan-Trail-2.1 Tire $50.00