Exam 11: Behind the Scenes: Databases and Information Systems

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

The information in a data mart spans an entire enterprise.

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.

In large organizations, a database administrator is responsible for designing, constructing, and maintaining the company's databases.

A business that updates its records all at once at the end of the business day uses ________ processing.

________ systems are used mostly at the executive level to improve business decision making with databases and other fact-based support systems.

________ is used to analyze large amounts of data and identify unseen patterns or trends.

A large-scale collection of data that consolidates data from various operational systems is known as a(n)________.

________ is the process of ensuring that the data entered into a field meets specified guidelines.

In a database, a text field capable of holding complete paragraphs has a ________ data type.

Small slices of a data mart are called data warehouses.

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.

In Microsoft Access, when you have the field name FirstName display as First Name, you are changing what field property?

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

Referential integrity means that for each value in the ________ field of a table, there is a corresponding value in the primary key of the related table.

Primary keys must be numbers that already represent something (like a telephone number.)

A(n) ________ report provides a consolidated picture of detailed data and usually includes some calculation or visual displays of information and is generated by a MIS.

A street address field is an example of a field that should have a default value.