Rickvian Aldi / 1601253441 / 01PBT
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.