FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Relational Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Essay

Review LaterAdd Note

Review Later

Why are redundancies in data inefficient and problematic?

Correct Answer

verified

Data redundancies create data ...

View Answer

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

Efficient database design avoids null values as much as possible and uses the least amount of tables.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

In Microsoft Access, does enabling cascade updates cause data entry of primary key values for new records to be automatically posted to the related foreign key fields? Explain your response.

Explain the relational logical structure that is used in relational databases.

Relationships may have attributes; these attributes should be attached to the relationship on an entity-relationship diagram or listed in the relationship section of an entity-relationship grammar.

A physical database model is independent of any particular database software.

Each column of a relational table represents a (an)

A conceptual database model is independent of any particular database software package.

Given the following relationship layout from Microsoft Access, which set of tables has data that is consistent with referential integrity?

Rows in a relational database structure are also called ______ ______, ________ or ________.

A primary key in Microsoft Access can only contain one field.

All About Pets needs to track information about quantities of inventory items sold in various sales transactions. For example, the enterprise needs to know 5 cans of puppy food, 1 leash, 2 sacks of kitty litter, and 4 cans of kitten food were sold in Sale 17. The most appropriate assignment for the quantity sold attribute is to the relationship between inventory type and sale.

The following pet table is a good example of a relational table.

In relational database design, a low load indicates