wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DBMS E-R Diagram Quiz 2

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

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

a)

itself

b)

a subtype entity

c)

an archetype entity

d)

an instance entity

2.

Properties that describe the characteristics of entities are called:

a)

entities

b)

attributes

c)

identifiers

d)

relationships

3.

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

a)

Database

b)

Entity class

c)

Attribute

d)

ERD

4.

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

a)

entities

b)

attributes

c)

relationships

d)

primary key

5.

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

a)

entities

b)

attributes

c)

identifiers

d)

relationships

6.

The function that an entity plays in a relationship is called that entity’s _________.

a)

Participation

b)

Position

c)

Role

d)

Instance

7.

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

a)

Simple attribute

b)

Composite attribute

c)

Multi-valued attribute

d)

Derived attribute

8.

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

a)

Single valued

b)

Multi valued

c)

Composite

d)

Derived

9.

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

a)

Phone_number

b)

Name

c)

Date_of_birth

d)

All of these

10.

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

a)

Descriptive

b)

Derived

c)

Recursive

d)

Relative

11.

The relationship between a weak entity set is called as the:

a)

Weak relationship

b)

Identifying relationship

c)

Connecting relationship

d)

Associative relationship

12.

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

a)

Extended E-R diagram

b)

Effective E-R diagram

c)

Expanded E-R diagram

d)

Enhanced E-R diagram

13.

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

a)

Specialization

b)

Generalization

c)

Multiplicity

d)

Normalization

14.

The complement of Generalization is:

a)

Specialization

b)

Relation

c)

Distribution

d)

Normalization

15.

The process of compiling information on an object, there by abstracting a higher level object is known as:

a)

Specialization

b)

Generalization

c)

Association

d)

Aggregation

16.

The need of EER diagram arise depending upon the:

a)

Nature of problem

b)

Nature of entities

c)

Preferences of the database designer

d)

All of these

17.

_______ is a bottom up process.

a)

Specialization

b)

Generalization

c)

Association

d)

Aggregation

18.

The minimum and maximum values of connectivity is called the __________ of the relationship.

a)

cardinality

b)

degree

c)

modality

d)

tuple

19.

When each entity in the entity set may not occur in at least one relationship in that relationship set, is called:

a)

Partial Participation

b)

Total Participation

c)

Conditional Participation

d)

Relational Participation

20.

The data stored in database at a particular moment of time is called ________ of database.

a)

Instance

b)

Schema

c)

E-R Diagram

d)

Relation