Need help with DB design in around product tables RRS feed

  • Question

  • Hello friends,

    I am newbie in DB. Could you please help me with ideas of designing tables please.

    I have an exercise that design DB for hiring product company with require the following thing:

    - product belong to category
    - product have different brand - and brand define the price - price obtained from various suppliers.

    So that i create the following tables as below.Is it right?

    Product (Product_ID, Product Name, Product Type, Product Brand , Supplier, Product Price

    Category (Category_ID, Category Name, Category Description)

    Supplier (Supplier_ID, Supplier Name, Supplier Address, Supplier Phone)

    Brand (Brand_ID, Brand Name)

    Do i need to create Brand table?

    Thanks in advance.
    Sunday, August 26, 2012 8:33 AM


All replies