ER model quiz

In one to many relationship, the entity that is on the one side of relationship is called

• subtype

• child

• instance

• parent

Property that describes the characteristics of entity is

• entities

• relationship

• attributes

• identifiers

One entity may be

• related to only one other entity

• related to itself

• related to only two other entities

• related to many other entities

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 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

Multi-valued attributes are represented by

• dashed ellipse

• doubled ellipse

• doubled rectangle

• ellipse