Exam 11: Information and Data Management

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

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

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. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?

Many e-commerce sites use ____________________ to determine customer preferences.

COGNITIVE ASSESSMENT To what does the term GIGO refer?

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a file?

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

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

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

Which of the following is a window on the screen that provides areas for entering or changing data in a database?

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

Data in a database is less vulnerable than data in file processing systems.

Most information is important to all people and groups of people.

____________________ is a common data type that consists of an email address or a web address that links to a webpage on the Internet, for example.

In a database such as that pictured in the accompanying figure, users can set up a relationship between tables at any time, but the tables must have which of the following in common?

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

A relational database developer refers to a record as a relation.

A data model defines how users view the organization of data.

A data model defines how the operating system actually arranges the data on the disk.