Database Multiple Choice Questions 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
Answer: a
Clarification: An entity is a “thing” or “object” in the real world that is distinguishable from all other objects.
2. Entity is a _________
a) Object of relation
b) Present working model
c) Thing in real world
d) Model of relation
Answer: c
Clarification: For example, each person in a university is an entity.
3. The descriptive property possessed by each entity set is _________
a) Entity
b) Attribute
c) Relation
d) Model
Answer: b
Clarification: Possible attributes of the instructor entity set are ID, name, dept name, and salary.
4. The function that an entity plays in a relationship is called that entity’s _____________
a) Participation
b) Position
c) Role
d) Instance
Answer: c
Clarification: A relationship is an association among several entities.
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
Answer: b
Clarification: Composite attributes can be divided into subparts (that is, other attributes).
6. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
a) Single valued
b) Multi valued
c) Composite
d) Derived
Answer: d
Clarification: The value for this type of attribute can be derived from the values of other related attributes or entities.
7. Not applicable condition can be represented in relation entry as
a) NA
b) 0
c) NULL
d) Blank Space
Answer: c
Clarification: NULL always represents that the value is not present.
8. Which of the following can be a multivalued attribute?
a) Phone_number
b) Name
c) Date_of_birth
d) All of the mentioned
Answer: a
Clarification: Name and Date_of_birth cannot hold more than 1 value.
9. Which of the following is a single valued attribute
a) Register_number
b) Address
c) SUBJECT_TAKEN
d) Reference
Answer: a
Clarification: None.
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
Answer: a
Clarification: Consider the entity sets student and section, which participate in a relationship set takes. We may wish to store a descriptive attribute grade with the relationship to record the grade that a student got in the class.