Question

Composite attributes. 2. Multivalued attributes. 3. Nested relations; where tuple values are non-atomic. Therefore,

Each cell has to be single valued.
Column entries must be the same data types.
Rows are uniquely identified; add a unique ID or more columns to make them unique.
Options:
A. Compound, Scalar, Embedded
B. Combined, Plural, Nested
C. Unified, Varied, Segregated
D. Linked, Multiple, Nested

Answer 1

The given question is about database design, discussing composite, multivalued, and nested attributes. The matching terms for these are Linked (composite attributes), Multiple (multivalued attributes), and Nested (nested relations), which corresponds to option D.

Step-by-step explanation:

The question pertains to database design concepts in the context of data modeling. Specifically, it's asking to match descriptions of database attributes and structures with their correct terminologies. Based on the descriptions given:

1. Composite attributes are attributes that have sub-attributes.
2. Multivalued attributes are attributes that can have multiple values for a single entity.
3. Nested relations are tables within tables where tuple values are non-atomic.

The correct option from the provided list that matches these concepts is D. Linked, Multiple, Nested. When you design a database:

• Each cell must be single valued, ensuring scalar values.
• Column entries should be of the same data type.
• Rows must be uniquely identified, which can be achieved by adding a unique ID or using more columns to ensure uniqueness.

Option D aligns with the descriptions, where 'Linked' is similar to composite attributes (attributes that are linked together), 'Multiple' corresponds to multivalued attributes, and 'Nested' refers to nested relations.