Exam 10: Database Management

Figure 10-4 Most DBMSs include a(n) ____ feature, like the one in Figure 10-4, which has a graphical user interface to assist users with retrieving data.

A form that sends entered data across a network or the Internet is called a(n) ____________________.

A data ____ contains a database that helps a specific group or department make decisions.

A(n) ____________________ is an application appropriate for an object-oriented database that contains text, graphics, video, and sound.

An application that supports a front-end program sometimes is called the ____.

Critical Thinking Questions Case 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?

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

In the ASCII and EBCDIC coding schemes, each byte represents a single ____, which can be a number, letter, punctuation mark, or other symbol.

In a typical ____________________, each department or area within an organization has its own set of files.

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

A ____ stores documents such as schedules, calendars, manuals, memos, and reports.

A field is a group of related files.

Discuss the seven qualities of valuable information.

Figure 10-5 A(n) ____ check is a validity check performed on data like that in Figure 10-5, which ensures users enter only numeric data into a field.

Although the hardware and software costs to set up a database may seem expensive, long-term benefits exceed the initial costs.

Figure 10-5 A(n) ____ check is a validity check performed on data like that in Figure 10-5, which ensures users enter only alphabetic data into a field.

In managing a company's database, the ____________________ focuses on the meaning and usage of data.

A(n) ____________________ consists of rules and standards that define how a database organizes data.

The advantage of a multidimensional database is that ____.

The data in a(n) ____ database exists in many separate locations throughout a network or the Internet.