Exam 5: Data Resource Management

Data models represent _______________ views of the data and relationships of the database.

Databases contain data elements that describe both entities and the _______________ among entities.

A(n) _______________ is an integrated collection of logically related data elements.

Boolean logic was developed during the latter part of the 1900s.

A weakness in the network model is that it cannot handle _______________ for information.

From a logical point of view, a(n) _______________ is the smallest data element that can be observed and manipulated.

Database management packages based on the relational model can link data elements from various tables to provide information to users.

_______________ relationship diagrams are used to model the relationships among the many entities involved in business processes.

All of the following are major functions of a database management system except:

The tables in a relational database are flat files which have rows and columns. Each column represents a _______________ in the file.

Boolean logic consists of three logical operators: AND, OR, and _______________.

In file processing systems, it was easy for data elements, such as stock numbers and customer addresses, to be defined differently by different end users and applications.

_______________ contain both a variable number of fields and variable field lengths.

Database management involves the use of database management software to control how databases are _______________.

In a(n) _______________ database structure, all of the relationships among records are one-to-many, because each data element is related to only one element above it.

A website stores hyperlinked pages of multimedia (text, graphics, photographs, video, and audio) in a _______________ database.

Relational databases are more difficult for programmers to work with and more difficult to maintain than the hierarchical and network models.

The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file.

When independent of any other files related to it, a single table is referred to as a compressed file.