Exam 14: Database Design

A field is the physical implementation of a data attribute. Fields are the smallest unit of meaningful data to be stored in a file or database.

A program that is embedded within a relational database table that can be called from an application program is known as a(n):

The relational database equivalent of a file is known as a(n):

_________________________________ is the data about the data, such as record and field definitions, synonyms, data relationships, validation rules, help messages, etc.

____________________________________________ refers to the database technology including the database engine, database utilities, database CASE tools for analysis and design, and database application development tools.

_________________________________ of data offers performance and accessibility advantages and reduces network traffic, but it also increases the complexity of data integrity and requires more physical storage.

_________________________ is a resource that must be controlled and managed!

_______________________________ is the simplest and easiest solution to maintain; however, it violates a data management rule that has become important to many data administrators and users - data should be located as closely as possible to its users.

Relational databases implement data in a series of two-dimensional tables that are "related" to one another via foreign keys.

DDL stands for which of the following:

Data warehouses store data extracted from the operational databases and conventional files.

The person responsible for the database technology, database design and construction, security, backup and recovery, and performance tuning is the:

_________________________ files or tables contain records that describe business events. The data describing these events normally has a limited useful lifetime. Subsequent to their useful lifetime, they are archived off-line.

The foreign key value in one table must have a matching primary key value in the related table. This refers to:

Which language is used by the DBMS to physically establish those record types, fields, and structural relationships in a relational database?

A good data model is_______________________. As a general rule, the data attributes that describe an entity should describe only that entity.

A disadvantage of database technology is the lack of flexibility in data storage formats.

A domain integrity error exists when a foreign key value in one table has no matching primary key value in the related table.

A(n) ________________________________ is an alternate name for a foreign key that clearly distinguishes the purpose that foreign key serves in the table.

An historical advantage of using conventional files has been processing speed. They can be optimized for the access of the application.