Exam 9: Designing Databases

When transforming an E-R diagram into normalized relations,the identifier of the entity type becomes:

Outline the four key steps in logical database modeling and design.

A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored,retrieved,and updated rapidly.

________ is the process of converting complex data structures into simple,stable data structures.

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

Denormalization reduces the chance of errors introduced by normalizing relations.

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?

A physical file is a named set of table rows stored in a contiguous section of secondary memory.

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

During logical database design,the work of all systems development team members is coordinated and shared through:

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

Efficient use of secondary storage and data processing speed are two goals of physical table design.

You have recently been hired by an appliance repair company.Your first task is to normalize the following relation.

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

Sequential retrieval on the primary key is very fast with the hashed file organization.

A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete rows without errors or inconsistencies is a(n):

Briefly identify the three file organizations.

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

________ is a technique for physically arranging the records of a file.

Multiple key retrieval is possible with the hashed file organization.