Exam 14: Database Design

Domain integrity means that a primary key cannot take on the NULL value.

Table look-up files contain relatively static data that can be shared by applications to maintain consistency and improve performance.

The ______________________ key for a record must never be allowed to have a NULL value.

The principal sadvantage of ___________________ (conventional files or databases) is the ability to share the same data across multiple applications and systems.

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

Realistically, most organizations build several databases, each one sharing data with several information systems. Thus, there will be some ____________ between databases.

_________________________ keys are pointers to the records of a different file in a database. These keys are how the database links the records of one type to those of another type.

A data definition language (DDL) is used by the DBMS to physically establish record types, fields, and structural relationships. Additionally, the DDL defines views of the database.

DML commands may be "called" from programming languages.

Some metadata is stored in the actual database, while other metadata is stored in the CASE tool repositories.

A file that contains records that describe business events is what type of file?

Horizontal distribution of the data has specific columns of tables assigned to specific databases and servers.

When a computer program "reads" a record from a database, it actually retrieves a group or ________________________ of records at a time.

________________________________ are programs embedded within a table that are automatically invoked by updates to another table.

Many CASE tools can generate SQL code for creating a database from a CASE-based database schema.

You see a return to conventional file-based architectures today because they are better technology for client/server and network computing architectures.

One or more database administrators (DBAs) are responsible for the database technology, database design and construction consultation, security, backup and recovery, and performance tuning.

The principal advantage of database systems is the ability to share the same data across multiple applications and systems.

When a database is implemented on a single server regardless of the number of physical locations that may require access to it is known as:

_________________________ files or tables contain records that are relatively permanent. Thus, once a record has been added, it remains in the system indefinitely. The values of fields for the record will change over its lifetime, but the individual records are retained indefinitely.