Database Design Using Normalization – True or False


Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

Warning: Undefined variable $ext in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/show-hidecollapse-expand/bg_show_hide.php on line 281

1. When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

A. True
B. False

Correct Answer:  B. False
Advertisement

2. Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

A. True
B. False

Correct Answer:  A. True
Advertisement

3. When building a database from an existing set of tables, we still need to consider normalization principles.

A. True
B. False

Correct Answer:  A. True
Advertisement

4. We have normalized a table into BCNF if all candidate keys are determinants.

A. True
B. False

Correct Answer:  B. False
Advertisement

5. We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

A. True
B. False

Correct Answer:  B. False
Advertisement

Warning: Undefined variable $in_same_cat in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Warning: Undefined variable $excluded_categories in /www/wwwroot/gkfeed.com/public_html/wp-content/plugins/EXP.GKFEED.COM/function.php on line 27

Leave A Comment?