Question 1

Although 3NF and BCNF usually produce the same table results,3NF is a stronger and simpler definition than BCNF.

Accepted Answer

A) True 
 B)False

Question 2

Figuer:
The table STUDENTA has the following meaning. A student may have several majors and several minors; the choice of majors and minors is independent of each other. Each student has a unique name. The table has only one candidate key.
STUDENTA $$\begin{array} { | l | l | l | } 
\hline \text { NAME } & \text { MAJOR } & \text { MINOR } \
\hline \text { GREEN } & \text { MATH } & \text { INFO } \
\hline \text { GREEN } & \text { MATH } & \text { MKTG } \
\hline \text { GREEN } & \text { PHILO } & \text { MKTG } \
\hline \text { HONEY } & \text { INFO } & \text { MATH } \
\hline \text { LAMPO } & \text { MKTG } & \text { MGT } \
\hline \text { Takker } & \text { MKTG } & \text { MGT } \
\hline \text { YONA } & \text { INFO } & \text { MATH } \
\hline
\end{array}$$
-The following is a functional dependency in the table STUDENTA:

Accepted Answer

A)  Name -> Minor 
B)  Name -> Major 
C)  Name -> Minor, Major 
D)  None of the above 
A)  Name -> Minor 
B)  Name -> Major 
C)  Name -> Minor, Major 
D)  None of the above

Question 3

If a database is used mostly for data modification,the _______________ degree of normal form should be achieved.

Accepted Answer

The answer of If a database is used mostly for...

Question 4

The difference between value-based constraints and value-neutral constraints is that value-based constraints are based on the comparison of columns while value-neutral constraints are based on the comparison of a column to constant using a comparison operator.

Accepted Answer

A) True 
 B)False

Question 5

A table with multiple candidate keys violates 3NF and BCNF.

Accepted Answer

A) True 
 B)False

Question 6

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 $$\begin{array} { | l | l | l | } 
\hline \text { NAME } & \text { MAJOR } & \text { MINOR } \
\hline \text { GREEN } & \text { MATH } & \text { INFO } \
\hline \text { GREEN } & \text { PHILO } & \text { LATIN } \
\hline \text { HONEY } & \text { INFO } & \text { CS } \
\hline \text { LAMPO } & \text { MKTG } & \text { MGT } \
\hline \text { Takker } & \text { MKTG } & \text { MGT } \
\hline \text { YONA } & \text { INFO } & \text { CS } \
\hline
\end{array}$$
-The following is a functional dependency in the table STUDENTD:

Accepted Answer

A)  Name -> Minor 
B)  Name -> Major 
C)  Major -> Minor 
D)  Major -> Name 
A)  Name -> Minor 
B)  Name -> Major 
C)  Major -> Minor 
D)  Major -> Name

Question 7

A table is in ___________ if every constraint on a table can be derived form keys and domains.

Accepted Answer

Domain Key

Question 8

The process of __________________ removes redundancy in a table so that the table is easier to modify.

Accepted Answer

The answer of The process of __________________ removes redundancy in...

Question 9

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 $$\begin{array} { | l | l | l | } 
\hline \text { NAME } & \text { MAJOR } & \text { MINOR } \
\hline \text { GREEN } & \text { MATH } & \text { INFO } \
\hline \text { GREEN } & \text { PHILO } & \text { LATIN } \
\hline \text { HONEY } & \text { INFO } & \text { CS } \
\hline \text { LAMPO } & \text { MKTG } & \text { MGT } \
\hline \text { Takker } & \text { MKTG } & \text { MGT } \
\hline \text { YONA } & \text { INFO } & \text { CS } \
\hline
\end{array}$$
-Which of the following is not a normal form:

Accepted Answer

A)  1NF 
B)  3NF 
C)  7NF 
D)  DKNF 
A)  1NF 
B)  3NF 
C)  7NF 
D)  DKNF

Question 10

A database design with many tables results in the database being easier to change but more difficult to query.

Accepted Answer

A) True 
 B)False

Question 11

When the constraint Age > = 21 is used in a database to restrict the sale of alcohol to minors,this is an example of a(n)________________ constraint.

Accepted Answer

The answer of When the constraint Age > = 21...

Question 12

One of the arguments in favor of using normalization as a refinement tool instead of an initial design tool is that by first developing an ERD,much of the normalization is done informally and therefore is not as tedious a process as recording all the functional dependencies.

Accepted Answer

A) True 
 B)False

Question 13

1NF prohibits the occurrence of __________________ in a table.

Accepted Answer

The answer of 1NF prohibits the occurrence of __________________ in...

Question 14

In the table STUDENTB,when Green replaces her MATH major by a PHYSICS major,the following anomaly is evidenced:

Accepted Answer

A)  update anomaly 
B)  insertion anomaly 
C)  deletion anomaly 
D)  none of the above 
A)  update anomaly 
B)  insertion anomaly 
C)  deletion anomaly 
D)  none of the above

Question 15

Figuer:
The table STUDENTA has the following meaning. A student may have several majors and several minors; the choice of majors and minors is independent of each other. Each student has a unique name. The table has only one candidate key.
STUDENTA $$\begin{array} { | l | l | l | } 
\hline \text { NAME } & \text { MAJOR } & \text { MINOR } \
\hline \text { GREEN } & \text { MATH } & \text { INFO } \
\hline \text { GREEN } & \text { MATH } & \text { MKTG } \
\hline \text { GREEN } & \text { PHILO } & \text { MKTG } \
\hline \text { HONEY } & \text { INFO } & \text { MATH } \
\hline \text { LAMPO } & \text { MKTG } & \text { MGT } \
\hline \text { Takker } & \text { MKTG } & \text { MGT } \
\hline \text { YONA } & \text { INFO } & \text { MATH } \
\hline
\end{array}$$
-The table STUDENTA satisfies the following normal form (choose the highest NF):

Accepted Answer

A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF 
A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF

Question 16

An MVD that is not an FD is called a(n)________________ MVD.

Accepted Answer

The answer of An MVD that is not an FD...

Question 17

If an analysis of relationship independence reveals that redundancies exist,the way to alleviate this situation is to replace the entity with two binary relationships which will each be converted to a table.

Accepted Answer

A) True 
 B)False

Question 18

Deleting the second row from the table STUDENTA causes:

Accepted Answer

A)  an update anomaly 
B)  a deletion anomaly 
C)  an insertion anomaly 
D)  no loss of information 
A)  an update anomaly 
B)  a deletion anomaly 
C)  an insertion anomaly 
D)  no loss of information

Question 19

An unexpected side effect that occurs when changing the data in a table with excessive redundancies is referred to as a Modification Anomaly.

Accepted Answer

A) True 
 B)False

Question 20

The table STUDENTA 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}$

Accepted Answer

A)  Some information is lost in this transformation and some meaningless information is provided 
B)  The new tables provide the same information as the old one with less data duplication 
C)  The new tables provide the same information as the old one with more data duplication 
D)  None of the above 
A)  Some information is lost in this transformation and some meaningless information is provided 
B)  The new tables provide the same information as the old one with less data duplication 
C)  The new tables provide the same information as the old one with more data duplication 
D)  None of the above

Although 3NF and BCNF usually produce the same table results,3NF is a stronger and simpler definition than BCNF.

If a database is used mostly for data modification,the _______________ degree of normal form should be achieved.

The difference between value-based constraints and value-neutral constraints is that value-based constraints are based on the comparison of columns while value-neutral constraints are based on the comparison of a column to constant using a comparison operator.

A table with multiple candidate keys violates 3NF and BCNF.

A table is in ___________ if every constraint on a table can be derived form keys and domains.

The process of __________________ removes redundancy in a table so that the table is easier to modify.

A database design with many tables results in the database being easier to change but more difficult to query.

When the constraint Age > = 21 is used in a database to restrict the sale of alcohol to minors,this is an example of a(n)________________ constraint.

One of the arguments in favor of using normalization as a refinement tool instead of an initial design tool is that by first developing an ERD,much of the normalization is done informally and therefore is not as tedious a process as recording all the functional dependencies.

1NF prohibits the occurrence of __________________ in a table.

In the table STUDENTB,when Green replaces her MATH major by a PHYSICS major,the following anomaly is evidenced:

An MVD that is not an FD is called a(n)________________ MVD.

If an analysis of relationship independence reveals that redundancies exist,the way to alleviate this situation is to replace the entity with two binary relationships which will each be converted to a table.

Deleting the second row from the table STUDENTA causes:

An unexpected side effect that occurs when changing the data in a table with excessive redundancies is referred to as a Modification Anomaly.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 7: Normalization of Relational Tables

Although 3NF and BCNF usually produce the same table results,3NF is a stronger and simpler definition than BCNF.

If a database is used mostly for data modification,the _______________ degree of normal form should be achieved.

The difference between value-based constraints and value-neutral constraints is that value-based constraints are based on the comparison of columns while value-neutral constraints are based on the comparison of a column to constant using a comparison operator.

A table with multiple candidate keys violates 3NF and BCNF.

A table is in ___________ if every constraint on a table can be derived form keys and domains.

The process of __________________ removes redundancy in a table so that the table is easier to modify.

A database design with many tables results in the database being easier to change but more difficult to query.

When the constraint Age > = 21 is used in a database to restrict the sale of alcohol to minors,this is an example of a(n)________________ constraint.

One of the arguments in favor of using normalization as a refinement tool instead of an initial design tool is that by first developing an ERD,much of the normalization is done informally and therefore is not as tedious a process as recording all the functional dependencies.

1NF prohibits the occurrence of __________________ in a table.

In the table STUDENTB,when Green replaces her MATH major by a PHYSICS major,the following anomaly is evidenced:

An MVD that is not an FD is called a(n)________________ MVD.

If an analysis of relationship independence reveals that redundancies exist,the way to alleviate this situation is to replace the entity with two binary relationships which will each be converted to a table.

Deleting the second row from the table STUDENTA causes:

An unexpected side effect that occurs when changing the data in a table with excessive redundancies is referred to as a Modification Anomaly.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters