Database Answers Header Kasbah du Toubkal Hotel, Morocco
Products and Characteristics Printer Printer-friendly version.
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
1) Back to the Original Design.

2) This Alternative Design shows the Color explicitly.
Any other characteristic that occurred frequently could also be shown explicitly.
When it did not apply to a particular product, it would simply be left blank, or NULL, (preferably NULL).
This makes the corresponding Database easier to use and understand.
There is no downside to this approach. A Data Modelling purist might object but the design is perfectly acceptable.
Dezign Data Model for Products and Generic Characteristics

[ Home Page | Ask Me a Question | Email Me | Site Map ]

© 2003