Entity Relationship Diagram 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. FalseExplanation
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 designExplanation
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 transactionsExplanation
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. TrueExplanation
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. FalseExplanation
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. AttributesExplanation
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)
independentExplanation
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') existenceRate 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 identifiableExplanation
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 typeExplanation
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 typeExplanation
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. TrueExplanation
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 typeExplanation
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 attributeExplanation
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-attributesExplanation
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 existenceExplanation
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 entityExplanation
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 componentExplanation
For example, the branch entity may have multiple values for the entity telephoneRate 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 entityExplanation
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. TrueExplanation
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 keyExplanation
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. TrueExplanation
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 relationshipExplanation
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:
-
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, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Feb 26, 2014Quiz Created by
Saurabhg
Back to top