answersLogoWhite

0

What is a multivalue attribute relating to database?

Updated: 11/5/2022
User Avatar

Qpid4lyphe

Lvl 1
15y ago

Best 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).

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a multivalue attribute relating to database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a Composite attribute relating to database?

A composite attribute in a database is an attribute that can be divided into smaller sub-parts, each representing a distinct property. Instead of storing it as a single value, a composite attribute is broken down into its components to improve data organization and accuracy. This approach helps in reducing redundancy and ensures data integrity within the database.


What is the prime attribute in a database?

It is an attribute that does not occur in some candidate key.


What is a group of attribute or field in a database?

record


What is the more common name for attribute?

In a database management system (DBMS), an attribute may describe a component of the database, such as a table or a field, or may be used itself as another term for a field. Commonly we can say that an attribute is a "propety" of a database field or its a characteristic or facet of the data field..


What is a simple attribute in dbms?

database simple attritbute


Define domain with respect to dbms?

In database technology, domain refers to the description of an attribute's allowed values. The physical description is a set of values the attribute can have, and the semantic, or logical, description is the meaning of the attribute.


Information stored in a column of a database is called a?

Data.


How a user of a relational database refers to a field?

A user of a relational database refers to a field as a column in a table. This column represents a specific attribute or data type within the database table. By interacting with fields, users can query, update, and retrieve specific information stored in the database.


Why is a Key important in a database?

a key is important in a database because using of that key only we can identify a unique attribute.


How would you define Entity and Attribute?

Entity is real world thing,person,place,event or object about which store data in database. Attribute are the characteristics of entity is called attribute.


What is the definition and field for a database f?

Collection of inter related data is called table.Collection of tables is called database.Field of database is its attribute.


What is the purpose of relating tables in a database?

to calculate data more effectively