Question 1

The ____________________ process enables you to identify the existence of potential problems in the design of a database.​

Accepted Answer

The answer of The ____________________ process enables you to identify...

Question 2

If there is more than one possible choice for the primary key,and one of the possibilities is chosen to be the primary key,the others are referred to as ____.​
A) ​canceled keys
B) ​alternate keys
C) ​nonkey attributes
D) ​contributory keys

Accepted Answer

When there are multiple possible choices for the primary key, the others are referred to as alternate keys. These alternate keys can still uniquely identify a row in the table, but they are not chosen as the primary key. Other options such as canceled keys, nonkey attributes, and contributory keys are not correct terms for this scenario.

Question 3

Another name for a nonkey column is a ____.​
A) ​nonkey attribute
B) ​key attribute
C) ​nonkey row
D) ​key table

Accepted Answer

Nonkey column refers to the columns in a database table that do not play any role in the identification of a record or unique identification of a row. These columns are known as nonkey attributes, and they are not used as primary keys in the table. Therefore, option A is the correct answer. The other options, B) key attribute, C) nonkey row, and D) key table, are incorrect and do not correctly define a nonkey column.

Question 4

A(n)____________________ uses arrows to indicate all the functional dependencies present in the table.​

Accepted Answer

The answer of A(n)____________________ uses arrows to indicate all the...

Question 5

To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.​
A) ​determines
B) ​multidetermines
C) ​defines
D) ​identifies

Accepted Answer

Fourth normal form (4NF) deals with multivalued dependencies, so the table should be split based on columns that multidetermine others.

Question 6

A column is a nonkey column if it is ____.​
A) ​in first normal form
B) ​in second normal form
C) ​a part of the primary key
D) ​not a part of the primary key

Accepted Answer

A nonkey column is any column in a table that is not part of the primary key. Option A and B are incorrect because being in first normal form or second normal form does not affect whether a column is a nonkey column. Option C is incorrect because a column that is part of the primary key is, by definition, a key column, not a nonkey column.

Question 7

Second normal form represents an improvement over ____________________ normal form.​

Accepted Answer

The answer of Second normal form represents an improvement over...

Question 8

An alternate key is a ____.​
A) ​foreign key
B) ​primary key
C) ​column that could be a primary key but was not chosen
D) ​row that could be a primary key but was not chosen

Accepted Answer

An alternate key is a column that could be a primary key but was not chosen. It is unique within the table and can be used as a reference point for other tables, but it is not the primary way of identifying each record in the table. A foreign key is a column that references another table's primary key, while a primary key is the unique identifier for each record in the table. A row cannot be a key in itself, only the values within it can be used as keys.

Question 9

Which of the followingcontains a repeating group?​
A) ​Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) )
B) ​Orders (OrderNum, OrderDate, ItemNum, NumOrdered )
C) ​Orders (OrderNum, OrderDate)
D) ​Orders (OrderNum, ItemNum, NumOrdered )

Accepted Answer

Choice A contains a repeating group with the items ordered being listed as a group within the Orders table. This violates the first normal form of database normalization as each attribute should contain only atomic values. The other choices do not contain repeating groups.

Question 10

​A table that contains a repeating group is called a(n)____.
A) ​normalized relation
B) ​unnormalized relation
C) ​nominal relation
D) ​non-nominal relation

Accepted Answer

A table that contains a repeating group is called an unnormalized relation. A repeating group is a set of two or more columns in a table that are related and can contain multiple values for a single record. This violates the first normal form (1NF) of database normalization. To normalize the table, the repeating group should be split into a separate table, related to the original table through a foreign key.

Question 11

The conversion of an unnormalized table to first normal form requires the removal of ____.​
A) ​determinants
B) ​interrelation constraints
C) ​nonkey columns
D) ​repeating groups

Accepted Answer

To convert an unnormalized table to first normal form, the repeating groups should be removed. Repeating groups refer to the columns that contain multiple values within a single record. Removing these repeating groups involves creating a separate table for each set of related values, and establishing a relationship between the new tables and the original table using a foreign key. The removal of determinants, interrelation constraints or nonkey columns is not specifically required for first normal form conversion.

Question 12

A table is in first normal form if it does not contain ____.​
A) ​repeating groups
B) ​a foreign key
C) ​a primary key
D) ​alternate keys

Accepted Answer

Repeating groups violate the first normal form as they contain multiple values in a single column, leading to data redundancy and inconsistency. A table must have atomic (indivisible) values in each column to be in the first normal form. Foreign keys, primary keys, and alternate keys are used to enforce data integrity and relationships between tables, but they do not determine whether a table is in the first normal form.

Question 13

A(n)____ is a column or collection of columns on which all columns in the table are functionally dependent.​
A) ​index key
B) ​candidate key
C) ​major key
D) ​special key

Accepted Answer

A candidate key is a column or collection of columns on which all columns in the table are functionally dependent. It is a potential primary key for a table and can uniquely identify each row in the table. An index key is a database object that improves the speed of data retrieval operations on a table. A major key and special key are not commonly used terms in database design.

Question 14

​A table is in fourth normal form when it is in third normal form and there are no ____.
A) ​alternate keys
B) ​foreign keys
C) ​multivalued dependencies
D) ​primary dependencies

Accepted Answer

Fourth normal form (4NF) is a level of database normalization where multivalued dependencies (MVDs) are further handled after being dealt with in third normal form. In 4NF, there should be no dependencies between sets of two or more multivalued dependencies.

Question 15

​A column is a nonkey column if it is not a part of the ____________________.

Accepted Answer

The answer of ​A column is a nonkey column if...

Question 16

Partial dependencies are dependencies on only a portion of the ____.​
A) ​nonkey column
B) ​first column or attribute
C) ​primary key
D) ​index

Accepted Answer

Partial dependencies occur when a non-key attribute is dependent on only a part of a composite primary key, rather than the whole key.

Question 17

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.​

Accepted Answer

The answer of A column B is ____________________ on another...

Question 18

____ normal form has an additional condition that the only determinants the table contains are candidate keys.​
A) ​First
B) ​Second
C) ​Third
D) ​Fourth

Accepted Answer

In Third Normal Form (3NF), a table must not contain any transitive dependencies and should be free of functional dependencies on non-key attributes. Additionally, 3NF requires that every non-key attribute be fully dependent on the primary key and not just a subset of the key. Finally, 3NF stipulates that the table should not contain any determinants other than candidate keys. This means that every non-key attribute should have a unique relationship with a candidate key, and not with any other non-key attributes or groups of non-key attributes. Therefore, option C is the best choice for the given question.

Question 19

Second normal form can be defined as a table that is in first normal form but that contains no ____.​
A) ​partial dependencies
B) ​alternate keys
C) ​nonkey columns
D) ​interrelation constraints

Accepted Answer

Second normal form (2NF) requires that a table must be in first normal form (1NF) and there should be no partial dependencies. A partial dependency is when a non-key attribute is dependent on only a part of a composite primary key.

Question 20

From all the ____ keys,one is chosen to be the primary key.​
A) ​alternate
B) ​candidate
C) ​functional
D) ​normal

Accepted Answer

In database normalization, candidate keys are those attributes that can uniquely identify a record within a table. Among all the candidate keys, one may be selected as the primary key. Therefore, option B) candidate is the best choice as it accurately reflects the concept of choosing a primary key among a set of potential keys. Options A) alternate, C) functional, and D) normal do not accurately reflect the concept of selecting a primary key.

Quiz 5: Database Design 1: Normalization

The ____________________ process enables you to identify the existence of potential problems in the design of a database.

If there is more than one possible choice for the primary key,and one of the possibilities is chosen to be the primary key,the others are referred to as ____.

Another name for a nonkey column is a ____.

A(n)____________________ uses arrows to indicate all the functional dependencies present in the table.

To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.

A column is a nonkey column if it is ____.

Second normal form represents an improvement over ____________________ normal form.

An alternate key is a ____.

Which of the followingcontains a repeating group?

A table that contains a repeating group is called a(n) ____.

The conversion of an unnormalized table to first normal form requires the removal of ____.

A table is in first normal form if it does not contain ____.

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.

A table is in fourth normal form when it is in third normal form and there are no ____.

A column is a nonkey column if it is not a part of the ____________________.

Partial dependencies are dependencies on only a portion of the ____.

A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.

____ normal form has an additional condition that the only determinants the table contains are candidate keys.

Second normal form can be defined as a table that is in first normal form but that contains no ____.

From all the ____ keys,one is chosen to be the primary key.

Quiz 5: Database Design 1: Normalization

The ____________________ process enables you to identify the existence of potential problems in the design of a database.​

If there is more than one possible choice for the primary key,and one of the possibilities is chosen to be the primary key,the others are referred to as ____.​

Another name for a nonkey column is a ____.​

A(n)____________________ uses arrows to indicate all the functional dependencies present in the table.​

To convert a table to fourth normal form,split the third normal form table into separate tables,each containing the column that ____ the others.​

A column is a nonkey column if it is ____.​

Second normal form represents an improvement over ____________________ normal form.​

An alternate key is a ____.​

Which of the followingcontains a repeating group?​

​A table that contains a repeating group is called a(n) ____.

The conversion of an unnormalized table to first normal form requires the removal of ____.​

A table is in first normal form if it does not contain ____.​

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.​

​A table is in fourth normal form when it is in third normal form and there are no ____.