Exam 9: Designing Databases

During physical design,you consider:

The index file organization:

________ refers to two different names that are used for the same attribute.

A ________ is the smallest unit of named application data recognized by system software.

To convert a relation to second normal form,you decompose the relation into new relations using the attributes,called:

A named two-dimensional table of data is a:

Data security can be built into a file through encryption,passwords,or prohibiting users from directly manipulating a file.

Which of the following is not a true statement regarding a relation?

Normalization helps build a data model that is simple,not redundant,and requires minimum maintenance.

Merging relations is also referred to as:

________ is a single attribute name that is used for two or more different attributes.

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

Random key retrieval on the primary key is comparatively slow with the hashed file organization.

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

A ________ is one or a combination of fields for which more than one row may have the same combination of values.

"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?

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

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

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.

An attribute can be functionally dependent on more than attribute.