Exam 9: Designing Databases

Summarize the four steps involved in transforming an E-R diagram into normalized relations and then merging them into one consolidated set of relations.

In a hashed file organization,the address of each ________ is determined using an algorithm.

A foreign key is an attribute (or combination of attributes)whose value is unique across all occurrences of a relation.

The procedure for representing relationships depends on both the degree of the relationship and not on the cardinalities of the relationship.

A physical table is a named set of rows and columns that specifies the fields in each column of the table.

One purpose of database design is to structure the data in stable structures,called normalized tables,that are not likely to change over time and that have minimal ________.

Which relation is created with primary key and non-key attributes only?

Which relation is created with the primary key associated with the relationship or associative entity,plus any non-key attributes of the relationship or associative entity and the primary keys of the related entities (as foreign key attributes)?

The capability to split a table into separate sections is possible with most relational database products.

What are the five purposes of data design?

________ is a process for converting complex data structures into simple,stable data structures.

Entries in cells are simple and an entry at the intersection of each row and column has a ________ value.

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

We begin the physical design phase by addressing the design of physical fields for each attribute in a ________ data model.

A binary one-to-many (1:N)relationship in an E-R diagram is represented by adding the primary key attribute (or attributes)of the entity on the one side of the relationship as a(n)________ in the relation that is on the many side of the relationship.

In a range control,only alphabetic data may have a limited set of permissible values.

A relation is a named,________-dimensional table of data.Each relation (or table)consists of a set of named columns and an arbitrary number of unnamed rows.

During logical database design,you must account for every data element on a system input or output form or report and on the ________.

In logical database design,we use a process called ________,which is a way to build a data model that has the properties of simplicity,non-redundancy,and minimal maintenance.

An unstructured relation is a relation that contains a minimum amount of redundancy and that allows users to insert,modify,and delete the rows without error or inconsistencies.