Question 1

Match the database realm to the appropriate activity.
-Database user realm
A)Create database tables
B)Update data
C)Create database model

Accepted Answer

Updating data in a database is a task typically performed by database users, as it involves modifying the content of the database without altering its structure. Creating database tables and models are tasks usually associated with database designers or administrators, who are responsible for the overall design and structure of the database.

Question 2

Which of the following is NOT a database anomaly?
A)Update
B)Commit
C)Deletion
D)Insertion

Accepted Answer

Update, deletion, and insertion are all database anomalies, as they can lead to inconsistencies and inaccuracies in the data. Commit, on the other hand, is not a database anomaly. It is simply the act of finalizing and saving changes made to the database.

Question 3

What are the three realms of a database and what happens in each realm?

Accepted Answer

The answer of What are the three realms of a...

Question 4

Which database architecture is a relatively new type of database?
A)Dimensional
B)XBRL
C)Relational
D)Network

Accepted Answer

XBRL (Extensible Business Reporting Language) is a relatively new type of database architecture used for financial reporting. It is an XML-based language that allows the sharing of financial information across different systems, making it easier to analyze and compare data from different sources. Dimensional, relational, and network database architectures have been around for much longer.

Question 5

The third step in creating a ERD diagram is to determine the relevant business transactions that the enterprise must support.

Accepted Answer

The third step in creating an ERD (Entity-Relationship Diagram) typically involves identifying and defining the entities and their relationships, not determining the relevant business transactions. Business transactions are more related to the processes that the system must support, which are considered after the entities and relationships are clearly defined.

Question 6

Provide an example of a deletion anomaly, update anomaly, and an insertion anomaly.

Accepted Answer

The answer of Provide an example of a deletion anomaly,...

Question 7

Which database architecture is typically used for data warehouses?
A)Dimensional
B)XBRL
C)Relational
D)Network

Accepted Answer

Dimensional database architecture is typically used for data warehouses. It is designed specifically for efficient retrieval of data for analysis and reporting purposes. It allows for easy querying of large amounts of data and provides a simplified view of the data through the use of facts and dimensions. XBRL is not a database architecture, but rather an XML-based language used for financial reporting. Relational databases can be used for data warehouses, but they may not be as efficient for analysis and reporting. Network databases are rarely used today.

Question 8

Entity identifiers are attributes that uniquely identify an entity occurrence.

Accepted Answer

Entity identifiers are attributes that uniquely identify a specific entity occurrence. Examples of entity identifiers could include social security numbers, student IDs, or employee IDs.

Question 9

List and define the four database essentials.

Accepted Answer

The answer of List and define the four database essentials....

Question 10

A candidate key is an entity identifier that uniquely identifies an entity.

Accepted Answer

A candidate key is a unique identifier for an entity that can be used to retrieve data or uniquely identify records in a database. It is a critical component of a database as it ensures data integrity and consistency. Multiple candidate keys can exist for an entity, but only one can be chosen as the primary key.

Question 11

Data, such as accounting data, can be facts related to
A)Records
B)Tables
C)Objects
D)RDBMS software

Accepted Answer

The answer of Data, such as accounting data, can be...

Question 12

Sometimes, in an entity relationship diagram, the entity relationship is written on the connection line.

Accepted Answer

It is common practice to label the relationship between two entities on the connection line in an entity relationship diagram. This helps to clarify the nature of the relationship between the entities being represented.

Question 13

What is data modeling?

Accepted Answer

The answer of What is data modeling?...

Question 14

You are an intern at a company. Some managers want to copy some of the data in the accounting database into a data warehouse. Your boss is questioning why this is necessary. Create an email explaining why this is a good idea.

Accepted Answer

The answer of You are an intern at a company....

Question 15

Data integrity refers to data being
A)Current and active
B)Current and complete
C)Accurate and current
D)Accurate and complete

Accepted Answer

Data integrity refers to the accuracy and completeness of data, which means that the data must be correct and complete without any errors or omissions. While being current and active is important, it does not necessarily guarantee data integrity. Similarly, data may be current but not accurate, or accurate but not complete, which would still compromise data integrity. Therefore, the best answer is D, accurate and complete.

Question 16

In an ERD diagram, an entity is represented by a rounded box or rectangle.

Accepted Answer

In an ERD (Entity-Relationship Diagram), an entity is represented by a rectangle, not a rounded box.

Question 17

Match the database realm to the appropriate activity.
-Database builder realm
A)Create database tables
B)Update data
C)Create database model

Accepted Answer

The database builder realm is primarily concerned with creating and defining the structure of the database, which includes creating database tables.

Question 18

One-to-one relationships are problematic when building a database.

Accepted Answer

One-to-one relationships are not inherently problematic in database design; they are used for specific scenarios such as dividing a table for security reasons, improving performance, or organizing data.

Question 19

For a single occurrence of one entity (one customer), cardinality defines the maximum and minimum number of occurrences that might relate to the other entity (sales orders).

Accepted Answer

Cardinality is a relationship between two entities, where it defines the maximum and minimum number of occurrences of one entity that can relate to the other entity. For example, in a sales system, the cardinality between customers and sales orders might be one-to-many, where one customer can have many sales orders, but a sales order can only belong to one customer. Therefore, for a single occurrence of one entity (one customer), cardinality defines the range of possible occurrences that might relate to the other entity (sales orders).

Question 20

This database essential retrieves data from a database.
A)Report
B)Form
C)Query
D)Field

Accepted Answer

A query is used to retrieve data from a database based on specific criteria. It allows the user to filter, sort, and group data as needed. Reports and forms are used to display data, but do not retrieve data directly from the database. Fields are individual pieces of data within a database record, but do not retrieve data from the database on their own.

Quiz 14: Database Design: ERD, REA, and SQL

Match the database realm to the appropriate activity. -Database user realm

Which of the following is NOT a database anomaly?

What are the three realms of a database and what happens in each realm?

Which database architecture is a relatively new type of database?

The third step in creating a ERD diagram is to determine the relevant business transactions that the enterprise must support.

Provide an example of a deletion anomaly, update anomaly, and an insertion anomaly.

Which database architecture is typically used for data warehouses?

Entity identifiers are attributes that uniquely identify an entity occurrence.

List and define the four database essentials.

A candidate key is an entity identifier that uniquely identifies an entity.

Data, such as accounting data, can be facts related to

Sometimes, in an entity relationship diagram, the entity relationship is written on the connection line.

What is data modeling?

You are an intern at a company. Some managers want to copy some of the data in the accounting database into a data warehouse. Your boss is questioning why this is necessary. Create an email explaining why this is a good idea.

Data integrity refers to data being

In an ERD diagram, an entity is represented by a rounded box or rectangle.

Match the database realm to the appropriate activity. -Database builder realm

One-to-one relationships are problematic when building a database.

For a single occurrence of one entity (one customer), cardinality defines the maximum and minimum number of occurrences that might relate to the other entity (sales orders).

This database essential retrieves data from a database.