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 |