True/False
1. True
2. True
3. False
4. True
5. False
6. False
7. True
8. True
9. True
10. True
Multiple Choice
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.f
Short Answers
1. Validation is the process of comparing data with a set of rules or values to see if the data is correct.
The five types of validation checks : alphabetic checks, numeric checks, range checks, consistency checks, and completeness checks.
2. Because data redundancy will make the process of inputting new data longer and also increase the chance of errors.
Because isolated datas will limit the access of data that is actually needed for certain purposes since different data are stored in different file.
3. A program to share the data in database.
The 5 strength of database approach : reduced data redundancy, improved data integrity, shared data, easier access, reduced development time.
4. I might use the Simple Query Wizard to search the information I need from a database so it will cut my time more.
Query by example is 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.
Examples of applications appropriate for an object-oriented database include the following:
• A multimedia database stores images, audio clips, and/or video clips. For example, a GIS (geographic
information system) database stores maps and other geographic data. A voice mail system database stores audio messages. A television news station database stores audio and video clips.
• A groupware database stores documents such as schedules, calendars, manuals, memos, and reports. Users perform queries to search the document contents. For example, you can search people’s schedules for available meeting times.
• A computer-aided design (CAD) database stores data about engineering, architectural, and scientific designs. Data in the database includes a list of components of the item being designed, the relationship among the components, and previous versions of the design drafts.
• A hypertext database contains text links to other types of documents. A hypermedia database contains text, graphics, video, and sound. The Web contains a variety of hypertext and hypermedia databases. You can search these databases for items such as documents, graphics, audio and video clips, and links to Web pages.
True/False #9 is FALSE.
ReplyDeleteNice post with awesome points! Can’t wait for the next one.
ReplyDeleteAcer - 10.1" Aspire One Netbook - 1GB Memory - 320GB Hard Drive - Espresso Black
Acer - 11.6" Aspire One Laptop - 2GB Memory - 320GB Hard Drive - Ash Black