Designing a Relational Database

Question 1

What does a primary key allow a user to do in a database?

Revolt · Accepted Answer

uniquely identify a row in a table

Question 2

✔ arrowasterisk checkbox column header

Revolt · Accepted Answer

✔ arrow

Question 3

What are examples of primary keys that most likely would be used for customers in a department store database? Check all that apply.gendersblank valuesyears of birthcustomer IDsphone numberssocial security numbers

Revolt · Accepted Answer

customer IDs; phone numbers; social security numbers

Question 4

What is the purpose of the Lookup Wizard?

Revolt · Accepted Answer

to reference data from another table

Question 5

Use the drop-down menus to complete the steps to open the Lookup Wizard.

Revolt · Accepted Answer

2. Click in the column of the desired field.: Data Type; 3. Click the , and then click Lookup Wizard.: arrow

Question 6

Use the drop-down menus to complete the steps to open the Lookup Wizard.

Revolt · Accepted Answer

✔ Data Type; 2. Click in the column of the desired field.: Data Type; 3. Click the , and then click Lookup Wizard.: arrow

Question 7

What task do the referential integrity settings prevent?

Revolt · Accepted Answer

deleting a record that has related records in another table

Question 8

If the Cascade Update Related Records setting is activated, what happens when a change is made to the primary key of the primary table?

Revolt · Accepted Answer

Related records that refer to that primary key are edited to match.

Designing a Relational Database Answers

More from this Course

TRY EDGENUITY HACKS