Section 5 Practice Quiz

A table that displays data redundancies yields ____.

Anomalies

The problem with transitive dependencies is that they yield data ____, inconsistencies, and irregularities.

Anomalies

(T/F) All relational tables satisfy the 1NF requirements.

T

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.

1NF

All relational tables satisfy the ____ requirements.

1NF

From a structural point of view, 2NF is better than _____.

1NF

A table that is in 1NF and includes no partial dependencies is said to be in ____.

2NF

Before converting a table into 3NF, it is imperative the table already be in ____.

2NF

From a structural point of view, 3NF is better than _____.

2NF

A table that is in 2NF and contains no transitive dependencies is said to be in ___.

3NF

For most business transactional databases, we should normalize relations into ____.

3NF

Most designers consider the BCNF as a special case of the ____.

3NF

In the ____, no row may contain two or more multivalued facts about an entity.

4NF

Some very specialized applications may require normalization beyond the _____.

4NF

An attribute that cannot be further subdivided is said to be ____.

Atomic

Improving _____ leads to more flexible queries.

Atomicity

BCNF can be violated only if the table contains more than one _____ key.

Candidate

An atomic attribute ____.

Cannot be further subdivided

When designing a new database structure based on the business requirements of the end users, the database designer will construct a data model using a technique such as ____.

Crow's Foot notation ERDs.

Of the following normal forms, ____ is mostly of theoretical interest.

DKNF

Data redundancy produces ____.

Data anomalies

In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

Dependency

From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.

Derived

Any attribute whose value determines other values within a row is known as a(n) _____.

Determinant

Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Determines

Dependencies can be identified with the help of a dependency ____________________.

Diagram

(T/F) A dependency of one non-prime attribute on another non-prime attribute is a partial dependency.

F

(T/F) A determinant is any attribute whose value determines other values w/in a column.

F

(T/F) Dependencies that're based on only a part of a composite prim key are called transitive dependencies.

F

(T/F) Normalization is a very important database design ingredient and the highest level is always the most desirable.

F

(T/F) Normalization produces a lower normal form

F

(T/F) Reporting anomalies in a table can cause a multitude of problems for managers and can be fixed through application programming.

F

____ refers to the level of detail represented by the values stored in a table's row.

Granularity

When designing a database, you should _____.

Make sure that the table entities are normalized before table structures are created

____ is a process of organizing the data in a database to avoid insertion anomaly, data redundancy, and update/deletion anomaly.

Normalization

____ is a process to help reduce the likelihood of data anomalies.

Normalization

_____ is a process that's used for changing attributes to entities.

Normalization

1NF, 2NF, and 3NF are ____.

Normalization stages

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

Partial

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute.

Partial dependencies

A dependency based on only a part of a prim key is called a _____.

Partial dependency

_____ specifies that a non-prime attribute is functionally dependent on part of a candidate key.

Partial dependency

Because a partial dependency can exist only when a table's primary key is composed of several attributes, a table whose _____ key consists of only a single attribute is automatically in 2NF once it is in 1NF.

Primary

An attribute that is part of a key is known as a(n) ____ attribute.

Prime

Any attribute that is at least part of a key is known as a(n) ____________________.

Prime attribute

A ____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

Repeating group

A relational table must not contain a(n) _____.

Repeating group

(T/F) A dependency based on only a part of a composite primary key is known as a partial dependency.

T

(T/F) A table is in BCNF if every determinant in the table is a candidate key.

T

(T/F) A transitive dependency is one in which an attribute is functionally dependent on another non-key attribute.

T

(T/F) Data redundancy produces data anomalies.

T

(T/F) Dependency diagrams are very helpful in getting a bird's eye view of all the relationships among a table's attributes.

T

(T/F) In the context of partial dependencies, data redundancies occur bc every row entry requires duplication of data.

T

(T/F) It's possible for a table in 2NF to exhibit transitive dependencies.

T

(T/F) Normalization is a process that's used for changing attributes (columns) to entities (tables).

T

(T/F) Normalization works through a series of stages called "normal forms".

T

(T/F) Relational models view data as part of a table or collection of tables in which all key values must be identified.

T

(T/F) Repeating groups must be eliminated by ensuring that each row defines a single entity.

T

(T/F) Since a partial dependency can exist only if a table's prim key is a composite prim key, if a table in 1NF has a single-attribute prim key, then the table is automatically in 2NF.

T

(T/F) The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

T

When a table contains only one candidate key, _____ are considered to be equivalent.

The 3NF and BCNF

Granularity refers to ____.

The level of detail represented by the values in a table's row

Normalization works through a series of stages called normal forms. For most purposes in business database design, _____ stages are as high as you need to go in the normalization process.

Three

A(n) ____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

Transitive dependency