|
-
Dec 26th, 2004, 06:25 PM
#1
Thread Starter
Frenzied Member
M$SQL: Database design: Product Attributes??
I am creating a database of products ....
Each product has the following:
ProductID, ProductName, ProductManufacturer, InventoryCount, PricePerUnit
these products are computer parts such as processors, ram, motherboards, even entire computers... how would you suggest storing these attributes.
for a processor i would want to have attributes like:
ClockSpeed, Multiplier, FSB, ExternalClock, InternalCache, ect
for a hard drive i would want to have attributes like:
Size, BufferSize, RPM, S.M.A.R.T., ect.
Is the only way creating multiple tables for each type of device?
Last edited by <ABX; Dec 26th, 2004 at 06:31 PM.
Reason: thought i should cliarify the database format
Tips:
- Google is your friend! Search before posting!
- Name your thread appropriately... "I Need Help" doesn't cut it!
- Always post your code!!!! We can't read your mind!!! (well, at least most of us!)
- Allways Include the Name and Line of the Exception (if one is occuring!)
- If it is relevant state the version of Visual Studio/.Net Framwork you are using (2002/2003/2005)
If you think I was helpful, rate my post  IRC Contact: Rizon/xous ChakraNET/xous Freenode/xous
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|