Initial Tables for Bicycle Assembly

BicycleAssembly(

SerialNumber, Model, Construction, FrameSize, TopTube, ChainStay, HeadTube, SeatTube,

PaintID, PaintColor, ColorStyle, ColorList, CustomName, LetterStyle, EmpFrame, EmpPaint,

BuildDate, ShipDate,

(Tube, TubeType, TubeMaterial, TubeDescription),

(CompCategory, ComponentID, SubstID, ProdNumber, EmpInstall, DateInstall, Quantity, QOH) )

Bicycle(SerialNumber, Model, Construction, FrameSize, TopTube, ChainStay, HeadTube, SeatTube,

PaintID, ColorStyle, CustomName, LetterStyle, EmpFrame, EmpPaint, BuildDate, ShipDate)

Paint(PaintID, ColorList)

BikeTubes(SerialNumber, TubeID, Quantity)

TubeMaterial(TubeID, Type, Material, Description)

BikeParts(SerialNumber, ComponentID, SubstID, Quantity, DateInstalled, EmpInstalled)

Component(ComponentID, ProdNumber, Category, QOH)