Exam 11: Behind the Scenes: Databases and Information Systems

A summary report generated by an MIS provides a list of the transactions that occurred during a specified time period.

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

Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.

A filter is limited to extracting data from a single table.

Employees' last name would usually make an appropriate primary key field.

A(n) ________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

A(n) ________ database stores data in more than two dimensions, as opposed to relational databases, which store data in two-dimensional tables.

A group of related records is called a(n) ________.

A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.

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

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.

Data redundancy ensures that the data contained in the database is accurate and reliable.

Data ________ means that the data contained in a database is accurate and reliable.

Big data analytics is usually associated with ________ services.

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.