Exam 9: Designing Databases

Each partition is stored in a separate contiguous section of disk space,which Oracle calls a(n)________.

When merging relations that contain synonyms,we should obtain,if possible,agreement from users on a single standardized name for the attribute and eliminate the other synonym.

Normalized relations are,of course,the result of ________ database design.

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

What information is required to design the physical files and databases related to the project?

In a ________ database model,data is represented as a set of related tables or relations.

In ________ normal form,each non-primary key attribute is identified by the whole key (what we call full functional dependency).

________ is NOT a valid degree of the relationship.

The ________ families of file organizations cover most of the file organizations we will have at our disposal as we design physical files and databases.

There are ________ key steps in logical database modeling and design.

What is file organization? How does a database designer choose a type of file organization for a specific file?

A null value is a special field value,similar to a zero,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown.

In logical database modeling and design,we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.

A functional dependency is a particular relationship between two ________.

Each ________ of a relation corresponds to a record that contains data values for an entity.

In an object oriented database model,data is represented as a set of related tables or relations.

Which relation is created with a composite primary key using the primary keys of the related entities,plus any non-key attributes associative entity of the relationship or associative entity?

A functional dependency between ________ key attributes is also called a transitive dependency.

In logical database modeling and design,we translate the ________ E-R data model for the application or enterprise,developed without explicit consideration of specific user interfaces,into normalized data requirements.

Describe the three families of file organization.