Exam 9: Data Management Layer Design

The process of adding redundancy back into a physical data model is known as denormalization.

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.

The Relational DBMS only supports simple data types, but the Object Relational DBMS supports both simple and complex data types.

Sequential access files are very efficient for operations such as report writing.

Explain the term Volumetrics.

A transaction file is primarily used to update a master file.

Normalization is a process that applies a series of rules to a logical data model to determine how well the model is formed.

A data model that does not contain repeating fields and that the data models leads to tables containing fields that are dependent on a whole primary key is in _____ normal form.

Summarize the first three steps of the normalization process.

Explain the object persistence format type known as Object Oriented Databases.

Explain the term clustering.

It is difficult to find professionals with the necessary skill set for RDBMS.

Finding a specific object in a sequential access file is relatively easy to do.

Why should the object persistent classes be dependent on the associated problem domain classes instead of the other way around?

Clustering similar records together is one way of reducing access time.

When implementing the object persistence in an ORDBMS, what types of issues must you address?

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

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.

The leader in the database market and a system that can handle diverse data needs is the relational DBMS.

_____ is the process of estimating the amount of data that the hardware will need to support, so that the server hardware specifications are sufficient for the project's needs.