Exam 15: Normalize a Database for Effective Design

One goal of normalization is to minimize anomalies,in particular three anomalies-insert,delete,and update.

In a small business,a department might be managed by no more than one manager,and each manager manages no more than one department.This is an example of a 1:1 relationship.

A(n)________ is when a field depends on another field in the table,which then depends on a candidate key.

When multiple fields are used to identify a record,it is a composite key,which is sometimes referred to as a concatenated key.

Each employee can only be in the employees table exactly one time.However,an employee can be in the orders table many times,once for each sale.This is an example of a(n)________ relationship.

Which of the following is NOT true about identifying the cardinality in an ERD?

Cardinality indicates the number of instances of one entity that relates to one instance of another entity.

Access allows you to add some ________ to your database to help ensure the data's validity.

________ indicate(s)the number of instances of one entity that relates to one instance of another entity.

Candidate keys that are not used for the primary key are ________ keys.

Which of the following is NOT a shape included on an ERD?

A(n)________ is a field that determines the value of another field.

A(n)________ is a common way to visually express the tables and relationships in your database.

While several orders can be placed on the same day,one order cannot be placed on more than one date.Thus,order date is ________ the key of Order ID.

Candidate keys that are not used for the primary keys are ________ keys.

A dependency requires that the table has no fields with partial dependencies on a composite or concatenated key and satisfies 1NF.

An update anomaly forces you to change data in multiple records,such as when you need to change the name of a product and you must change multiple rows to make the update.

________ are rules that are specific for each field in a table.

Which of the following is NOT a step that you would take when creating an ERD?