Exam 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.