Question 1

A table that contains a repeating group, or multiple entries for a single row, is called a(n) _____ table.

Accepted Answer

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

Question 2

Match between columns
                        Premises: A person, place, thing, or event.

Accepted Answer

The Answer of attribute and nonkey and field and determinant is...

Question 3

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

Accepted Answer

A) True 
 B)False

Question 4

A table is in ____________________ normal form if it does not contain any repeating groups.

Accepted Answer

The answer of A table is in ____________________ normal form...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.

Accepted Answer

A) True 
 B)False

Question 7

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. Another popular option for diagramming a database design is the ____________________ diagram.

Accepted Answer

The answer of   
 The accompanying figure shows...

Question 8

You can use an entity-relationship diagram (ERD) to diagram a database design.

Accepted Answer

A) True 
 B)False

Question 9

Rows in a table often are called records.

Accepted Answer

A) True 
 B)False

Question 10

A(n) _____ is a collection of tables.

Accepted Answer

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

Question 11

If Client Number _____ Client Name, then Client Name is functionally dependent on Client Number.

Accepted Answer

A)  precedes 
B)  qualifies 
C)  determines 
D)  follows 
A)  precedes 
B)  qualifies 
C)  determines 
D)  follows

Question 12

If you have already created a database and relationships in Access, the _____ window and corresponding report provide a helpful diagram of the design.

Accepted Answer

A)  Referential Integrity 
B)  Database Tools 
C)  Relationships 
D)  ERD 
A)  Referential Integrity 
B)  Database Tools 
C)  Relationships 
D)  ERD

A table that contains a repeating group, or multiple entries for a single row, is called a(n) _____ table.

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

A table is in ____________________ normal form if it does not contain any repeating groups.

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

Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. Another popular option for diagramming a database design is the ____________________ diagram.

You can use an entity-relationship diagram (ERD) to diagram a database design.

Rows in a table often are called records.

A(n) _____ is a collection of tables.

If Client Number _____ Client Name, then Client Name is functionally dependent on Client Number.

If you have already created a database and relationships in Access, the _____ window and corresponding report provide a helpful diagram of the design.

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

A table that contains a repeating group, or multiple entries for a single row, is called a(n) _____ table.

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

A table is in ____________________ normal form if it does not contain any repeating groups.

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

Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. Another popular option for diagramming a database design is the ____________________ diagram.

You can use an entity-relationship diagram (ERD) to diagram a database design.

Rows in a table often are called records.

A(n) _____ is a collection of tables.

If Client Number _____ Client Name, then Client Name is functionally dependent on Client Number.

If you have already created a database and relationships in Access, the _____ window and corresponding report provide a helpful diagram of the design.

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