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

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

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 1: First Normal Form (1NF)

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

Entity identifiers that uniquely identify the entity are called

After ensuring compliance with the BCNF normalization rule, rarely does a database table need further normalization.

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

What does a database designer do?

List the ERD design steps that are dependent on the database structure.

Database anomalies are problems within a database table that result in inaccurate or incomplete data.

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

In SQL, ________ statements select, insert, update, and delete database records.

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 3. Boyce-Codd Normal Form (BCNF)

Which of the following is not considered a database element?

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

Detail of the ERD and information about the tables' fields, such as their size and type, are stored in a document called the ________.

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 1: Entity Integrity

Data integrity refers to data being

________ databases contain data collected by other organizations and agencies, such as the Securities and Exchange Commission (SEC).

________ is a fourth generation, nonprocedural language designed to define and manipulate relational database objects.

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 4: Referential Integrity