Database Answers Racing Bike on Snow (Click for Bike Company Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Bikes and Customsation 
Back to the Data Model
Subject: relational database entities relationships

Question: If we have a standard BIKE that we sell and is assembled by our shop. 

this bike has all standard parts that is captured on a Bill of Materials. 

However we give the customer the option to customize their bikes by substituting parts (upgrades, extra features, etc.) 

how do we capture the parts substituion on the datbase? Hope this is enough information. THANKS!
Barry Williams
October 2nd. 2011
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map