Normalization Practice

{"ad_unit_id":"App_Resource_Sidebar_Upper","resource":{"id":18318352,"author_id":7262670,"title":"Normalization Practice","created_at":"2019-05-31T01:28:14Z","updated_at":"2019-05-31T02:49:33Z","sample":false,"description":"C175","alerts_enabled":false,"cached_tag_list":"","deleted_at":null,"hidden":false,"average_rating":"4.0","demote":false,"private":false,"copyable":false,"score":140,"artificial_base_score":0,"recalculate_score":true,"profane":false,"hide_summary":false,"tag_list":[],"admin_tag_list":[],"study_aid_type":"Quiz","show_path":"/quizzes/18318352","folder_id":21134909,"public_author":{"id":7262670,"profile":{"name":"Craig Willey","about":"","avatar_service":"gravatar","locale":"en-US","google_author_link":null,"user_type_id":157,"escaped_name":"Craig Willey","full_name":"Craig Willey","badge_classes":""}}},"width":300,"height":250,"rtype":"Quiz","rmode":"view","placement":1,"custom":[{"key":"rsubject","value":"C175 - Data Management - Foundations"},{"key":"rlevel","value":"College"},{"key":"env","value":"production"},{"key":"rtype","value":"Quiz"},{"key":"rmode","value":"view"},{"key":"placement","value":1},{"key":"sequence","value":1},{"key":"uauth","value":"f"},{"key":"uadmin","value":"f"},{"key":"ulang","value":"en"},{"key":"ucurrency","value":"usd"}]}

{"ad_unit_id":"App_Resource_Sidebar_Upper","resource":{"id":18318352,"author_id":7262670,"title":"Normalization Practice","created_at":"2019-05-31T01:28:14Z","updated_at":"2019-05-31T02:49:33Z","sample":false,"description":"C175","alerts_enabled":false,"cached_tag_list":"","deleted_at":null,"hidden":false,"average_rating":"4.0","demote":false,"private":false,"copyable":false,"score":140,"artificial_base_score":0,"recalculate_score":true,"profane":false,"hide_summary":false,"tag_list":[],"admin_tag_list":[],"study_aid_type":"Quiz","show_path":"/quizzes/18318352","folder_id":21134909,"public_author":{"id":7262670,"profile":{"name":"Craig Willey","about":"","avatar_service":"gravatar","locale":"en-US","google_author_link":null,"user_type_id":157,"escaped_name":"Craig Willey","full_name":"Craig Willey","badge_classes":""}}},"width":300,"height":250,"rtype":"Quiz","rmode":"view","placement":2,"custom":[{"key":"rsubject","value":"C175 - Data Management - Foundations"},{"key":"rlevel","value":"College"},{"key":"env","value":"production"},{"key":"rtype","value":"Quiz"},{"key":"rmode","value":"view"},{"key":"placement","value":2},{"key":"sequence","value":1},{"key":"uauth","value":"f"},{"key":"uadmin","value":"f"},{"key":"ulang","value":"en"},{"key":"ucurrency","value":"usd"}]}

{"ad_unit_id":"App_Resource_Sidebar_Lower","resource":{"id":18318352,"author_id":7262670,"title":"Normalization Practice","created_at":"2019-05-31T01:28:14Z","updated_at":"2019-05-31T02:49:33Z","sample":false,"description":"C175","alerts_enabled":false,"cached_tag_list":"","deleted_at":null,"hidden":false,"average_rating":"4.0","demote":false,"private":false,"copyable":false,"score":140,"artificial_base_score":0,"recalculate_score":true,"profane":false,"hide_summary":false,"tag_list":[],"admin_tag_list":[],"study_aid_type":"Quiz","show_path":"/quizzes/18318352","folder_id":21134909,"public_author":{"id":7262670,"profile":{"name":"Craig Willey","about":"","avatar_service":"gravatar","locale":"en-US","google_author_link":null,"user_type_id":157,"escaped_name":"Craig Willey","full_name":"Craig Willey","badge_classes":""}}},"width":300,"height":250,"rtype":"Quiz","rmode":"view","sizes":"[[[0, 0], [[300, 250]]]]","custom":[{"key":"rsubject","value":"C175 - Data Management - Foundations"},{"key":"rlevel","value":"College"},{"key":"env","value":"production"},{"key":"rtype","value":"Quiz"},{"key":"rmode","value":"view"},{"key":"sequence","value":1},{"key":"uauth","value":"f"},{"key":"uadmin","value":"f"},{"key":"ulang","value":"en"},{"key":"ucurrency","value":"usd"}]}

Remove ads

We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our terms and conditions for more information.

Quiz by Craig Willey, created more than 1 year ago

C175

9657

	Created by Craig Willey over 7 years ago

C175

Normalization Practice

Normalization Practice

Question 1 of 11

In which state are the attributes shown (see table)?

Select one of the following:

Explanation

Question 2 of 11

In which state is the table in (see table)?

Select one of the following:

Explanation

Question 3 of 11

The primary key in the first table is Booking ID, and the primary key in the second is Client ID. How advanced are the two tables in the normalization process (see tables)?

Select one of the following:

Explanation

Question 4 of 11

What characteristic points to the tables shown above being in third normal form?

Select one of the following:

Explanation

Question 5 of 11

The primary key of the table is a composite key made up of Registration ID and Activity ID. In which form is the table?

Select one of the following:

Explanation

Question 6 of 11

In which form is the table?

Select one of the following:

Explanation

Question 7 of 11

In which state are the attributes shown?

Select one of the following:

Explanation

Question 8 of 11

In which state are the attributes shown (see table)?

Select one of the following:

Explanation

Question 9 of 11

In which state are the attributes shown (see table above)?

Select one of the following:

Explanation

Question 10 of 11

In which state are the attributes shown?

Select one of the following:

Explanation

Question 11 of 11

In which state is the table above?

Select one of the following:

Explanation

The primary key in the first table is Booking ID, and the primary key in the second is Client ID.

How advanced are the two tables in the normalization process (see tables)?