What do you understand by multi-valued attribute? How is it different from
complex and composite attribute? Illustrate by giving suitable example.
Answers
A multi-valued attribute refers to the attribute that has an entity's multiple values. Yes, it is different from both complex and composite attribute.
Explanation:
-A multi-valued attribute refers to the attribute that has an entity's multiple values.
For example, an attribute can be salary and qualification.
-This attribute is different from complex attribute because a complex attribute is constituted by both composite and multi-valued attribute.
For example, the complex attribute is represented with the help of parenthesis.
-A multi-valued attribute is different from composite attribute because a composite attribute can be distributed into shorter sub parts.
For example, a name can be distributed into short parts such as first name, middle and last name
Defining Multivalued attribute and How is it different from complex and composite attribute with example
- A multivalued attribute of an entity is a characteristic that can have more than one worth related to the key of the element. For instance, an enormous organization could have numerous divisions, some of them conceivably in various urban communities
- Composite attributes can be segregated into different parts.
Example: Employee Name can be partitioned into sub divisions like FName, MName, LName.
- Complex Attributes: When an attribute is consist of two attributes i.e. composite and multivalued attributes then its stated as complex attributes.
Example: A human can have more than one address and each address can have more than one telephone connections.
Please refer attached Diagrams for better understandings.
To know more
Compare between single value attribute and multivalued attribute
https://brainly.in/question/8567246
Draw the notation for multivalued and derived attribute
https://brainly.in/question/11885974
