NORTHLINK TECHNOLOGICAL INSITUTE DATABASE MANAGEMENT FINAL EXAM I. MULTIPLE CHOICES. Write the letter that corresponds to the correct answer. 1. The process of encoding information in such a way that only the person (or computer) with the key can decode it. a. Cipher c. Decryption b. Encryption d. Cryptography 2. The practice and study of hiding information. a. Cipher c. Decryption b. Encryption d. Cryptography 3. It is an algorithm for performing encryption or decryption— a series of well-defined steps that can be followed as a procedure. a. Cipher c. Decryption b. Encryption d. Cryptography 4. The encrypted form of information is known as _________. a. Cipher-text c. Decrypt b. Plain-text d. Cipher 5. This is a secret parameter (ideally known only to the communicants) for a specific message exchange context. a. Text c. Key b. Plain-text d. Cipher 6. A process to verify that the information comes from a trusted source. a. Encryption c. Verification b. Decryption d. Authentication 7. A way to authenticate a person or an information on a computer with the use of username and password a. Password c. Digital Signatures b. Pass cards d. Biometrics 8. The use of cards that can range from a simple card with a magnetic strip, similar to a credit card, to sophisticated smart cards that have an embedded computer chip. a. Password c. Digital Signatures b. Pass cards d. Biometrics 9. The use of biological information to verify identity. a. Password c. Digital Signatures b. Pass cards d. Biometrics 10. It is the creation and maintenance of a database. a. Database Analysis c. Database Management b. Database Design d. Database Management Systems 11. It is a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. a. Database Analysis c. Database Management b. Database Design d. Database Management Systems 12. The person who is responsible for managing databases. a. Database Administrator c. Systems Analyst b. Project Leader d. Programmer 13. It is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra. a. DBMS c. SQL b. MYSQL d. MSACCESS 14. A security measure that restricts access to the most valuable information that you store on an as-needed basis. a. Protecting Offline Copies c. Audit Data Access b. Safeguarding Database Accounts d. Securing the Database Administrator 15. It is ensuring that all database accounts have passwords set on them with an implementation of a strict password policy. a. Protecting Offline Copies c. Audit Data Access b. Safeguarding Database Accounts d. Securing the Database Administrator II. NORMALIZATION. CUSTOMER ORDER AND PRODUCT APPLICATION The ABC Manufacturing company has a completely automated application system. The system, however, resides on index files and does not allow for decision support at all. In order to move to ad hoc queries, and "what if" queries, the company has decided to convert the existing system to a database. Use the following reports of the company to perform the normalization of your database. ABC MANUFACTURING ORDER FORM ORDER # 9932 MR. S.D. KURTZ 123 THAT STREET TORONTO, ONTARIO A9B 8C7 PHONE: (416) 879-0045 (416) 786-3241 DATE: AUG 30, 2002 SHIPPING ADDRESS: 456 NO STREET HAMILTON, ONTARIO L6K 5J4 CUSTOMER DISCOUNT: 3% QTY 2 5 20 BACKORDERED 0 2 0 FILLED 2 3 20 35.00 PRICE/UNIT 750.99 150.00 ITEM # PRODUCT CODE DESCRIPTION AMOUNT 1 FR223 HALF SIZE REFRIGERATOR 1501.98 2 TB101 PATIO TABLE 450.00 3 CH089 PATIO CHAIRS 700.00 TOTAL 2651.98 DISCOUNT 79.56 AMOUNT 2572.42 OWING AMT PRODUCTS INVENTORY AS AT: AUG 30, 2002 PRODUCT CODE CH089 FR223 TB101 DESCRIPTION QTY ON HAND PATIO CHAIRS 140 HALF SIZE REFRIGERATOR 10 PATIO TABLE 0 . QTY BACKORDERED 0 0 2 PRICE 35.00 750.99 35.00 . . ABC MANUFACTURING PRODUCT EXPLOSION REPORT PRODUCT CODE DESCRIPTION CH089 PATIO CHAIRS PART NUMB. WOOD223 SCRW110 . . . WOOD995 SCRW110 . . . PART DESCRIPTION 1 X 2 - 30" WOOD 1.25" SCREWS QTY REQUIRED 8 26 TB101 PATIO TABLE 2 X 4 - 48" WOOD 1.25" SCREWS 12 34