Question 1

Like 4NF,5NF also applies to M-way relationships.

Accepted Answer

A) True 
 B)False

Question 2

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 table STUDENTD satisfies the following normal form (choose the highest NF):

Accepted Answer

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

Question 3

Even if a database is to be used mostly for querying data,with little or no change to the data,the highest degree of normalization should still be implemented.

Accepted Answer

A) True 
 B)False

Question 4

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 $$\begin{array} { | l | l | l | l | } 
\hline \text { NAME } & \text { AGE } & \text { MAJOR } & \text { MINOR } \
\hline \text { GREEN } & 26 & \text { MATH } & \text { INFO } \
\hline \text { HONEY } & 18 & \text { INFO } & \text { MATH } \
\hline \text { LAMPOC } & 33 & \text { MKTG } & \text { MGT } \
\hline \text { TAKKER } & 45 & \text { MKTG } & \text { MGT } \
\hline \text { YONAR } & 28 & \text { INFO } & \text { MATH } \
\hline
\end{array}$$
-The table STUDENTC 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 5

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 $$\begin{array} { | l | l | l | l | } 
\hline \text { NAME } & \text { AGE } & \text { MAJOR } & \text { MINOR } \
\hline \text { GREEN } & 26 & \text { MATH } & \text { INFO } \
\hline \text { HONEY } & 18 & \text { INFO } & \text { MATH } \
\hline \text { LAMPOC } & 33 & \text { MKTG } & \text { MGT } \
\hline \text { TAKKER } & 45 & \text { MKTG } & \text { MGT } \
\hline \text { YONAR } & 28 & \text { INFO } & \text { MATH } \
\hline
\end{array}$$
-The following is a transitive functional dependency in the table STUDENTC:

Accepted Answer

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

Question 6

One of the situations that BCNF addresses which 3NF does not is where part of a key determines part of a key.

Accepted Answer

A) True 
 B)False

Question 7

Storing a relationship in a database that could otherwise be derived from two independent relationships through a join operation can cause data modification operations to perform slower,but has no effect on modification anomalies.

Accepted Answer

A) True 
 B)False

Question 8

By definition,any table that is in BCNF must be in _____________.

Accepted Answer

The answer of By definition,any table that is in BCNF...

Question 9

The table schema STUDENT is replaced by the following two tables' schemas: $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}$

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 ones with less data duplication 
C)  The new tables provide the same information as the old ones 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 ones with less data duplication 
C)  The new tables provide the same information as the old ones with more data duplication 
D)  None of the above

Question 10

A table would be in ___________ if a three-way relationship should be replaced with three binary tables instead of two.

Accepted Answer

The answer of A table would be in ___________ if...

Question 11

Figuer:
The table STUDENTB has the following meaning. A student may have one major only and several minors; the choice of the major and of minors is independent of each other. Each student has a unique name. The table has only one candidate key.
STUDENTB $$\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 { HONEY } & \text { INFO } & \text { MATH } \
\hline \text { HONEY } & \text { INFO } & \text { MGT } \
\hline \text { LAMPOC } & \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 STUDENTB:

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 12

Due to the extra joins involved,splitting a table because it has multiple candidate keys can degrade query performance.

Accepted Answer

A) True 
 B)False

Question 13

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 multivalued dependency in the table STUDENTA:

Accepted Answer

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

Question 14

An experienced database designer always tries to achieve at least 3NF in all of their tables.

Accepted Answer

A) True 
 B)False

Question 15

4NF prohibits redundancies caused by MVDs.

Accepted Answer

A) True 
 B)False

Question 16

A table is in _____________ if it does not contain any MDVs that are not also FDs.

Accepted Answer

The answer of A table is in _____________ if it...

Like 4NF,5NF also applies to M-way relationships.

Even if a database is to be used mostly for querying data,with little or no change to the data,the highest degree of normalization should still be implemented.

One of the situations that BCNF addresses which 3NF does not is where part of a key determines part of a key.

Storing a relationship in a database that could otherwise be derived from two independent relationships through a join operation can cause data modification operations to perform slower,but has no effect on modification anomalies.

By definition,any table that is in BCNF must be in _____________.

The table schema STUDENT is replaced by the following two tables' schemas: 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}

A table would be in ___________ if a three-way relationship should be replaced with three binary tables instead of two.

Due to the extra joins involved,splitting a table because it has multiple candidate keys can degrade query performance.

An experienced database designer always tries to achieve at least 3NF in all of their tables.

4NF prohibits redundancies caused by MVDs.

A table is in _____________ if it does not contain any MDVs that are not also FDs.

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

Like 4NF,5NF also applies to M-way relationships.

Even if a database is to be used mostly for querying data,with little or no change to the data,the highest degree of normalization should still be implemented.

One of the situations that BCNF addresses which 3NF does not is where part of a key determines part of a key.

Storing a relationship in a database that could otherwise be derived from two independent relationships through a join operation can cause data modification operations to perform slower,but has no effect on modification anomalies.

By definition,any table that is in BCNF must be in _____________.

The table schema STUDENT is replaced by the following two tables' schemas: 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}

A table would be in ___________ if a three-way relationship should be replaced with three binary tables instead of two.

Due to the extra joins involved,splitting a table because it has multiple candidate keys can degrade query performance.

An experienced database designer always tries to achieve at least 3NF in all of their tables.

4NF prohibits redundancies caused by MVDs.

A table is in _____________ if it does not contain any MDVs that are not also FDs.

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