Exam 15: Normalize a Database for Effective Design

Explore all topics

A key can be a(n)________ key that is nonnaturally occurring data that is visible to the user,such as sequential numbering from the AutoNumber data type.

(Short Answer)

4.9/5

(23)

Question 41

A surrogate key is not visible to the user.

(True/False)

4.8/5

(38)

Question 42

The ________ normal form is the level that a table satisfies along with all levels below.

(Short Answer)

4.9/5

(41)

Question 43

A(n)________ key that is created from naturally occurring data generated outside of a database such as a driver's license number.

(Short Answer)

4.9/5

(34)

Question 44

Candidate keys that are used for the primary key are alternate keys.

(True/False)

4.9/5

(23)

Question 45

A product can be in many different orders.Also,each order can have many products in inventory.This is an example of a(n)________ relationship.

(Short Answer)

4.9/5

(35)

Question 46

In an ERD,the ________ approach will list the tables in a database as rectangles with lines and symbols representing the types of relationships between them.

(Multiple Choice)

4.9/5

(30)

Question 47

A(n)________ forces you to enter data about two different entities when you have only data on only one entity.

(Short Answer)

4.7/5

(35)

Question 48

________ are rules added to a database to help ensure the data's validity.

(Short Answer)

4.8/5

(36)

Question 49

Which of the following is NOT true regarding first normal form?

(Multiple Choice)

4.8/5

(31)

Question 50

A(n)________ is when the field only depends on one part of a composite or concatenated key.

(Multiple Choice)

4.9/5

(45)

Question 51

A product can be in many different orders.Also,each order can have many products in inventory.This is an example of a M:N relationship.

(True/False)

4.8/5

(40)

Question 52

Atomicity refers to unmatched or missing data that is caused by limitations in database design.

(True/False)

4.9/5

(35)

Question 53

________ are unmatched or missing data that is caused by limitations in database design.

(Short Answer)

4.8/5

(33)

Question 54

A(n)________ key is created from nonnaturally occurring data that is visible to the user,such as sequential numbering from the AutoNumber data type.

(Multiple Choice)

4.9/5

(32)

Question 55

In a small business,a department might be managed by no more than one manager,and each manager manages no more than one department.This is an example of a(n)________ relationship.

(Short Answer)

4.8/5

(32)

Question 56

The ________ requires that the table has to be free of transitive dependencies and that all lower levels of NF are satisfied.

(Multiple Choice)

4.9/5

(35)

Question 57

A key can be a(n)________ key which is nonnaturally occurring data that is not visible to the user.

(Short Answer)

5.0/5

(38)

Question 58

________ are frequently shown in a functional dependency diagram.

(Multiple Choice)

4.9/5

(34)

Question 59

Which of the following is NOT true about identifying the entities in an ERD?

(Multiple Choice)

4.8/5

(39)

Question 60

Showing 41 - 60 of 89

A key can be a(n)________ key that is nonnaturally occurring data that is visible to the user,such as sequential numbering from the AutoNumber data type.

A surrogate key is not visible to the user.

The ________ normal form is the level that a table satisfies along with all levels below.

A(n)________ key that is created from naturally occurring data generated outside of a database such as a driver's license number.

Candidate keys that are used for the primary key are alternate keys.

A product can be in many different orders.Also,each order can have many products in inventory.This is an example of a(n)________ relationship.

In an ERD,the ________ approach will list the tables in a database as rectangles with lines and symbols representing the types of relationships between them.

A(n)________ forces you to enter data about two different entities when you have only data on only one entity.

________ are rules added to a database to help ensure the data's validity.

Which of the following is NOT true regarding first normal form?

A(n)________ is when the field only depends on one part of a composite or concatenated key.

A product can be in many different orders.Also,each order can have many products in inventory.This is an example of a M:N relationship.

Atomicity refers to unmatched or missing data that is caused by limitations in database design.

________ are unmatched or missing data that is caused by limitations in database design.

A(n)________ key is created from nonnaturally occurring data that is visible to the user,such as sequential numbering from the AutoNumber data type.

In a small business,a department might be managed by no more than one manager,and each manager manages no more than one department.This is an example of a(n)________ relationship.

The ________ requires that the table has to be free of transitive dependencies and that all lower levels of NF are satisfied.

A key can be a(n)________ key which is nonnaturally occurring data that is not visible to the user.

________ are frequently shown in a functional dependency diagram.

Which of the following is NOT true about identifying the entities in an ERD?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters