Ad:

Database Design Discussion Thread
Unsolved
Views: 2481

Jun 29th, 2007

Database Table Design

Expand Post »

Currently i am designing database for Portal.
On Portal screen, There are some fields which are having multiselection facility

e.g

1) professional is one of the field having
1)photographer
2)skydiving
3)painter
4)modeling

are values, User can have more then one profession.

Same type of 30 fields are available on single screen.

So the storage for single such field i have to created new table for multiple values storage.
For that total 30 child table get created for a single screen.

Can any one help me, how do i manage this in minimum tables?

Similar Threads

Help on General Best Practices for Table/Database Design in Database Design
insert data from one form into two diffent database table in JSP
Database table convert to xml document to cache in VB.NET
How can I create database/table images in MySQL in PHP
Send all items in a listBox to SQL server database table in ASP.NET

vijayoracle

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jun 2007

Permalink

Jun 29th, 2007

Re: Database Table Design

All you need is actually just 3 tables:
1) table with the customer information (customerID, name, age, etc)
2)Lookup table for the proffessions (professionId, professionName, etc)
3) table for CustomerProffessions (custommerProffessionId, etc)
Make sure that the CustomerProffessions table has 2 foreign keys: customerID and professionId. That solves your problem nicely, dont you think?

sibir1us

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

30 posts
since Jun 2007

Permalink

Jun 30th, 2007

Re: Database Table Design

Thanks for reply.

I have 30 different filed like "professional" on single screen. How do i manage in three tables?

vijayoracle

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jun 2007

Permalink

Jun 30th, 2007

Re: Database Table Design

Try to understand what "primary-foreign key" relationship is and how to use lookups.

sibir1us

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

30 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: exercise in DIstributed Database Systems

Next Thread in Database Design Forum Timeline: want a search facility

DaniWeb Message

Cancel Changes

User Name
Password