Exam 11: Behind the Scenes: Databases and Information Systems

When using Access, the text of the Gettysburg Address would be stored in a short text field.

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

A database schema defines the name, data type, and length of each field in the database.

In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.

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

A ________ check would be used to restrict the fines for speeding violations from $50 to $250.

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

A ________ displays a subset of data from a table (or tables) based on the specified criteria.

________ involves putting data into an electronic file in a format that another application can recognize.

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

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

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

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.

A(n) ________ tries to replicate the decision-making processes of human experts to solve specific problems.

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

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 ________.

When working with a relational data base, each record must have a(n) ________ key field, which has a value unique to that record.

A database that allows data to be maintained in a single location provides data ________.

________ databases are better at handling unstructured data such as audio clips, video clips, and pictures.

In a Microsoft Access database, an active web address is stored as a(n) ________ field in a database.