Beginner - Hear about us section

sureshid4dbdesign · #1 (**permalink**) 01-08-10, 06:24

I am a beginner. I have to design a table Where i can put all my categories like

Hear About Us -- Radio,TV, website

Ethnic Orign -- blck, white....

How to design a table to hold these categories

andrewst · #2 (**permalink**) 01-08-10, 07:22

How about:

Code:

create table media (medium_code varchar2(5) primary key, medium_name varchar(30));
insert into media (medium_code, medium_name) values ('TV', 'Television');
... etc.

create table ethnic_origins (eo_code varchar2(5) primary_key, eo_name varchar2(20));
insert into ethnic_origins (eo_code, eo_name) values ('BLK', 'Black');
... etc.

I wouldn't try to put them all in one table - that would be the dreaded "one true lookup table".

sureshid4dbdesign · #3 (**permalink**) 01-08-10, 08:10

Thanks for the reply,

I want to display them on a form (check boxes) so that a user can select.

like i said in the last post.

categories
cat_id, cat_name, cat_type
1 tv hear_about_us
2 radio hear_about us
3 white ethnic_origin
4 black ethnic_origin

Cant we use like that