A multivalued attribute is an attribute whose value is a set of values.
Oracle supports multivalued attributes with the NESTED TABLE and VARRAY datatypes. However, a pure relational design cannot have multivalued attributes. When normalizing, multivalued attributes must be split into separate entities with 1:N relationships between them.
|Glossary of Terms|