Exam 5: Database Systems and Applications

A(n) ______ is an individual who is expected to have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

To use the database approach to data management, no additional software is required.

_____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.

A database administrator is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

The smallest piece of data used by a computer is a(n) _____.

A(n) _____ is a diagram of entities and their relationships.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

The _____ model has become the most popular database model.

In the context of relational database model, projecting involves eliminating columns in a table.

One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

The position of a _____ is a nontechnical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

When organizing a database, one of the key considerations includes determining who will have access to the collected data.

A data warehouse stores historical data that has been extracted from operational systems and external sources.

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

A _____ is a description that involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

Online analytical processing involves the automated discovery of patterns and relationships in a data warehouse.

A database management system (DBMS) serves as an interface between an application program and a database.

The specific value of an attribute is called a data entity.