NEW
Font size
WorksheetsDBMS E-R Diagram Quiz 2
Total questions: 20
Worksheet time: 10mins
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
The relationship between a weak entity set is called as the:
Weak relationship
Identifying relationship
Connecting relationship
Associative relationship
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
The process of compiling information on an object, there by abstracting a higher level object is known as:
Specialization
Generalization
Association
Aggregation
The need of EER diagram arise depending upon the:
Nature of problem
Nature of entities
Preferences of the database designer
All of these
_______ is a bottom up process.
Specialization
Generalization
Association
Aggregation
The minimum and maximum values of connectivity is called the __________ of the relationship.
cardinality
degree
modality
tuple
When each entity in the entity set may not occur in at least one relationship in that relationship set, is called:
Partial Participation
Total Participation
Conditional Participation
Relational Participation
The data stored in database at a particular moment of time is called ________ of database.
Instance
Schema
E-R Diagram
Relation
