Exam 6: Relational Database Design

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

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

Each column of a relational table represents a (an)

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

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

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

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

In relational database design, a low load indicates

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.

Why are redundancies in data inefficient and problematic?

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

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

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.

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.