Question 1

Columns in a table often are called fields or _____.

Accepted Answer

A)  attributes 
B)  lines 
C)  relations 
D)  tuples 
A)  attributes 
B)  lines 
C)  relations 
D)  tuples

Question 2

Match between columns
                        Premises: Association between entities.

Accepted Answer

The Answer of nonkey and primary key and normalization and is...

Question 3

A(n) ____________________ is like a noun: It is a person, place, thing, or event.

Accepted Answer

The answer of A(n) ____________________ is like a noun: It...

Question 4

The process of determining the particular tables and fields that will make up a database is known as ____________________.

Accepted Answer

The answer of The process of determining the particular tables...

Question 5

Match between columns
                        Premises: Alternate name for a row in a table.

Accepted Answer

The Answer of nonkey and tuple and attribute and relationship is...

Question 6

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

Accepted Answer

A) True 
 B)False

Question 7

A(n) _____ key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

A)  alternate 
B)  foreign 
C)  candidate 
D)  relational 
A)  alternate 
B)  foreign 
C)  candidate 
D)  relational

Question 8

Modified Multiple Choice ____ are update anomalies.

Accepted Answer

A)  Update 
B)  Inconsistent data 
C)  Additions 
D)  Deletions 
A)  Update 
B)  Inconsistent data 
C)  Additions 
D)  Deletions

Question 9

A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.

Accepted Answer

A) True 
 B)False

Question 10

Critical Thinking Questions Case 11-1 One of the employees at Regional Books is attempting to use the normalization process in the design of the database. She has created the following unnormalized table: Book ( ISBN , Title, PublisherCode, PublisherName, (AuthorNum, AuthorLast, AuthorFirst)) How can she convert this unnormalized table to a table in first normal form?

Accepted Answer

To convert this unnormalized t

Question 11

Any field or collection of fields that determines another field is called a(n) _____.

Accepted Answer

A)  attribute 
B)  antipode 
C)  determinant 
D)  descendent 
A)  attribute 
B)  antipode 
C)  determinant 
D)  descendent

Question 12

The _____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

Accepted Answer

A)  alternate 
B)  index 
C)  secondary 
D)  primary 
A)  alternate 
B)  index 
C)  secondary 
D)  primary

Question 13

Relationships are implemented through matching fields.

Accepted Answer

A) True 
 B)False

Question 14

A field is a dependent field if it is not part of the primary key.

Accepted Answer

A) True 
 B)False

Question 15

Critical Thinking Questions Case 11-2 An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publisher Code, PublisherName) How can she convert this table to a table in 3NF?

Accepted Answer

For each determinant that is not a candi

Question 16

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.

Accepted Answer

A)  redundant 
B)  duplicate 
C)  1NF 
D)  unnormalized 
A)  redundant 
B)  duplicate 
C)  1NF 
D)  unnormalized

Question 17

In a relation, the order of columns is immaterial.

Accepted Answer

A) True 
 B)False

Question 18

In Access, the terms record and field are used to describe rows and columns in a relation.

Accepted Answer

A) True 
 B)False

Question 19

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.

Accepted Answer

A)  updated 
B)  unique 
C)  normalized 
D)  non-descript 
A)  updated 
B)  unique 
C)  normalized 
D)  non-descript

Question 20

A foreign key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

A) True 
 B)False

Columns in a table often are called fields or _____.

A(n) ____________________ is like a noun: It is a person, place, thing, or event.

The process of determining the particular tables and fields that will make up a database is known as ____________________.

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

A(n) _____ key is a field in one table whose values are required to match the primary key of another table.

Modified Multiple Choice ____ are update anomalies.

A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.

Any field or collection of fields that determines another field is called a(n) _____.

The _____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

Relationships are implemented through matching fields.

A field is a dependent field if it is not part of the primary key.

Critical Thinking Questions Case 11-2 An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publisher Code, PublisherName) How can she convert this table to a table in 3NF?

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.

In a relation, the order of columns is immaterial.

In Access, the terms record and field are used to describe rows and columns in a relation.

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.

A foreign key is a field in one table whose values are required to match the primary key of another table.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Filters

Exam 12: Database Design

Columns in a table often are called fields or _____.

A(n) ____________________ is like a noun: It is a person, place, thing, or event.

The process of determining the particular tables and fields that will make up a database is known as ____________________.

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

A(n) _____ key is a field in one table whose values are required to match the primary key of another table.

Modified Multiple Choice ____ are update anomalies.

A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.

Any field or collection of fields that determines another field is called a(n) _____.

The _____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

Relationships are implemented through matching fields.

A field is a dependent field if it is not part of the primary key.

Critical Thinking Questions Case 11-2 An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publisher Code, PublisherName) How can she convert this table to a table in 3NF?

The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.

In a relation, the order of columns is immaterial.

In Access, the terms record and field are used to describe rows and columns in a relation.

The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.

A foreign key is a field in one table whose values are required to match the primary key of another table.

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Filters