Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Beginner - Hear about us section

    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

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    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".

  3. #3
    Join Date
    Jan 2010
    Posts
    2

    display them on a form (in sections Hear about us, Ethnic Origin)

    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
    Last edited by sureshid4dbdesign; 01-08-10 at 08:27.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Quote Originally Posted by sureshid4dbdesign View Post
    I want to display them on a form (check boxes) so that a user can select.

    like i said in the last post.
    No, you didn't mention forms or checkboxes at all in the last post!

    So, you have decided to go for a OTLT anyway. Fair enough.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •