E R Diagram

Properties that describe the characteristics of entities are called:

• entities

• attributes

• identifiers

• relationships

Entities of a given type are grouped into a/an:

• Database

• Entity class

• Attribute

• ERD

Which of the following is NOT a basic element of all versions of the ER model?

• entities

• attributes

• relationships

• primary key

Entities can be associated with one another in which of the following?

• entities

• attributes

• identifiers

• relationships

The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called :

• Simple attribute

• Composite attribute

• Multi-valued attribute

• Derived attribute

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is:

• Single valued

• Multi valued

• Composite

• Derived

Which of the following can be a multi-valued attribute?

• Phone_number

• Name

• Date_of_birth

• All of these

An ER diagram that shows the concepts of Specialization & Generalization are known as:

• Extended E-R diagram

• Effective E-R diagram

• Expanded E-R diagram

• Enhanced E-R diagram

The process of minimizing the differences between entities by identifying their common characteristics is known as:

• Specialization

• Generalization

• Multiplicity

• Normalization

The complement of Generalization is:

• Specialization

• Relation

• Distribution

• Normalization