Question

What do you understand by multi-valued attribute? How is it different from complex attribute? Illustrate by giving suitable example.

Answer 1

An attribute with the multiple value for a entity is called multivalued attribute e.g, an attribute names as qualification and salary. On the other hand the composite attribute can be divided into smaller sub parts (like name can be divided into first name, middle name and last name) While complex attribute can be constituted by grouping composite and multivalued attribute. The complex attribute can be represented by using parenthesis () for presenting the grouping constitute.