Entity-Relationship Diagrams MCQ

Test your knowledge with important Entity-Relationship Diagrams MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Entity-Relationship Diagrams MCQs at Bissoy

• What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
  ক

  Relation

  খ

  Instance

  গ

  Table

  ঘ

  Column
• If you were collecting and storing information about your music collection, an album would be considered a(n) _____
  ক

  Relation

  খ

  Entity

  গ

  Instance

  ঘ

  Attribute
• Weak entity set is represented as
  ক

  Underline

  খ

  Double line

  গ

  Double diamond

  ঘ

  Double rectangle
• For a weak entity set to be meaningful, it must be associated with another entity set, called the
  ক

  Identifying set

  খ

  Owner set

  গ

  Neighbour set

  ঘ

  Strong entity set
• An entity set that does not have sufficient attributes to form a primary key is termed a __________
  ক

  Strong entity set

  খ

  Variant set

  গ

  Weak entity set

  ঘ

  Variable set
• We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________
  ক

  Diamond , diamond

  খ

  Rectangle, diamond

  গ

  Rectangle, rectangle

  ঘ

  Diamond, rectangle
• Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
  ক

  One to many

  খ

  One to one

  গ

  Many to many

  ঘ

  Many to one
• The Rectangles divided into two parts represents
  ক

  Entity set

  খ

  Relationship set

  গ

  Attributes of a relationship set

  ঘ

  Primary key
• The entity relationship set is represented in E-R diagram as
  ক

  Double diamonds

  খ

  Undivided rectangles

  গ

  Dashed lines

  ঘ

  Diamond
• Which of the following gives a logical structure of the database graphically?
  ক

  Entity-relationship diagram

  খ

  Entity diagram

  গ

  Database diagram

  ঘ

  Architectural representation