Chapter 10 Study Questions

Question 1

A table in a relational database represents an object or ______.

Answer 1

entity

Question 2

Within each table, each column stores one item of information or _________.

Answer 2

attribute

Question 3

Each table row stores one occurrence, or ________, of the entity.

Answer 3

instance

Question 4

The _______ key for a table uniquely identifies each row. It should be persistent and minimal.

Answer 4

primary

Question 5

To implement a one-to-many relationship between tables, add a _______ key on the “many” side.

Answer 5

foreign

Question 6

A many-to-many relationship between two tables is implemented with a _______ table.

Answer 6

linking table

Question 7

___________ _________ means that the relationships between tables are maintained correctly (i.e. a table with foreign key values have matching key vales in the related table).

Answer 7

Referential integrity

Question 8

If referential integrity is not enforced and a row is deleted from the primary key (or parent) table that has related rows in the foreign key table are said to be ________.

Answer 8

orphaned

Question 9

_____________ is a formal process used to separate data in a data structure into separate tables. The purpose of this process is to reduce data redundancy.

Answer 9

Normalization

Question 10

With an ____________ data structure, a table can contain information about two or more entities, repeating columns, and data that is repeated in two or more rows.

Answer 10

unnormalized

Question 11

In a __________ ____ _________, each table contains information about a single entity, and each piece of information is stored in exactly one place.

Answer 11

normalized data structure

Question 12

To normalize a data structure, apply the ______ _____ in sequence.

Answer 12

normal forms

Question 13

An _____ is a structure that provides for locating one or more rows directly.

Answer 13

index

Question 14

Without an index, a database management system has to perform a _____ ____ which involves searching through the entire table.

Answer 14

table scan

Question 15

A _________ index consists of two or more columns.

Answer 15

composite

Question 16

When normalizing a data structure, if the value stored at the intersection of each row and column is a scalar variable, and there are no repeating columns, the relation is in _____ ______ ____.

Answer 16

first normal form

Question 17

The normal form where every non-key column is dependent on the entire primary key is termed ______ ______ ____.

Answer 17

second normal form

Question 18

If every non-key column is dependent only on primary key, that is a non-key column is not a determinant, the relation is in _____ ______ ____.

Answer 18

third normal form

Question 19

When normalized into ______-___ or _____ ______ ____, every constraint on the relationship is dependent only on key constraints and domain constraints.

Answer 19

domain-key or sixth normal form

Question 20

A ______ is the set of allowable values for a column.

Answer 20

domain