Exam 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing

With a(n) ____________________, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

In the ASCII coding scheme, each byte represents a single ____________________, which can be a number, letter, space, punctuation mark, or other symbol.

Data integrity is important because computers and people use information to make decisions and take actions.

To reduce data entry errors, well-designed forms should validate data as it is entered.

A user of a database such as that pictured in the accompanying figure refers to a field as what?

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a record?

DBMSs that maintain inactive data for an extended period of time seldom flag records.

COGNITIVE ASSESSMENT Your database was damaged due to hardware failure. What can you use to restore it?

COGNITIVE ASSESSMENT Which recovery technique is more expensive, but provides recovery of damaged data in a matter of seconds?

Critical Thinking Questions Case 11-2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?

Which of the following is true in a relational database?

COGNITIVE ASSESSMENT What is the process that large databases use to find patterns and relationships among data?

Discuss at least four strengths of the database approach.

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

DBMSs will process flagged records unless an instruction is issued to ignore them.

Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?

Materials Requirements Planning controls production equipment, such as drills, lathes, and milling machines.

COGNITIVE ASSESSMENT What is the smallest unit of data the computer can process?