Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
Multiple values in lookup fields

i have a table has about 27 fields are just strings and every one of them have multiple values for example itemType Field have more than 10 possible values and the user may insert more

i made a tables called properties with those fields (Id, Key, Value) to store those values but now i'm confused wither i should use just the (Id)s and reference them in the original table (i think it's no good to put 27 relationships) or doing something else which i don't know what is it exactly

any better ideas or is it ok to continue like this


share|improve this question

marked as duplicate by gbn, Mark Storey-Smith, JNK Jun 3 '12 at 11:29

This question was marked as an exact duplicate of an existing question.

Do you mean that each of the 27 fields can contain multiple strings at the same time or do you mean that they each can contain one value that can be any of ten possible values? – Leigh Riffel Jan 6 '12 at 14:24
Also, does each field have it's own set of possible values or do all 27 fields draw from the same 10 possible values? – Leigh Riffel Jan 6 '12 at 14:25
@Leigh Riffel yes as you said each one can contain one value that can be any of ten possible values and each field have it's own set of possible values – Alaa Jabre Jan 6 '12 at 15:47
up vote 0 down vote accepted

To answer this question best we would need to a whole lot more specifics about what you are doing and what the kinds of value are going into each of the fields.

In general though since more values can be added to each set of possible values, a seperate table is advisable. Unless the fields have overlap in their possible values it would be better to have each set of possible values as a seperate table. In Oracle these could be Index Organized Tables.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.