Exam 14: Database Design

_________________________________ implement data in a series of two-dimensional tables that are "related" to one another via foreign keys. Each table consists of named columns (which are fields or attributes) and any number of unnamed rows (which correspond to records).

Which of the following is the smallest unit of data stored?

Given the large capacity disks that are now available, database administrators no longer have to be concerned about estimating how much disk capacity is required for a new database.

Both triggers and stored procedures are reusable because they are stored with the tables themselves as_____________________.

The person responsible for the database technology, database design and construction consultation, security, backup and recovery, and performance tuning is known as a(n):

__________________________________ databases are developed to support day-to-day operations and business transaction processing for major information systems.

Database technology provides superior scalability, meaning that the database and the systems that use it can be grown or expanded to meet the changing needs of an organization.

Many information systems shops hesitate to give end-users access to operational databases for queries and reports. The volume of unscheduled reports and queries could overload the computers and hamper business operations that the databases were intended to support. That is why ___________________________________ are developed, possibly on separate computers to provide for end-users reports and queries.

Key integrity for a database means that every table should have a primary key.

Triggers are programs embedded within a table that can be called from an application program.

The number of logical records included in a single read or write operation from the computer's perspective is known as the:

____________________________ integrity means that appropriate controls must be designed to ensure that no field takes on a value that is outside the range of legal values.

A blocking factor allows different records in the same file to have different lengths.

Data distribution analysis establishes which business locations need access to which logical data entities and attributes.

Files tend to be built around single applications without regard to other, future applications.

A database that stores data extracted from operational databases for the purpose of data mining is called a(n):

Operational databases and conventional files store data extracted from data warehouses.

A data administrator is responsible for the data planning, definition, architecture, and management.

A business's ____________________ architecture defines how that business will develop and use both files and databases to store all of the organization's data, the file and database technology to be used, and the administrative structure set up to manage the data resource.

Files or tables that contain records that describe business events are known as: