complex data type is usually a composite of other existing data types.
Complex
data types are those that include record type and collections which are used to
handle data in record format or in an array format.
Complex
type systems and object orientation enable E-R model concepts, like
generalization, identity of entities, multivalued attributes and S
specialization, which are represented directly with simple attributes to the
relational model. No complex translation will required for this task.
The
features allow composite attributes and multivalued attributes of E-R diagrams
to be represented directly.
Type
definitions in programming languages, are not stored in a database, and can be
seen only by programs that include a text file containing the definitions.
Complex
type systems usually support other collection types, such as arrays and
multisets.