Exam 8: Data Structures and CAATTs for Data Extraction

When a large portion of the file is to be processed in one operation such as payroll,sequential data structures are an inefficient method of organizing a file.

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

In a hashing structure,

A user view

Explain the basic results that come from the restrict,project,and join functions.

A table is in second normal form when it is

VSAM file structures are most effective where rapid access to individual records is a priority need.

The two fundamental components of data structures are organization and access method.

The hierarchical database model forces users to navigate between data elements using predefined structured paths.

What is repeating group data?

What is the update anomaly?

The database approach to data management is sometimes called the flat file approach.

What are the two fundamental components of data structures?

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

What are the characteristics of a properly designed relational database table?

What is an embedded audit module?

Pointers are used

Explain the three types of anomalies associated with database tables that have not been normalized.

A network model does not allow children files to have multiple parent files.

The physical database is an abstract representation of the database.