PTI Chapter 10

Assignment from Mr.Tridjoko Wahdjono

 

True/False
1.True
2. True
 3. False 
4.True
5. False
6. False
7. True
8. True
9. False
10. True
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. 
 
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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s