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

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

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