Exam 9: Designing Databases

Match each of the following terms with its corresponding definition. -A data model that represents data as a set of related tables or relations.

A relation is said to be in second normal form if the primary key consists of only one attribute.

How is a binary one-to-one relationship represented?

Generally speaking,a physical table corresponds to a relation.

For a binary many-to-many relationship existing between entity types A and B:

The process of converting complex data structures into simple,stable data structures is referred to as:

Using relational notation,an attribute of a relation that is the primary key of another relation is indicated by:

The __________ uses an algorithm to determine the address for each row.

__________ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

During logic modeling,the normalized data requirements from all user interfaces are combined into one consolidated logical database model.

The result of normalization is that every nonprimary key attribute depends upon the whole primary key and nothing but the primary key.

Match each of the following terms with its corresponding definition. -An integrity constraint that specifies that the value (or existence)of an attribute in one relation depends on the value (or existence)of the same attribute in another relation.

Referencing a relation,the sequence of columns cannot be interchanged without changing the meaning or use of the relation.

Which of the following combines range and hash partitioning by first segregating data by ranges on the designated attribute and then within each of these partitions it further partitions by hashing on the designated attribute?

Match each of the following terms with its corresponding definition. -A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows in a table without errors or inconsistencies.

Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications.

Two different names that refer to the same data item best defines:

What are the four key physical database design decisions you will make?

Match each of the following terms with its corresponding definition. -A foreign key in a relation that references the primary key values of that same relation.

Match each of the following terms with its corresponding definition. -The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.