Entity Relationship Diagram Quiz

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS (Computer Science) |
Database Administrator
Review Board Member
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.
, MS (Computer Science)
Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Saurabhg
S
Saurabhg
Community Contributor
Quizzes Created: 1 | Total Attempts: 13,194
Questions: 22 | Attempts: 13,206

SettingsSettingsSettings
Entity Relationship Diagram Quiz - Quiz


Hey, are you aware of the entity-relationship model (ER)? Try this interesting 'ER diagram' quiz and see how much you can score on this test. This model is used to describe interrelated things of interest in a specific domain of knowledge. If you think you have a good understanding of this topic, then this quiz will be very useful in testing your knowledge. So, get ready and start answering. Good luck to you!


Entity Relationship Diagram Questions and Answers

  • 1. 

    ER was developed by Chen in 1980. True or false? 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The Entity-Relationship (ER) model, a conceptual modeling technique used in software engineering and database design, was indeed developed by Peter Chen in 1976, not 1980. This model provides a graphical representation of entities, their attributes, and the relationships between them. It serves as a foundation for understanding the structure of data within a system. Therefore, the statement claiming its development in 1980 is inaccurate; it was developed earlier, in 1976, by Peter Chen.

    Rate this question:

  • 2. 

    ER aims to:

    • A.

      Facilitate database programming

    • B.

      Facilitate database organization

    • C.

      Facilitate database design

    • D.

      Facilitate database website

    Correct Answer
    C. Facilitate database design
    Explanation
    ER (Entity-Relationship) aims to facilitate database design. ER is a conceptual data modeling technique that helps in designing the structure and organization of a database system. It allows the identification of entities, their attributes, and the relationships between them. By using ER diagrams, database designers can visually represent the entities and their relationships, which aids in understanding and designing the database schema. ER helps in creating a blueprint for the database, making it easier to translate the design into an actual database implementation.

    Rate this question:

  • 3. 

    The Conceptual data model is the set of concepts that:

    • A.

      Describe the structure of a database and the associated insert and update transactions

    • B.

      Describe the structure of a database and the associated retrieval and update transactions

    • C.

      Describe the structure of a database and the associated retrieval transactions

    • D.

      None of the above

    Correct Answer
    B. Describe the structure of a database and the associated retrieval and update transactions
    Explanation
    The conceptual data model is a representation of the overall structure of a database, including its entities, attributes, and relationships. It provides a high-level view of the database and is independent of any specific database management system. The model describes not only the structure of the database but also the transactions that involve retrieving and updating data. Therefore, the correct answer is "describe the structure of a database and the associated retrieval and update transactions."

    Rate this question:

  • 4. 

    An ERs purpose is to support a user's perception of the data and conceal the technical aspects associated with database design. True or false? 

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because an Entity-Relationship (ER) diagram is a visual representation of a database that focuses on the relationships between entities, rather than the technical aspects of the database design. It helps users understand and perceive the data by using simple and intuitive symbols to represent entities, attributes, and relationships. This abstraction of technical details allows users to focus on the conceptual understanding of the data rather than getting bogged down by the technical complexities of the database design.

    Rate this question:

  • 5. 

    A high-level conceptual model is dependent on the DBMS and HW platform used to implement the database. True or false? 

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    A high-level conceptual model is independent of the particular DBMS and HW platform used to implement the database.

    Rate this question:

  • 6. 

    The basic concepts of the Entity-Relationship model include: (select all that applies) 

    • A.

      Entity types

    • B.

      File types

    • C.

      Relationship types

    • D.

      Attributes

    • E.

      Storage details

    Correct Answer(s)
    A. Entity types
    C. Relationship types
    D. Attributes
    Explanation
    Entity types represent real-world objects or concepts that have a distinct existence in the database.
    Relationship types describe how entities are related to one another.
    Attributes are the properties or characteristics of an entity type.
    File types and storage details are not fundamental concepts of the ER model; they are related more to the physical implementation of a database rather than its conceptual design.

    Rate this question:

  • 7. 

    Entity type = An object or concept identified by the enterprise as having an ______________ existence.

    Correct Answer(s)
    independent
    Explanation
    The Basic concept of the ER model is an Entity type, which represents a set of 'objects' in the 'real world' with the same properties. An Entity type has an independent existence and can be an object with a physical (or 'real existence') or an object with a conceptual (or 'abstract') existence

    Rate this question:

  • 8. 

    A Entity is

    • A.

      An instance of an Entity type that is uniquely identifiable

    • B.

      An instance of a DBA type that is uniquely identifiable

    • C.

      An instance of a type that is uniquely identifiable

    • D.

      None of the above

    Correct Answer
    A. An instance of an Entity type that is uniquely identifiable
    Explanation
    Each uniquely identifiable instance of an Entity is referred to simply as an entity. Other authors may refer to an entity as an entity occurence or entity instance.

    Rate this question:

  • 9. 

    Weak entity type:

    • A.

      An entity that is not existence-dependent on some other entity type

    • B.

      An Entity that characterizes a DBMS

    • C.

      An instance that is existence-dependent on some other entity type

    • D.

      None of the above

    Correct Answer
    C. An instance that is existence-dependent on some other entity type
    Explanation
    A weak entity type is an instance that is existence dependent on some other entity type. This means that a weak entity cannot exist without a corresponding strong entity. It relies on the strong entity for its existence and cannot be uniquely identified without considering the strong entity it is associated with.

    Rate this question:

  • 10. 

    Strong entity type:

    • A.

      An entity that is not existance-dependent on some other entity type

    • B.

      An Entity that characterizes a DBMS

    • C.

      An instance that is existance-dependent on some other entity type

    • D.

      All of the above

    Correct Answer
    A. An entity that is not existance-dependent on some other entity type
    Explanation
    A strong entity type is an entity that does not depend on any other entity type for its existence. In other words, it can exist independently and has its own unique attributes. This is in contrast to a weak entity type, which relies on a strong entity type for its existence. Therefore, the correct answer is "an entity that is not existence-dependent on some other entity type."

    Rate this question:

  • 11. 

    An Attribute is a property of an entity or a relationship type. True or false? 

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    An attribute is indeed a property of an entity or a relationship type. In a database, entities represent real-world objects or concepts, and attributes describe the characteristics or properties of those entities. Similarly, relationship types define the associations between entities, and attributes can also be associated with these relationships. Therefore, it is correct to say that an attribute is a property of an entity or a relationship type.

    Rate this question:

  • 12. 

    An Attribute:

    • A.

      A set of values that might be assigned to an attribute. 

    • B.

      Is a property of an entity or a relationship type

    • C.

      A set of numbers and values 

    • D.

      None of the above 

    Correct Answer
    B. Is a property of an entity or a relationship type
    Explanation
    An attribute is a property of an entity or a relationship type. In a database, entities represent real-world objects or concepts, and relationships represent the associations between these entities. Attributes describe the characteristics or properties of these entities or relationships. They can be used to store information such as names, ages, addresses, or any other relevant data. By defining attributes, we can define the structure and properties of the entities and relationships in a database, allowing us to organize and manage data effectively.

    Rate this question:

  • 13. 

    An Attribute domain:

    • A.

      A set of values that might be assigned to an attribute

    • B.

      Is a property of an entity or a relationship type

    • C.

      Is a set of numeric and database values

    • D.

      None of the above

    Correct Answer
    A. A set of values that might be assigned to an attribute
    Explanation
    An attribute domain refers to a set of values that can be assigned to an attribute. This means that when defining an attribute for an entity or relationship type, the attribute domain determines the range of values that can be assigned to that attribute. It helps to maintain data integrity and consistency by restricting the possible values that can be stored in the attribute.

    Rate this question:

  • 14. 

    Simple attribute:

    • A.

      An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity

    • B.

      An attribute that holds multiple values for a single component

    • C.

      An attribute that cannot be further divided into sub-attributes

    • D.

      An attribute composed of multiple components, each with individual existence

    Correct Answer
    C. An attribute that cannot be further divided into sub-attributes
    Explanation
    The correct definition of a simple attribute is: “An attribute that holds a single value for a single entity.” In the context of a database, a simple attribute is one that cannot be divided into subparts and holds only a single value for a particular entity. It’s the most basic form of attribute in an entity-relationship model.

    Rate this question:

  • 15. 

    Composite attribute:

    • A.

      An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity

    • B.

      An attribute that holds multiple values for a single component

    • C.

      An attribute that holds a single value for a single entity

    • D.

      An attribute composed of multiple components, each with individual existence

    • E.

      An attribute composed of a single component with an independent existence

    Correct Answer
    D. An attribute composed of multiple components, each with individual existence
    Explanation
    The address attribute of the branch entity can be subdivided into street city numbers.....

    Rate this question:

  • 16. 

    Single valued attribute:

    • A.

      An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity

    • B.

      An attribute that holds multiple values for a single component

    • C.

      An attribute that holds a single value for a single entity

    • D.

      An attribute composed of multiple components, each with individual existence

    • E.

      An attribute composed of a single component with an independent existence

    Correct Answer
    C. An attribute that holds a single value for a single entity
    Explanation
    The majority of attributes are single-valued for a particular entity.

    Rate this question:

  • 17. 

    Multi-valued attribute:

    • A.

      An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity

    • B.

      An attribute that holds multiple values for a single component

    • C.

      An attribute that holds a single value for a single entity

    • D.

      An attribute composed of multiple components, each with individual existence

    • E.

      An attribute composed of a single component with an independent existence

    Correct Answer
    B. An attribute that holds multiple values for a single component
    Explanation
    For example, the branch entity may have multiple values for the entity telephone

    Rate this question:

  • 18. 

    Derived attribute

    • A.

      An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity

    • B.

      An attribute that holds multiple values for a single component

    • C.

      An attribute that holds a single value for a single entity

    • D.

      An attribute composed of multiple components, each with individual existence

    • E.

      An attribute composed of a single component with an independent existence

    Correct Answer
    A. An attribute that represents a value that is derivable from a related attribute or set of attributes, not necessarily in the same entity
    Explanation
    Some attributes may be related to a particular entity. ex: the age of a member of staff is derivable from the age of birth.

    Rate this question:

  • 19. 

    A Candidate key is an attribute or set of attributes that uniquely identifies individual occurrences of an entity type.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A candidate key is one or more attributes whose value uniquely identifies each entity.

    Rate this question:

  • 20. 

    The Primary key:

    • A.

      Uniquely identifies each occurrence of an entity type

    • B.

      Is equivalent to a composite key

    • C.

      Is the candidate key selected to be a primary key

    • D.

      All of the above

    Correct Answer(s)
    A. Uniquely identifies each occurrence of an entity type
    C. Is the candidate key selected to be a primary key
    Explanation
    An entity type may have more than one candidate key. The choice of a primary key for an entity is based on considerations of attribute length the minimal number of attributes required.

    Rate this question:

  • 21. 

    A Composite key is a candidate key that consists of two or more attributes. State true or false. 

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A composite key is a candidate key with two or more attributes. In a database, a candidate key is a unique identifier for a record, and a composite key is formed by combining multiple attributes to create a unique identifier. This helps ensure that each record in a table is uniquely identified, even when individual attributes may not be unique on their own. Therefore, the given statement is true.

    Rate this question:

  • 22. 

    Degree of a relationship.

    • A.

      Is always 1

    • B.

      The number of participating entities in a relationship

    • C.

      The number of representations in a relationship

    • D.

      Is always 0

    • E.

      Is always 0

    Correct Answer
    B. The number of participating entities in a relationship
    Explanation
    The degree of a relationship refers to the number of participating entities in that relationship. It indicates how many entities are involved in the relationship. For example, if a relationship involves two entities, the degree of that relationship would be 2. The given answer correctly states that the degree of a relationship is determined by the number of participating entities.

    Rate this question:

Godwin Iheuwa |MS (Computer Science) |
Database Administrator
Godwin Iheuwa, a Database Administrator at MTN Nigeria, holds an MS in Computer Science, specializing in Agile Methodologies and Database Administration from the University of Bedfordshire and a Bachelor's in Computer Science from the University of Port Harcourt. His proficiency in SQL Server Integration Services (SSIS) and SQL Server Management Studio contributes to his expertise in database management.

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 02, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Godwin Iheuwa
  • Feb 26, 2014
    Quiz Created by
    Saurabhg

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.