DBMS-Entity Relationship (E-R) Model Questions and Answers

Take Exam

The Entity Relationship (E-R) Model is a key database design concept in DBMS that represents real-world data relationships. These programming interview questions with answers help you master how entities, attributes, and relationships interact within a database schema. Understanding E-R diagrams is essential for database normalization, query design, and relational mapping — skills highly valued in Infosys, TCS, Capgemini, and Wipro technical interviews. Practicing DBMS E-R Model questions with answers ensures conceptual clarity and improves your ability to design and interpret data models. Start now to enhance your database fundamentals and succeed in both academic and placement-level assessments.

DBMS-Entity Relationship (E-R) Model

Showing 10 of 38 questions

31. Which data model is independent of both hardware and DBMS?

  • External
  • Internal
  • conceptual
  • all of these
Show Answer Report

32. A relatonship between the instances of a single entity type is called.

  • binary relationship
  • ternary relationship
  • recursive relationship
  • none of these
Show Answer Report

33. A simple attribute is composed of :

  • single component with an independent existence.
  • multiple components, each with an independent existence.
  • both (a) and (b)
  • none of these
Show Answer Report

34. A composite attribute is composed of:

  • single component with an independent existence.
  • multiple components, each with an independent existence
  • both (a) and (b)
  • none of these
Show Answer Report

35. What are the components of E-R model?

  • entity
  • attribute
  • relationship
  • all of these.
Show Answer Report

36. The attribute composed of a single component with an independent existence is called:

  • composite attribute
  • atomic attribute
  • single-valued attribute
  • derived attribute
Show Answer Report

37. The attribute composed of multiple components, each with an independent existence is called.

  • composite attribute
  • simple attribute
  • single-valued attribute
  • derived attribute
Show Answer Report

38. Which of these express the specific number of entity occurrences associated withone occurrence of the related entity ?

  • degree of relationship.
  • connectivity of relationship
  • cardinality of relationship
  • none of these.
Show Answer Report
Questions and Answers for Competitive Exams Various Entrance Test