Results 1 to 3 of 3

Thread: M$SQL: Database design: Product Attributes??

Threaded View

  1. #1

    Thread Starter
    Frenzied Member <ABX's Avatar
    Join Date
    Jul 2002
    Location
    Canada eh...
    Posts
    1,622

    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
  •  



Click Here to Expand Forum to Full Width