Question 1

The E-R model (ERM)  represents entities, attributes, and _____.

Accepted Answer

A)   indexes
B)   views
C)   properties
D)   relationshipsE) None of the above
F) A) and B)

Question 2

A user view of data is _____.

Accepted Answer

A)   a table created by a particular user
B)   a report requested by users
C)   the specific data needed by a person or process for a particular task
D)   a form used for data entryE) All of the above
F) B) and C)

Question 3

Which fields should you index in a table?

Accepted Answer

A)   every field
B)   fields that are commonly used for sorting
C)   fields that contain sensitive data
D)   fields that are not part of a relationshipE) C) and D)
F) A) and B)

Question 4

Which of the following Access features provides a drop-down list of values for a field?

Accepted Answer

A)   subdatasheet
B)   lookup field
C)   subform
D)   Relationship reportE) A) and B)
F) A) and C) B

Question 5

What type of relationship do two tables have when their primary keys match?

Accepted Answer

A)   one-to-one
B)   one-to-many
C)   many-to-many
D)   many-to-oneE) B) and D)
F) A) and D)

Question 6

Which of the following is not true about one-to-many relationships?

Accepted Answer

A)   The linking field in the "one" table is always the primary key field for that table.
B)   A foreign key field cannot also be the primary key field for a particular table.
C)   The linking field must have the same name in the primary and related tables.
D)   One record in the "one" table can be linked or related to many records in the "many" table.E) A) and C)
F) A) and B)

Question 7

A(n)  _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed.

Accepted Answer

A)   alternate key
B)   combo key
C)   secondary key
D)   indexed keyE) A) and C)
F) A) and B)

Question 8

What is the purpose of an index?

Accepted Answer

A)   to show which database objects depend on each other
B)   to identify primary, secondary, and alternate keys
C)   to improve database performance when queries request a sort order for records
D)   to store unique data for each record in the tableE) A) and C)
F) A) and B)

Question 9

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

Accepted Answer

A)   creation anomalies
B)   deletion anomalies
C)   update anomalies
D)   record lockingE) B) and C)
F) B) and D)

Question 10

In Database Design Language (DBDL) , which items do you underline?

Accepted Answer

A)   table names
B)   columns that make up the foreign key
C)   data types
D)   columns that make up the primary keyE) A) and B)
F) None of the above

Question 11

Which of the following Access features does not demonstrate the power of one-to-many relationships?

Accepted Answer

A)   select queries involving related tables
B)   forms with subforms
C)   subdatasheets
D)   indexesE) A) and C)
F) B) and C)

Question 12

Information-level design is independent of any particular DBMS that the organization will ultimately use.

Accepted Answer

A) True 
 B)False

Question 13

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

Accepted Answer

A) True 
 B)False

Question 14

During which process do you typically create an entity-relationship (E-R)  diagram?

Accepted Answer

A)   physical-level design
B)   troubleshooting user views
C)   information-level design
D)   maintenanceE) B) and C)
F) A) and D) C

Question 15

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What must you change before you can reassign the DeptID field value for a particular employee in the query results? Departments (DeptID, DeptName) 
Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)

Accepted Answer

A)   Set DeptID as the primary key field in the Employees table.
B)   Add the DeptName field to the query.
C)   Remove the EmpID field from the query.
D)   Replace the DeptID field from the Departments table with the DeptID field from the Employees table.E) None of the above
F) All of the above

Question 16

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field?

Accepted Answer

A)   Indexed properties
B)   Lookup properties
C)   Foreign Key List properties
D)   Subdatasheet propertiesE) A) and B)
F) B) and C)

Question 17

An E-R diagram uses diamonds to illustrate relationships between tables.

Accepted Answer

A) True 
 B)False  False

Question 18

Describe the different types of keys illustrated in Database Design Language (DBDL) and how they are notated.

Accepted Answer

The primary key field contains unique da...

Question 19

How might you resolve an inappropriate Cartesian join?

Accepted Answer

A)   Convert the join type to a RIGHT join.
B)   Connect the two tables through a third junction table.
C)   Convert the join type to a LEFT join.
D)   Change the query to an update query.E) A) and C)
F) A) and D)

Question 20

Explain the difference between information-level design and physical-level design.

Accepted Answer

During information-level design, you lis...

Exam 6: Database Design: Relationships

The E-R model (ERM) represents entities, attributes, and _____.

Correct Answer
verified

A user view of data is _____.

Correct Answer
verified

Which fields should you index in a table?

Correct Answer
verified

Which of the following Access features provides a drop-down list of values for a field?

Correct Answer
verified
B

What type of relationship do two tables have when their primary keys match?

Correct Answer
verified

Which of the following is not true about one-to-many relationships?

Correct Answer
verified

A(n) _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed.

Correct Answer
verified

What is the purpose of an index?

Correct Answer
verified

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

Correct Answer
verified

In Database Design Language (DBDL) , which items do you underline?

Correct Answer
verified

Which of the following Access features does not demonstrate the power of one-to-many relationships?

Correct Answer
verified

Information-level design is independent of any particular DBMS that the organization will ultimately use.

Correct Answer
verified

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

Correct Answer
verified

During which process do you typically create an entity-relationship (E-R) diagram?

Correct Answer
verified
C

Correct Answer
verified

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field?

Correct Answer
verified

An E-R diagram uses diamonds to illustrate relationships between tables.

Correct Answer
verified
False

Describe the different types of keys illustrated in Database Design Language (DBDL) and how they are notated.

Correct Answer
verified
The primary key field contains unique da...
View Answer

How might you resolve an inappropriate Cartesian join?

Correct Answer
verified

Explain the difference between information-level design and physical-level design.

Correct Answer
verified
During information-level design, you lis...
View Answer

Exam 6: Database Design: Relationships

The E-R model (ERM) represents entities, attributes, and _____.

Correct AnswerverifiedShow Answer

A user view of data is _____.

Correct AnswerverifiedShow Answer

Which fields should you index in a table?

Correct AnswerverifiedShow Answer

Which of the following Access features provides a drop-down list of values for a field?

Correct AnswerverifiedB

What type of relationship do two tables have when their primary keys match?

Correct AnswerverifiedShow Answer

Which of the following is not true about one-to-many relationships?

Correct AnswerverifiedShow Answer

A(n) _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed.

Correct AnswerverifiedShow Answer

What is the purpose of an index?

Correct AnswerverifiedShow Answer

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent?

Correct AnswerverifiedShow Answer

In Database Design Language (DBDL) , which items do you underline?

Correct AnswerverifiedShow Answer

Which of the following Access features does not demonstrate the power of one-to-many relationships?

Correct AnswerverifiedShow Answer

Information-level design is independent of any particular DBMS that the organization will ultimately use.

Correct AnswerverifiedShow Answer

When the Unique property for an index is set to Yes in Access, every value in the index must be unique.

Correct AnswerverifiedShow Answer

During which process do you typically create an entity-relationship (E-R) diagram?

Correct AnswerverifiedC

Correct AnswerverifiedShow Answer

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field?

Correct AnswerverifiedShow Answer

An E-R diagram uses diamonds to illustrate relationships between tables.

Correct AnswerverifiedFalse

Describe the different types of keys illustrated in Database Design Language (DBDL) and how they are notated.

Correct AnswerverifiedThe primary key field contains unique da...View AnswerShow Answer

How might you resolve an inappropriate Cartesian join?

Correct AnswerverifiedShow Answer

Explain the difference between information-level design and physical-level design.

Correct AnswerverifiedDuring information-level design, you lis...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified
The primary key field contains unique da...
View Answer

Correct Answer
verified

Correct Answer
verified
During information-level design, you lis...
View Answer