Exam 7: Normalization of Relational Tables

A process known as the __________________________ can be used to generate tables in BCNF using a list of functional dependencies.

The table STUDENTC contains many more rows than shown.It is replaced by the following two tables with appropriate distribution of data to the new tables. Table1\\ \begin{array}{|l|l|l|} \hline \text { NAME } & \text { AGE } & \text { MAJOR } \\ \hline \end{array} Table2\\ \begin{array}{|l|l|} \hline \text { MAJOR } & \text { MINOR } \\ \hline \end{array}

Figuer: Name is the unique candidate key in the table STUDENTC. Each row in the table describes a different student. A student may only have one major and one minor. To each major corresponds a unique minor. STUDENTC NAME AGE MAJOR MINOR GREEN 26 MATH INFO HONEY 18 INFO MATH LAMPOC 33 MKTG MGT TAKKER 45 MKTG MGT YONAR 28 INFO MATH -The following is a nontrivial multivalued dependency in the table STUDENTC:

A table is said to be in ___________ if every determinant is a candidate key.

When deletion of one row in a table inadvertently causes other data to be deleted,this would be called a(n)____________________.

A relationship that can be derived from other relationships is known in relational database terminology as a(n)____________________________.

A good database design ensures that users can change the contents of a database without unexpected side effects.

When you use normalization techniques in the conceptual data modeling phase without necessarily producing an ERD,this is known as ___________________ approach.

A(n)____________________ occurs when additional data beyond the desired data must be added to the database.

An unexpected side effect that occurs when data is changed in a table that contains excessive redundancies is called a ___________________.

Redundancies can cause insert,update,and delete operations to produce unexpected side effects known as conversion errors.

Figuer: Name is the unique candidate key in the table STUDENT. Each row in the table describes a different student. A student may only have one major and one minor. The choice of a major is independent of the choice of a minor STUDENT NAME AGE MAJOR MINOR GREEN 26 MATH INFO HONEY 18 INFO MATH LAMPOC 33 MKTG MGT TAKKER 45 MKTG MGT TRAN 45 MATH INFF YONAR 28 INFO MATH -The table STUDENT satisfies the following normal form (choose the highest NF):

The table STUDENTB contains many more rows than shown.It is replaced by the following two tables with appropriate distribution of data to the new tables. Table1\\ \begin{array}{|l|l|} \hline \text { NAME} & \text { MAJOR} \\ \hline \end{array} Table2\\ \begin{array}{|l|l|} \hline \text { NAME} & \text { MINOR } \\ \hline \end{array}

Normalization techniques may be used in database development to improve the design that results from the Entity Relationship approach,but you cannot directly build database tables from the functional dependencies.

In the MVD expressed as A $\rightarrow \rightarrow$ B | C,a given A value is associated with a(n)___________________ of B and C values.

When it is necessary to change multiple rows in a table to modify only a single fact,this is known as a(n)_______________________.

When you split one table into two smaller tables to achieve 2NF,you can no longer derive the functional dependencies of the original table.

Figuer: The table STUDENTD has the following meaning. A student may have several majors and several minors. In the table only one minor corresponds to a given major, and only one major corresponds to a given minor. Each student has a unique name. STUDENTD NAME MAJOR MINOR GREEN MATH INFO GREEN PHILO LATIN HONEY INFO CS LAMPO MKTG MGT Takker MKTG MGT YONA INFO CS -Which of the following is not one of the modification anomalies discussed in the text:

Figuer: Name is the unique candidate key in the table STUDENT. Each row in the table describes a different student. A student may only have one major and one minor. The choice of a major is independent of the choice of a minor STUDENT NAME AGE MAJOR MINOR GREEN 26 MATH INFO HONEY 18 INFO MATH LAMPOC 33 MKTG MGT TAKKER 45 MKTG MGT TRAN 45 MATH INFF YONAR 28 INFO MATH -The following is not a functional dependency in the table STUDENT:

The goal of _____________________ is to not store data about relationships that can be derived by joining other relationships.