Entity Relationship Model MCQs

This set of Advanced Database Management System Multiple Choice Questions and Answers (MCQs) focuses on “Data Models:Entity Relationship Model”.

1
. An Entity is a________________
  • Relationship model
  • Relational Model
  • Object having same Value
  • Object in the real world distinguishable from all other objects
2
. __________is a set of entities of same type that share the same properties or attributes.
  • Attributes set
  • Relationship Set
  • Entity Set
  • Property set
3
. An entity is represented by set of ___________
  • Attributes
  • Relationship
  • Model
  • None of the above
4
. For each attributes, there is set of permitted values called______
  • Key set
  • Value Set
  • Domain
  • B and C
5
. In a Entity sets Customer and Loan, an Attribute name consisting of first-name ,middle-name, and last-name. An Attribute name is _______
  • Simple Attribute
  • Composite Attribute
  • Single-Valued Attributes
  • Multi-valued Attributes
6
. For example Loan-number attribute for a specific loan entity set is referred to as
  • Simple Attribute
  • Composite Attribute
  • Single Valued Attributes
  • Multi-valued Attributes
7
. Consider an employee entity set with the attribute phone-number, attribute phone-number is a ________
  • Simple Attribute
  • Composite Attribute
  • Single Valued Attributes
  • Multi-valued Attributes
8
. For example, the customer entity set has an attribute loan-taken, which represents how many loans a customer has from the bank, the attribute loan-taken is______
  • Derived Attribute
  • Composite Attribute
  • Single Valued Attributes
  • Multi-valued Attributes
9
. An Attribute takes a ________value when an entity does not have a value for it.
  • Zero
  • 0
  • Null
  • Not Applicable
10
. A______is a set of relationships of the same type among several entities
  • Key set
  • Value Set
  • Domain
  • Relationship
11
. The Relationship sets that involve two entity sets in known as___
  • Unary Relationship set
  • Binary Relationship set
  • Ternary Relationship set
  • None of the above
12
. The number of Entity sets that participate in a relationship set is know as ____________ of Relationship
  • Cardinality Ratio
  • Mapping Cardinality
  • Degree
  • Participate