Exam 9: Data Management Layer Design

Joanne, a systems analyst trained at this university, has been asked to lead a team that will recommend a new data storage system for her company. After careful analysis of the five divisions that comprise the entire $35 million company, Joanne's team should recommend a end-user database management system.

In an object-oriented database, an extent is the equivalent to a(n) _____ in a relational database.

Denormalization of a data model reduces the number of joins that must be performed in a query, which increases the speed of data access.

_________ is primarily designed for supporting the decision making systems.

An object-relational database is used primarily to support multimedia applications.

A file that stores information on who, when, and how data was altered is an audit file.

Nicole and her team of skillful systems analysts have been hired to create a database system for an educational software package that supports the study of medicine and the human body. A sample application will include a narrative exploration and graphical "tour" of the heart. As part of Nicole's team, the type of database that you would you recommend is a relational database.

What is the concept of referential integrity? Why is it important in databases?

In terms of storage space, the most efficient tables in a relational database have redundant data and many null values.

A relational database may be optimized for _____.

Optimization is a process whereby a series of rules are applied to a logical data model to determine how well-formed it is; these rules help analysts identify entities that are not represented correctly.

Which one in the following list is an example of NOSQL data store .

The data stores that are described as NoSQL typically support SQL.

SQL operates on _____.

Update anomalies occur when some instances of redundantly stored data are overlooked when an update occurs.

A(n) _____ occurs when data are stored redundantly in a database and only some of the instances are updated when a change is needed.

A mini-table that contains values from one or more columns in a table and the location of the values within the table is called a(n) _____.

The process of ensuring that values linking tables together through the primary and foreign keys are valid and correctly synchronized is _____.

Mapping between the problem domain objects and an OODBMS is a straightforward one-to-one mapping.

Key-value data stores essentially provide a distributed index (primary key) to where a(n) __________________ is stored.