Database Questions and Answers – The Entity-Relationship Model

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “The Entity-Relationship Model”.

1. An ________ is a set of entities of the same type that share the same properties, or attributes.
a) Entity set
b) Attribute set
c) Relation set
d) Entity model
View Answer

2. Entity is a _________
a) Object of relation
b) Present working model
c) Thing in real world
d) Model of relation
View Answer

3. The descriptive property possessed by each entity set is _________
a) Entity
b) Attribute
c) Relation
d) Model
View Answer

4. The function that an entity plays in a relationship is called that entity’s _____________
a) Participation
b) Position
c) Role
d) Instance
View Answer

5. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
a) Simple attribute
b) Composite attribute
c) Multivalued attribute
d) Derived attribute
View Answer

6. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
a) Single valued
b) Multi valued
c) Composite
d) Derived
View Answer

7. Not applicable condition can be represented in relation entry as
a) NA
b) 0
c) NULL
d) Blank Space
View Answer

8. Which of the following can be a multivalued attribute?
a) Phone_number
b) Name
c) Date_of_birth
d) All of the mentioned
View Answer

9. Which of the following is a single valued attribute
a) Register_number
b) Address
c) SUBJECT_TAKEN
d) Reference
View Answer

10. In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
a) Desciptive
b) Derived
c) Recursive
d) Relative
View Answer

Sanfoundry Global Education & Learning Series – Database Management System.

The Entity-Relationship Model

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]