Assignment assigned by Mr. Tri Djoko Wahjono
A. True/False Mark T for True and F for False.
1. Data is a collection of unprocessed items, which can include text, numbers, images, audio, and video. (514)(True)
2. A database management system allows users to create forms and reports from the data in the database. (515)(True)
3. A range check ensures users enter only numeric data in a field. (523)(False)
4. A check digit often confirms the accuracy of a primary key value. (523)(True)
5. Databases require less memory, storage, and processing power than a file processing system. (526)(False)
6. A report is a window on the screen that provides areas for entering or modifying data in a database. (530)(False)
7. Continuous backup is a backup plan in which all data is backed up whenever a change is made. (532)(True)
8. A relationship is a link within the data in a database. (533)(True)
9. Normalization is a process designed to ensure the data within the relations (tables) is duplicated so that it is not lost. (534)(False)
10. The data in a distributed database exists in many separate locations throughout a network or the Internet. (536)(True)
B. Multiple Choice Select the best answer.
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 least privilege
8. A. decides on the proper placement of field.
C. Matching Match the terms with their definitions.
1. E. uniquely identifies each field
2. G. defines the maximum number of characters a field can contain
3. C. specifies the kind of data a field can contain and how the field is used
4. B. field that uniquely identifies each record in a file
5. J. consists of simple, English-like statements that allow users to specify the data to display, print, or store
6. A. listing of activities that modify the contents of a database
7. I. uses the logs and/or backups to restore a database when it becomes damaged or destroyed
8. D. database that stores maps and other geographic data
9. H. person who focuses on the meaning and usage of data
10. f. creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures
D. Short Answer Write a brief answer to each of the following questions.
1. Validation is the process of comparing data with a set of rules or values to find out if the data is correct.
There are 5 types of validation which are:
a. Alphabetic/Numeric Check
b. Range Check
c. Consistency check
d. Completeness check
e. Check digit.
2. Duplicating (redundancy) data in this manner wastes resources such as storage space and people’s time. When data is modified or added, file maintenance tasks consume additional time because people must update multiple files that contain the same data. Isolated Data, it is difficult to access data stored in separate files in different departments.
3 .Database approach means many programs and users share the data in the database, there are 5 reasons why we should use database approach:
strengths of the database approach.
• Reduced Data Redundancy — Most data items are stored in only one file, which greatly reduces duplicate data. For example, a school’s database would record a student’s name and address only once. When student data is entered or changed, one employee makes the change once.
• Improved Data Integrity — When users modify data in the database, they make changes to one file instead of multiple files. Thus, the database approach increases the data’s integrity by reducing the possibility of introducing inconsistencies.
•Shared Data — The data in a database environment belongs to and is shared, usually over a network, by the entire organization. This data is independent of, or separate from, the programs that access the data. Organizations that use databases typically have security settings to define who can access, add, modify, and delete the data in a database.
• Easier Access — The database approach allows nontechnical users to access and maintain data, providing they have the necessary privileges. Many computer users also can develop smaller databases themselves, without professional assistance.
• Reduced Development Time — It often is easier and faster to develop programs that use the database approach. Many DBMSs include several tools to assist in developing programs, which further reduces the development time.
4. How to use the simple query wizard is depending on the program itself, because every program usually has different simple query wizard. Query by Example Most DBMSs include query by example (QBE), a feature that has a graphical user interface to assist users with retrieving data.
5. Object-oriented databases have several advantages compared with relational databases: they can store more types of data, access this data faster, and allow programmers to reuse objects. An object oriented database stores unstructured data more efficiently than a relational database. Unstructured data can include photos, video clips, audio clips, and documents. When users query an object oriented database, the results often are displayed more quickly than the same query of a relational database. If an object already exists, programmers can reuse it instead of recreating a new object — saving on program development time.
4 example of object-oriented databases are:
• A multimedia database
• A groupware database
• A computer-aided design (CAD) database
• A hypertext database
Senxxkingslayer's Blog 