Exam 9: Designing Databases

In range partitioning,a table row is assigned to a partition by an algorithm and then maps the specified attribute value to a partition.

What is a relational database model? How do relations differ from nonrelation tables?

A null value is the value a field will assume unless an explicit value is entered for the field.

In a relation,the sequence of columns can be interchanged without changing the meaning or use of the ________.

A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key.

Describe how a binary one-to-one relationship is represented.

What are the four key steps to logical database modeling and design?

The key should be ________; that is,no attribute in the key can be deleted without destroying its unique identification.

A default value is the value that a ________ will assume unless an explicit value is entered for it.

________ is NOT a valid type of partitioning method in relational database products.

A ________ value is a special field value,distinct from a zero,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown.

A calculated field is a field that can be derived from other database fields and is also known as a computed field or a derived field.

De-normalization can increase the chance of errors and inconsistencies that normalization avoided.

Each regular entity type in an E-R diagram is transformed into a(n)________.

Describe normalization rules.

Describe at least three E-R structures and their relational representation.

De-normalization is a process for converting complex data structures into simple,stable data structures.

In ________ normal form,non-primary key attributes do not depend on each other (what we call no transitive dependencies).

Describe the problems that may occur when integrating relations.

A(n)________ is a field of data that can be used to locate a related field or row of data.