Exam 11: Behind the Scenes: Databases and Information Systems

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

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.

________ is used to ensure that data is organized most efficiently in a database.

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

You can set a ________, which is automatically displayed in a field unless the user enters something different.

You would use a ________ in a database to temporarily display records of residents for the city of Boston.

In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.

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.

Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.

The information in a data mart spans an entire enterprise.

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Data ________ helps to ensure data integrity by maintaining information in only one place.

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

A group of related records is called a table.

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

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

________ databases are the most commonly used electronic databases.