The Answer of Chapter 10

True/False

    1.   T

    2.   T

    3.   F

    4.   T

    5.   F

    6.   F

    7.   T

    8.   T

    9.   F

    10. T

Multiple Choices

    1. B

    2. A

    3. D

    4. B

    5. A

    6. B

    7. B

    8. A

Matching

    1.  E

    2.  G

    3.  C

    4.  B

    5.  J

    6.  A

    7.   I

    8.  D

    9.  H

    10. F

Short  Answer

1.      Validation is the process of comparing data with a set of rules or values to find out if the data is correct

Alphabetic checks, numeric checks, range checks, consistency checks, completeness checks.

2.      In data redundancy each department or area in an organization has its own files in a file processing system, by duplicating data it wastes resources such as storage space and people’s time, also data redundancy can increase the chance of error.

Isolated data often it’s difficult to access data stored in separate files in different department. Sharing data from multiple, separate files to generate such a list in a file processing system often is a complicated procedure and usually requires the experience of a computer programmer.

3.      Database approach , programs and user share the data in the database

Reduces Data Redundancy, most data items are stored in only one file, which greatly reduces duplicated data.

Improved data Integrity, when users modify data in the database, they make change to one file instead  of multiple files.

Shared data, The data in a database environment belongs to and is shared, usually over a network, by the entire organization.

Easier Access, the database approach allows nontechnical users to access and maintain data, providing they have the necessary privileges.

Reduces Development Time, it often is easier and faster to develop programs that use the database approach.

4.      First, select the fields from the Available Fields list you want to be displayed in the resulting query. Second, Assign a name to the query, so that you can open it later. Third view the query result on the screen.

Query by example is a feature that has a graphical user interface to assist users with retrieving data.

5.      They can store more type of data, access this data faster, and allow programmers to reuse object.

A multimedia database stores images, audio clips, and/or video clips, for example, a GIS database stores maps and other geographic data.

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

A computer-aided design database stores data about engineering, architectural, and scientific design.

A hypertext database contains text links to other types of documents. A hypermedia database contains test, graphic, video, and sound.