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

The database ________ creates the database.

Many-to-many relationships are not problematic when building a database.

In REA modeling, an agent is related to a resource through a(n)

Which database architecture is typically used for data warehouses?

Entity identifiers are attributes that uniquely identify an entity occurrence.

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

Which REA diagraming rule states at least two agent entities are required for an event entity.

A specific customer, such as Vincent, is an entity ________.

When using normalization for database development, all the attributes are placed in one huge table.

What is the purpose of an entity relationship diagram?

For an ERD, what do the business rules define?

Match the database integrity rule to the appropriate definition. A)Each record in the database must have a unique identifier called a primary key. B)Data referenced and stored in related tables must be consistent across the database. C)The primary key value cannot be null (empty). D)The field values must be from a predefined domain. -Rule 3: Domain Integrity

In the REA model, the ________ event consumes business resources.

In an ERD diagram, the entity attributes are listed in the entity box.

________ is a piece of information about events and objects.

You are a staff accountant at a large firm and are assigned to work with the IT department to update the current systems throughout the organization. An accounting intern is assigned to help with the project. The intern wants to document the current processes using a REA diagram. How do you explain to the intern why REA diagram is not appropriate?

Which database architecture is typically used for operational databases?

When using normalization for database development, all the attributes are placed in

An entity occurrence describes a property of the entity (an object or event).

What are the three classifications of internal database? How is each used?