complex Attribute is a type of attribute in database. It is formed by nesting composite attributes and multi-valued attributes in arbitrary way. Can say this as the both are in the attribute.
- For example, A person can have many phone numbers,many e-mail addresses,home addresses etc.So if there is a attribute in the name of 'Contact detail',it can be a complex attribute.
“A required attribute is an attribute that must have a value in it, while an optional attribute...E/R Model: Type of Attributes