Entity Relationship Modeling: Master ER Diagrams and Database Schemas

Question 1

In Entity Relationship Modeling, which model depicts real-world entities and their connections?

Accepted Answer

Conceptual ER Model

Answer

Logical ER Model

Answer

Physical ER Model

Question 2

Which scenario presents the greatest difficulty for successful Entity Relationship Modeling (ERM)?

Accepted Answer

Modeling a system with highly dynamic data that changes frequently

Answer

Modeling a system with numerous entities and relationships

Answer

Modeling a system with a large volume of data

Answer

Modeling a system with multiple users with varying access requirements

Question 3

Which of the following is NOT a component of an Entity Relationship Diagram (ERD)?

Accepted Answer

Tables (Not a component of an ERD)

Answer

Entities

Answer

Relationships

Answer

Attributes

Question 4

Which type of relationship indicates that a single instance of Entity A can be associated with multiple instances of Entity B?

Accepted Answer

One-to-many

Answer

One-to-one

Answer

Many-to-one

Answer

Many-to-many

Question 5

What is the cardinality constraint that specifies that an entity instance can have zero or one occurrences of another entity instance?

Accepted Answer

Zero or one

Answer

One or more

Answer

Zero or more (incorrect)

Answer

One or one

Question 6

Which of the following is a primary key?

Accepted Answer

A unique identifier that defines an entity instance

Answer

A foreign key that links one entity to another (incorrect)

Answer

An optional attribute that provides additional information about an entity (incorrect)

Answer

A composite key that consists of multiple attributes (incorrect)

Question 7

What is the process of converting an ERD into a database schema called?

Accepted Answer

Mapping

Answer

Normalization (incorrect)

Answer

Transformation

Answer

Denormalization (incorrect)

Question 8

Which of the following is NOT a benefit of using ERDs?

Accepted Answer

Automatic generation of database code (ERDs do not generate code)

Answer

Improved data modeling accuracy

Answer

Enhanced communication between stakeholders

Answer

Reduced development costs

Question 9

What is the purpose of the attribute symbol in an ERD?

Accepted Answer

To represent an attribute of an entity

Answer

To represent an entity (incorrect)

Answer

To represent a relationship (incorrect)

Answer

To represent a data type (incorrect)

Question 10

What is a weak entity?

Accepted Answer

An entity that cannot exist independently of another entity

Answer

An entity that has a primary key that is not unique (incorrect)

Answer

An entity that has a foreign key relationship to another entity (incorrect)

Answer

An entity that has no attributes (incorrect)

Question 11

In ER Modeling, what is a primary advantage of normalizing data?

Accepted Answer

Reduced data redundancy and enhanced data integrity

Answer

Improved data security

Answer

Faster data retrieval

Answer

Reduced data consistency

Question 12

Which of the following is the primary objective of Entity Relationship Modeling (ERM)?

Accepted Answer

To create a visual representation of data relationships and constraints

Answer

To directly convert data requirements into a physical database schema

Answer

To solely ensure data integrity and consistency

Answer

To primarily optimize database performance

Question 13

What is the standard symbol used to represent an entity in an ER diagram?

Accepted Answer

Rectangle

Answer

Diamond

Answer

Ellipse

Answer

Triangle

Question 14

What is the main purpose of cardinality in ER modeling?

Accepted Answer

To specify the minimum and maximum occurrences between entities

Answer

To automatically enforce referential integrity constraints

Answer

To minimize database storage space usage

Answer

To enhance data access efficiency

Question 15

What is the primary purpose of a primary key in an ER model?

Accepted Answer

To uniquely identify each instance of an entity

Answer

To maintain referential integrity across different tables

Answer

To improve data storage efficiency

Answer

To optimize query performance

Question 16

Which of the following is NOT generally considered a benefit of using ER modeling?

Accepted Answer

Guaranteed increase in database performance

Answer

Enhanced communication and understanding among stakeholders

Answer

Improved data consistency and integrity

Answer

Potentially reduced development time and cost

Question 17

What are the main goals of data normalization in Entity Relationship Modeling?

Accepted Answer

Eliminate redundancy, ensure consistency, and enhance accessibility

Answer

Improve security, simplify structures, and enhance storage efficiency

Answer

Enhance performance, reduce integrity violations, and improve quality

Question 18

Which of the following is NOT a fundamental component of an Entity Relationship Diagram (ERD)?

Accepted Answer

Logical table

Answer

Entity

Answer

Attribute

Answer

Relationship

Question 19

An attribute that uniquely identifies an entity within an ERD is referred to as a:

Accepted Answer

Primary key

Answer

Foreign key

Answer

Composite key

Question 20

The process of converting an ERD into a database schema primarily involves:

Accepted Answer

Identifying tables and columns based on entities and attributes

Answer

Adding constraints and indexes to the database

Answer

Normalizing the data into multiple tables

Question 21

Cardinality constraints in an ERD are primarily used to:

Accepted Answer

Define the minimum and maximum number of instances that can be associated

Answer

Ensure the referential integrity between tables

Answer

Prevent data redundancy

Question 22

An ERD that represents a conceptual view of the data, independent of any specific database management system, is known as a:

Accepted Answer

Logical ERD

Answer

Physical ERD

Answer

Implementation ERD

Question 23

Which of the following symbols is commonly used to represent a weak entity in an ERD?

Accepted Answer

Double line rectangle

Answer

Single line rectangle

Answer

Triangle

Question 24

One of the key benefits of using ERDs is:

Accepted Answer

Facilitating communication between stakeholders involved in database design

Answer

Enhancing data security

Answer

Reducing maintenance costs

Question 25

When mapping an ERD to a database schema, entities are typically mapped to:

Accepted Answer

Tables

Answer

Indexes

Answer

Columns