DBMS E-R Diagram Quiz 2

A recursive relationship is a relationship between an entity and ___________.

• itself

• a subtype entity

• an archetype entity

• an instance entity

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 function that an entity plays in a relationship is called that entity’s _________.

• Participation

• Position

• Role

• Instance

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

In a relation between the entities the type and condition of the relation should be specified. That is called as ______ attribute.

• Descriptive

• Derived

• Recursive

• Relative