#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    2
    Rep Power
    0

    Unhappy Database Design Help


    Hi All

    I am trying to design a database and I am stuck. My database will store customer feedbacks /complaints where customers will

    select

    First, country they live in (approx 15 countries)
    Second, Product (20 different products)
    Third, Model No (up to 5 models)

    For example if you select US as country, products available may be different then the products available to UK. Hence Model Numbers.


    I have 2 options:

    1- Use dynamic Javascript to store the information

    2 - create tables

    I would prefer using tables, but this means I will create quit a lot of tables to store all the information (after the normalisation).

    What would be the best way to handle this problem. I hope someone can help me.

    Thank you
  2. #2
  3. Introspective
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Nov 2001
    Location
    London, UK
    Posts
    3,317
    Rep Power
    111
    mysql> create database dbname;
    Query OK, 1 row affected (0.00 sec)

    mysql> use dbname;
    Database changed
    mysql> create table feedback(
    -> fe_id int auto_increment,
    -> fe_country text,
    -> fe_product text,
    -> fe_model varchar(10),
    -> primary key (fe_id));
    Query OK, 0 rows affected (0.47 sec)

    you would then have separate tables for your products and models - each with their own PK's, but models would join to products with a mo_prid field.

    christo
    Last edited by christo; January 6th, 2003 at 05:18 AM.
    This is me: http://chris.uk.com
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    2
    Rep Power
    0

    Smile


    Thank you for your help Christo. It made things much easier.

IMN logo majestic logo threadwatch logo seochat tools logo