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

The SQL command DROP deletes a database object, such as removing an existing field from a specific table.

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?

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

In REA modeling, a resource

In the REA model, the ________ event compensates the consumed resource with a different or same type of resource.

In SQL, Data Definition Language statements create, alter, and drop database objects.

SQL is a language for ________ databases.

In a REA model, a(n)________ is a person or organization involved in events and can include a vendor, employee, or customer.

In an REA, a(n)________ has an economic value to the enterprise, such as inventory.

SQL DML statements select, insert, update, and delete database records.

An REA diagram does not depict agent dependents.

What are the four rules for designing an REA diagram? Include a definition for each.

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

Which REA diagraming rule states every event entity must relate to a resource entity?

In an REA, an entity can be a

The SQL command ALTER changes the relational database, such as adding a new field to a specific table.

Spice House REA Diagram -In the Spice House REA diagram, list the one-to-many relationships.

In an REA model, a(n)________ included activities and transactions.

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

In SQL, ________ statements create, alter, and drop database objects.