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

Besides retrieving data from a relational database, what else can you do with SQL statements?

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

The ________ relationship is the essence of a business in the market economy.

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

In an REA, an entity can be a

In SQL, Data Definition Language statements select, insert, update, and delete database records.

In database design terminology, a customer is an

In ________ modeling, a resource has economic value to the enterprise, such as inventory, cash, or other assets.

________ depicts the relationship among entities in the database.

The database design impact how well the database serves the needs of the enterprise.

In REA modeling, a resource

Match the normalization rule to the appropriate definition. A)No field can have multiple values. B)The table identifier (primary key)should not be a composite key. C)Every identifier should be a candidate key -Rule 2. Second Normal Form (2NF)

List and define the four database essentials.

In an ERD diagram, relationship cardinality is represented as

Match the ERD symbols to the definition. A)Entity relationship B)Entity identifier C)Relationship cardinality D)Entity E)Entity Attributes -

Which symbol represents a cardinality of a maximum: many and minimum: 1?

Experience does not help database designer define business entities and relationships among those entities.

Match the ERD symbols to the definition. A)Entity relationship B)Entity identifier C)Relationship cardinality D)Entity E)Entity Attributes -

Operational databases almost exclusively use the ________ structure.

The database integrity rule Referential Integrity states that field values must be from a predefined domain.