Question 1

Discuss the overall process of normalization as it relates to anomalies and list the most common normal forms.

Accepted Answer

The answer of Discuss the overall process of normalization as...

Question 2

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

Accepted Answer

A) Clients (ClientID, ClientFirst, ClientLast, ProjectID, ProjectType) 
B) Departments (DeptID, DeptName) 
C) Products (ProductID, CategoryID, ProductName, UnitPrice) 
D) Classes (ClassID, ClassName, ClassDate, StartTime, EndTime, ClassPrice)

Question 3

What do you call a table that contains a repeating group?

Accepted Answer

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

Question 4

Which of the following tables is most likely a lookup table?

Accepted Answer

A) Students (StudentID, StudentFirst, StudentLast) 
B) Specialties (Specialty) 
C) Vehicles (VehicleID, VehicleType, VehicleMake, VehicleModel) 
D) Orders (OrderID, OrderDate)

Question 5

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

Accepted Answer

A) It contains no repeating groups. 
B) It has at least two foreign keys. 
C) It doesn't have a primary key 
D) It has no candidate keys.

Question 6

Which Access function returns the position of the space character in a field?

Accepted Answer

A) InStr 
B) Space 
C) Len 
D) Null

Question 7

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

Accepted Answer

A) Functional dependence 
B) Online analytical processing 
C) Structural modification 
D) Normalization

Question 8

A table is in second normal form when it is in first normal form and _____.

Accepted Answer

A) each nonkey column is dependent on the entire primary key field 
B) it contains candidate keys 
C) it allows no data modification anomalies 
D) it contains at least one foreign key field

Question 9

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

Accepted Answer

A) 1NF 
B) 2NF 
C) 3NF 
D) 4NF

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) attribute 
B) composite key 
C) atomic value 
D) tuple

Question 12

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

Accepted Answer

A) combo key 
B) nonkey field 
C) candidate key 
D) composite key

Question 13

Which of the following expressions combines the atomic values from two fields in a LastName, FirstName format in an expression in an Access query?

Accepted Answer

A) [LastName] > ", " < [FirstName] 
B) "LastName" & "FirstName" 
C) [FirstName] & " " & [LastName] 
D) [LastName] & ", " & [FirstName]

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In the following Projects table, which field is functionally dependent on the ClientID field? Projects (ProjectID, ProjectType, ProjectName, ProjectManager, Budget, ClientID)

Accepted Answer

A) ProjectID 
B) ProjectManager 
C) Budget 
D) None of the fields in the Projects table is functionally dependent on ClientID.

Question 16

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

Accepted Answer

A) update anomaly 
B) creation anomaly 
C) deletion anomaly 
D) insertion anomaly

Question 17

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

Accepted Answer

A) Data anomaly 
B) Object dependence 
C) Functional dependence 
D) Functional relationships

Question 18

Discuss how a primary key, candidate key, and composite key are related.

Accepted Answer

The answer of Discuss how a primary key, candidate key,...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

_____ describes the relationship of attributes in an entity.

Accepted Answer

A) Transitive dependency 
B) Relation anomaly 
C) Boyce-Codd normal form 
D) Functional dependence

Exam 5: Database Design: Normalization

Discuss the overall process of normalization as it relates to anomalies and list the most common normal forms.

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

What do you call a table that contains a repeating group?

Which of the following tables is most likely a lookup table?

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

Which Access function returns the position of the space character in a field?

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

A table is in second normal form when it is in first normal form and _____.

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

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.

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

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

Which of the following expressions combines the atomic values from two fields in a LastName, FirstName format in an expression in an Access query?

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

In the following Projects table, which field is functionally dependent on the ClientID field? Projects (ProjectID, ProjectType, ProjectName, ProjectManager, Budget, ClientID)

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

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

Discuss how a primary key, candidate key, and composite key are related.

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

_____ describes the relationship of attributes in an entity.