Question 1

Columns in a table often are called fields or ____________________.

Accepted Answer

The answer of Columns in a table often are called...

Question 2

A field is a(n) _____ field if it is not part of the primary key.

Accepted Answer

A)  attribute 
B)  nonkey 
C)  non-normal 
D)  alpha 
A)  attribute 
B)  nonkey 
C)  non-normal 
D)  alpha

Question 3

If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).

Accepted Answer

A) True 
 B)False

Question 4

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.

Accepted Answer

A) True 
 B)False

Question 5

The determination of database requirements is part of a process known as _____.

Accepted Answer

A)  visualization 
B)  systems analysis 
C)  normalization 
D)  outlining 
A)  visualization 
B)  systems analysis 
C)  normalization 
D)  outlining

Question 6

You always must qualify field names, even if there is no possibility of confusion.

Accepted Answer

A) True 
 B)False

Question 7

There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

Accepted Answer

A)  one-to-one 
B)  one-to-all 
C)  many-to-one 
D)  one-to-many 
A)  one-to-one 
B)  one-to-all 
C)  many-to-one 
D)  one-to-many

Question 8

Any field or collection of fields that determines another field is called a descendent.

Accepted Answer

A) True 
 B)False

Question 9

A table is in first normal form (1NF) if it does not contain repeating groups.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  record 
B)  tuple 
C)  entity 
D)  attribute 
A)  record 
B)  tuple 
C)  entity 
D)  attribute

Question 11

The definition of a relation includes four rules. What are these rules?

Accepted Answer

1. The entries in the table are single-v

Question 12

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) This table is not in 3NF. Why?

Accepted Answer

The table is not in 3NF becaus

Question 13

A(n) _____ is a collection of relations.

Accepted Answer

A)  entity 
B)  relational database 
C)  tuple 
D)  normal form 
A)  entity 
B)  relational database 
C)  tuple 
D)  normal form

Question 14

_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

Accepted Answer

A)  Redaction 
B)  Synchronization 
C)  Replication 
D)  Normalization 
A)  Redaction 
B)  Synchronization 
C)  Replication 
D)  Normalization

Question 15

Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

Accepted Answer

A)  matching 
B)  dependent 
C)  descendent 
D)  nonkey 
A)  matching 
B)  dependent 
C)  descendent 
D)  nonkey

Question 16

To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

Accepted Answer

A)  square brackets [ ] 
B)  curly braces { } 
C)  slashes / / 
D)  parentheses ( ) 
A)  square brackets [ ] 
B)  curly braces { } 
C)  slashes / / 
D)  parentheses ( )

Question 17

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. A key symbol appearing in front of a field name means the field is the ____________________ key.

Accepted Answer

The answer of   
 The accompanying figure shows...

Question 18

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

Accepted Answer

A) True 
 B)False

Question 19

If the primary key of a table contains only a single field, the table is automatically in ____________________ normal form.

Accepted Answer

The answer of If the primary key of a table...

Question 20

The formal term for a table is tuple.

Accepted Answer

A) True 
 B)False

Columns in a table often are called fields or ____________________.

A field is a(n) _____ field if it is not part of the primary key.

If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.

The determination of database requirements is part of a process known as _____.

You always must qualify field names, even if there is no possibility of confusion.

There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

Any field or collection of fields that determines another field is called a descendent.

A table is in first normal form (1NF) if it does not contain repeating groups.

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

The definition of a relation includes four rules. What are these rules?

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) This table is not in 3NF. Why?

A(n) _____ is a collection of relations.

_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. A key symbol appearing in front of a field name means the field is the ____________________ key.

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

If the primary key of a table contains only a single field, the table is automatically in ____________________ normal form.

The formal term for a table is tuple.

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 field is a(n) _____ field if it is not part of the primary key.

If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.

The determination of database requirements is part of a process known as _____.

You always must qualify field names, even if there is no possibility of confusion.

There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

Any field or collection of fields that determines another field is called a descendent.

A table is in first normal form (1NF) if it does not contain repeating groups.

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

The definition of a relation includes four rules. What are these rules?

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) This table is not in 3NF. Why?

A(n) _____ is a collection of relations.

_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. A key symbol appearing in front of a field name means the field is the ____________________ key.

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

If the primary key of a table contains only a single field, the table is automatically in ____________________ normal form.

The formal term for a table is tuple.

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