Deck 5: Database Design 1: Normalization

Question 1

The fact that column B is functionally dependent on column A can be written as ____.​

A) ​A ® B
B) ​B ® A
C) ​A ® ® B
D) ​B ® ® A

Answer 1

A

Question 2

The definition for ____ also defines a candidate key.​

A) ​functional key
B) ​repeating group
C) ​primary key
D) ​nonkey column

Answer 2

C

Question 3

Potential problems in the design of a relational database are known as ____.​

A) ​update anomalies
B) ​select anomalies
C) ​modification anomalies
D) ​relational anomalies

Answer 3

A

Question 4

If B (an attribute)is functionally dependent on A,we can also say that ____.​

A) ​A functionally determines B
B) ​A functionally determines another attribute in the table
C) ​B functionally determines A
D) ​B does not determine any other attribute

Question 5

Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as possible.​

Question 6

The most recent definition of third normal form is referred to as the Boyce-Codd normal form.​

Question 7

The primary key in a table will be a determinant.​

Question 8

A table that is in first normal form may contain problems that will require you to restructure it.​

Question 9

Converting to third normal form always avoids the problems related to dependencies.​

Question 10

To correct update anomalies in a database,tables must be converted into various types of normal forms.​

Question 11

By splitting relations to achieve third normal form tables,you create the need to express interrelation constraints.​

Question 12

Functional dependencies can be determined by looking at sample data.​

Question 13

The ____ is a column (or collection of columns)A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property.​

A) ​functional key
B) composite key​
C) ​primary key
D) ​declared key

Question 14

If B is functionally dependent on A,you can also say that B functionally determines A.​

Question 15

​The normalization process used to convert a relation or collection of relations to an equivalent collection of third normal form tables is a crucial part of the database design process.

Question 16

Tables that are in second normal form do not contain problems.​

Question 17

In general,when converting a non-first normal form table to first normal form,the primary key will usually include the original primary key concatenated with the key to the repeating group.​

Question 18

A table that is in first normal form is better than one that is in second normal form.​

Question 19

In a dependency diagram,the arrows below the boxes indicate the normal dependencies.​

Question 20

If the primary key of a table contains only a single column,the table is automatically in first normal form.​

Question 21

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

Question 22

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

Question 23

Another name for a nonkey column is a ____.​

A) ​nonkey attribute
B) ​key attribute
C) ​nonkey row
D) ​key table

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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 )

Question 30

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

A) ​normalized relation
B) ​unnormalized relation
C) ​nominal relation
D) ​non-nominal relation

Question 31

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

Question 32

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

Question 33

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

Question 34

​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

Question 35

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

Question 36

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

A) ​nonkey column
B) ​first column or attribute
C) ​primary key
D) ​index

Question 37

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

Question 38

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

A) ​First
B) ​Second
C) ​Third
D) ​Fourth

Question 39

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

Question 40

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

A) ​alternate
B) ​candidate
C) ​functional
D) ​normal

Question 41

Discuss how candidate keys,primary key,and alternate keys are related.​

Question 42

In a table with columns A,B,and C,there is a(n)____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.​

Question 43

What is the difference between a table in first normal form and one in second normal form?​

Question 44

Describe the procedure for converting a table to the third normal form.​

Question 45

A(n)____________________ is a condition that involves two or more relations.​

Question 46

Explain what normalization is,including the goal of normalization.​

Question 47

A→→ B signifies that B is ____________________ on A.

Question 48

Any column or collection of columns that determines another column is called a(n)​

Question 49

By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.​

Question 50

Discuss what normal forms are and list the most common normal forms.​