Exam 10: Database Management

In addition to accessing information, users can provide information to Web databases.

Explain what data validation is and the various types of validity checks.

Two different people may need the same information presented in a different manner.

Figure 10-1 In a relational database, such as that pictured in Figure 10-1, users can set up a relationship between tables at any time, but the tables must have a common ____.

Yes/No (also called ____), is a common data type that includes only the values Yes or No (or True or False).

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

A(n) ____________________ is an item that contains data, as well as the actions that read or process the data.

Critical Thinking Questions Case 1 In your new role as a DBA, you have inherited a database that has a lot of problems. Your first task, you decide, is to identify the qualities of the information in your database, or, in some unfortunate cases, the absence of these qualities. Once you have worked with the data entry team to make sure that they are getting the monthly sales data into the database in a timely fashion, your next challenge is to change the method of disseminating this information from a printed report that is snail-mailed to all sales managers across the country, to an online dissemination strategy that e-mails the reports to the managers. What kind of information is at issue in this instance?

When users query a hierarchical database, the results often are displayed more quickly than the same query of a relational database.

A(n) ____ check is a validity check that determines whether a number is within a specified group of numbers.

In a database, a(n) ____ is a group of related fields.

Each higher level of data consists of one or more items from the lower level.

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

A(n) ____________________ is an application appropriate for an object-oriented database that links to an e-form on a Web page.

____________________ identifies the quality of data in a database.

Useful information ____.

A major weakness of a lot of file processing systems is that ____.

A database ____ is a computer that stores and provides access to a database.

A person without a programming background usually cannot learn a query language.

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