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

6. One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

A. True
B. False

Correct Answer:  B. False
Advertisement

7. In all cases, normalization into BCNF is desirable.

A. True
B. False

Correct Answer:  B. False
Advertisement

8. Denormalized tables are in BCNF.

A. True
B. False

Correct Answer:  B. False
Advertisement

9. We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

A. True
B. False

Correct Answer:  A. True
Advertisement

10. Proper normalization eliminates duplicated data.

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?