Single Valued attribute:
Attributes that can have single value at a particular instance of time are called single valued. A person can’t have more than one age value. Therefore, age of a person is a single-values attribute.
Multi valued attributes:
A multi-valued attribute can have more than one value at one time. For example, degree of a person is a multi-valued attribute since a person can have more than one degree. Where appropriate, upper and lower bounds may be placed on the number of values in a multi-valued attribute For example, a bank may limit the number of addresses recorded for a single customer to two. Such attributes are represented by double ovals in ER diagram.
can u tell me about compound attribute
ReplyDeletethanks,
ReplyDeletethanks,
ReplyDeletethanks keling
ReplyDeleteyour seeking the help of the keling
DeleteThis comment has been removed by the author.
ReplyDeleteThanks
ReplyDeleteWe never store age in the table. Usually age is a derived attribute.
ReplyDeleteNyc
ReplyDelete