What is a multivalue attribute relating to database?

Answer:

A multivalue attribute is the practice of maintaining more than a single value in a database column.

Lets say for example you want to know the hobbies for a client. The proper way to handle this is to maintain the data in a one - to - many child table.

Another way is a multivalue field. This in effect is a text field (varchar, etc) that will contain one or more values, separated by a comma (as an example).


This of course is NOT the way to go and will cause performance problems in parsing the information and make many reports and logical use of the data very difficult (but possible).

First answer by Jwilliamsoh. Last edit by Jwilliamsoh. Contributor trust: 58 [recommend contributor recommended]. Question popularity: 2 [recommend question].