CIS 372- Chapter 5

Which normal form has an additional condition that excludes transitive dependencies

3NF

Which normal form has additional conditions that further remove data redundancies and eliminate data modification anomalies beyond the Boyce-Codd normal form

4NF

What is a nonkey column

A column that is not part of the primary key

Which of the following is an example of an insertion anomaly

A new student cannot be assigned to a professor because the student does not have a StudentID

Third normal form is also often referred to as

Boyce-Codd normal form

Which of the following tables should be converted to third normal form

Clients (ClientID, ClientFirst, ClientLast, ProjectID, ProjectType)

An employee field with an employee's full name contains an atomic value

False

Functional dependence refers to how tables are related to each other in a database

False

The normalization process is a series of steps built into most relational database management software products that will automatically restructure your database to resolve all design flaws

False

_____ refers to how attributes (fields) depend on or relate to other attributes in a relation (table)

Functional Dependence

A(n) _____ results if you cannot add data to the database due to absence of other data

Insertion anamoly

What is the foreign key in the following table

InstructorNum

Which of the following statements describes a table in first normal form

It contains no repeating groups

What is the problem with designing a database in which the last name of an employee functionally determines the employee's address

More than one employee could have the same last name

In the following Projects table, which field is functionally dependent on the ClientID field

None of the fields in the Projects table is functionally dependent on ClientID

____ follows a series of steps to break columns into smaller tables to identify entities and facts about each entity

Normalization

How do you free data from the problems associated with insertion, update, and deletion anomalies

Normalize the data by converting a single list into multiple tables

Which of the following tables should be converted to second normal form

Players(PlayerID, PlayerFirst, PlayerLast, CoachID, CoachFirst, CoachLast, Team)

Which of the following tables is most likely a lookup table

Specialties (Specialty)

Which of the following is a benefit of having atomic values in each column of a table

The data is easier to sort, find, and filter

A table is in first normal form when it does not contain repeating groups, each column contains atomic values, and there are no duplicate records

True

The primary key can be a composite key, which is a combination of two or more fields

True

What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls

Update anomaly

A(n) ____ is a piece of data that cannot be meaningfully divided

atomic value

What do you call each key that meets the criteria for a primary key

candidate key

When the primary key field consists of a combination of two or more fields, it is called a

composite key

A table is in second normal form when it is in first normal form and ___

each nonkey column is dependent on the entire primary key field

A table with no repeating groups in any attribute and atomic values in each column is, at a minimum, in what normal form

first normal form

A(n) ____ helps constrain the values in a single field to a specific list, which eliminates update anomalies

lookup table

What is a major goal of normalization

minimizing redundant data

Which type of table is an excellent candidate for improvement to second normal form

table with a multifield primary key field

The nonkey fields of a table should be functionally dependent on ____

the primary key field

A(n) ___ occurs if a nonkey attribute determines another nonkey attribute

transitive dependency