1. T
2. T
3. F
4. T
5. F
6. F
7. T
8. T
9. F
10. T
II. Multiple Choices
1. B
2. A
3. D
4. B
5. A
6. B
7. B
8. A
III. Matching
1. E
2. G
3. C
4. B
5. J
6. A
7. I
8. D
9. H
10. F
IV. 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.
Five types of validity checks: 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. When an organization uses a database approach, many
programs and users share the data in the database.
Five strengths of the database approach:
·
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. How to use a Simple Query Wizard:
·
Select the fields from
the Available Fields list you want to be displayed in the resulting query.
·
Assign a name to the
query, so that you can open it later.
·
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. Advantages
of object-oriented database:
They can store more type of data, access this data faster, and
allow programmers to reuse object.
Four examples of object-oriented database:
·
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.
No comments:
Post a Comment