Entity Relationship MCQs ER Diagram

By: Prof. Dr. Fazal Rehman | Last updated: April 16, 2025

1. In an E-R, B is the dominant entity and A is a subordinate entity. Select which one is incorrect?
(A) An A existence is dependent on B
(B) Operationally, if A is deleted, B remains the same
(C) Operationally, if A is deleted, so is B
(D) Operationally, If B is deleted, so is A

2. The number of entities to which another entity can be related through a relationship set is called?
(A) Cardinality
(B) Entity
(C) Schema
(D) Attributes

3. The Relations brought from an E-R model will usually be in:
(A) Third normal form
(B) Second normal form
(C) First normal form
(D) Fourth normal form

4. Select the attributes which are made up of more than one single attribute.
(A) Multi-value attribute
(B) Derived attribute
(C) Single value attribute
(D) Composite attribute

5. An association of various entities in an Entity-Relation model is known as:
(A) Relationship
(B) Record
(C) Tuple
(D) Field

6. If two entities have many-to-many relationships, it mostly results in how many tables?
(A) Three
(B) Two
(C) One
(D) Four

7. Which is a set of entities of the same type that share the same properties, or attributes?
(A) Relation set
(B) Attribute set
(C) Entity set
(D) Entity model

8. Select about the Entity:
(A) The thing in the real world
(B) Present working model
(C) Object of relation
(D) Model of relation

9. How can every weak entity set be changed into a strong entity set?
(A) Using generalization
(B) Using aggregation
(C) Adding appropriate attributes
(D) None of the above

10. Select the E-R modeling technique that is a _____________?
(A) Left-right approach
(B) Bottom-up approach
(C) Top-down approach
(D) None of the above

11. This process of hiding the details of entities in the ER model is known as?
(A) Generalization
(B) Abstraction
(C) Specialization
(D) None of these above

12. The attribute AGE is?
(A) Single valued
(B) Derived
(C) Composite
(D) Multi-valued

13. Select from the following the multi-valued attribute.
(A) Date_of_birth
(B) Name
(C) Phone_number
(D) All of the mentioned

14. Which one is a single-valued attribute?
(A) Reference
(B) Address
(C) SUBJECT_TAKEN
(D) Register_number

15. The primary key in a many-to-one relationship acts as a foreign key on which side?
(A) On the side where many relationships are defined
(B) On the side where a single (one) relationship is defined
(C) On both the sides
(D) Neither of them

16. Select about weak entity set in an E-R diagram.
(A) Has a primary key
(B) Is not existence dependent on a dominant entity
(C) Must be part of a one-to-many relationship set
(D) Must not participate as an owner in an identifying relationship with another entity set