Answer to 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 Choice

1. B) Timely
2. A) Composite Key
3. D) File Maintenance
4. B) Determines Whether A Number Is Within A Specified Range
5. A) Less Complexity
6. B) Data Dictionary
7. B) Principle of Highest Access
8. A) Decides on The Proper Placement of Fields

Matching

1. E
2. G
3. C
4. B
5. J
6. A
7. I
8. D
9. H
10.F

Short Answer

1. The process of checking that a software system meets specifications and that it fulfills its intended purpose.

-> ALpha/Numeric Check
-> Range Check
-> Consistency Check
-> Completeness Check
-> Check Digit


2. It cause same fields to be stored in multiple files, which is a waste of storage space and people's time, and also increase the chance of errors.

-> Difficult to be accessed.

3. Approach whereby a pool of related data is shared by multiple application programs; offers significant advantages over traditional file-based approach.

(page 525-526)
-> Reduce Data Redundancy
-> Improve Data Integrity
-> Shared Data
-> Easier Access
-> Reduce Development Time

4. Guide for user to creating a query step by step.

-> Database query language for relational database.

5. Store more type of data, access this data faster, allow programmers to reuse objects, stores unstructured data more efficiently than a relational database.

-> Multimedia database
    Stored image, audio clips, and/or video clips.
-> Groupware database
    Stores document such as schedules, calendars, manuals, memos, and reports.
-> Computer-aided design (CAD)
    Stores data abour engineering, architectural, and scientific designs.
-> Hypertect database
    Contains links to other types of documents