January 5th, 2003, 04:56 AM
Database Design Help
I am trying to design a database and I am stuck. My database will store customer feedbacks /complaints where customers will
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:
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.
January 5th, 2003, 12:30 PM
mysql> create database dbname;
Query OK, 1 row affected (0.00 sec)
mysql> use dbname;
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.
Last edited by christo; January 6th, 2003 at 04:18 AM.
This is me: http://chris.uk.com
January 7th, 2003, 12:18 AM
Thank you for your help Christo. It made things much easier.