Exercises Note: If you are not using Visible Analyst, you can use a Microsoft Word or Microsoft Excel template to do some of the following exercises. The repository information is included in a repository.html web page that you may save. E-1. Use Visible Analyst to view the COMPUTER MASTER data store. Jump to the data structure and browse the elements and structural records. E-2. Print the SOFTWARE MASTER record using the Report feature. E-3. Use the Jump button to move to the Software Record Structure. Delete the following elements: ACTIVE SOFTWARE CODE INSTALLATION COMPUTER SOFTWARE EXPERT E-4. Modify the SOFTWARE CHANGES record, supplying changes to the SOFTWARE MASTER record. The modifications are as follows: a. Add a [pk], for primary key, in front of the SOFTWARE INVENTORY NUMBER. b. Add the following elements: COMPUTER BRAND, COMPUTER MODEL, MEMORY REQUIRED, SITE LICENSE, and NUMBER OF COPIES. E-5. Modify the COMPUTER ADD TRANSACTION record, which contains new computer records to be placed on the COMPUTER MASTER data store. a. Insert the BRAND NAME and MODEL above the SERIAL NUMBER. b. Place the CAMPUS LOCATION and ROOM LOCATION after the SERIAL NUMBER. c. Add the following elements at the bottom of the list: HARD DRIVE, SECOND HARD DRIVE, and OPTICAL DRIVE. E-6. Modify the INSTALLED SOFTWARE TRANSACTION, which is used to update the SOFTWARE MASTER and to produce the SOFTWARE INSTALLATION LISTING. Delete the TITLE and VERSION NUMBER, because they may be obtained from the SOFTWARE MASTER and are redundant keying. Add the HARDWARE INVENTORY NUMBER, specifying the installation computer. Delete the CAMPUS LOCATION and ROOM LOCATION, because they are elements of the installation computer. E-7. View the alias entry for the SOFTWARE CHANGES. E-8. Modify the INSTALLED SOFTWARE data store. Add the composition record INSTALLED SOFTWARE TRANSACTION. The index elements are SOFTWARE INVENTORY NUMBER and HARDWARE INVENTORY NUMBER. E-9. Define the data store SOFTWARE LOG FILE. This file is used to store information on the new software records, plus the date, time, and user ID of the person entering the record. Index elements are SOFTWARE INVENTORY NUMBER, TITLE, VERSION (a concatenated key), and SOFTWARE CATEGORY. E-10. Define the data store PENDING COMPUTER ORDERS. This file is created when a purchase order is made for ordering new computers, and it is updated by the computer system. Place a comment in the Notes area stating that the average number of records is 100. Index elements are PURCHASE ORDER NUMBER and a concatenated key consisting of BRAND NAME and MODEL. E-11. View the entry for the SOFTWARE RECORD data flow. Click Jump with the cursor in the Composition area and examine the SOFTWARE MASTER record. Click Back to return to the data flow description screen. E-12. Modify the SOFTWARE UPGRADE INFORMATION data flow. The composition record is SOFTWARE UPGRADE INFORMATION. E-13. Modify the SOFTWARE CROSS-REFERENCE REPORT data flow. The composition record is SOFTWARE CROSS-REFERENCE REPORT. E-14. Modify the data flow entity for INSTALL UPDATE. This flow updates the COMPUTER MASTER record with installation information. Its data structure is INSTALL UPDATE RECORD. Include a comment that it processes about 50 records per month in updating the COMPUTER MASTER. E-15. Use the INSTALL UPDATE data flow to jump to (and create) the INSTALL UPDATE RECORD. Provide a definition based on information supplied in the previous problem. Enter the following elements: HARDWARE INVENTORY NUMBER (primary key) CAMPUS LOCATION ROOM HARD DRIVE MAINTENANCE INTERVAL DATE INSTALLED E-16. Create the data flow description for the SOFTWARE INSTALLATION LIST. This flow contains information on specific software packages and the machines on which the software should be installed. The composition should include the SOFTWARE INSTALLATION LISTING, a data structure. E-17. Use the SOFTWARE INSTALL LIST to jump to (and therefore create) the SOFTWARE INSTALLATION LISTING. The elements on the listing are as follows: SOFTWARE INVENTORY NUMBER TITLE VERSION NUMBER HARDWARE INVENTORY NUMBER CAMPUS LOCATION ROOM LOCATION E-18. Modify and print the element HARDWARE SUBTOTAL. Change the type to Decimal, the length to 7,2, and the picture to Z, ZZZ, ZZ9.99. E-19. Modify the COMPUTER TYPE element. The description should be: The physical type of computer. Values & Meanings should contain: LLaptop, DDesktop, NNetbook, HHandheld, T Tablet, S-Smartphone. The type is Char with a Length of 1, and a Picture and Display of X. Do not allow a null value. E-20. Modify and print the DEPARTMENT NAME element. Create an alias of STAFF DEPARTMENT NAME. In the Notes area, enter the following comment: Table of codes: Department Table. The type should be Character, the length 25, and the picture X(25). E-21. Create the following element descriptions. Use the values supplied in the table. Create any alternate names and definitions based on your understanding of the element. Name Purchase Order Number Problem Description Type Character Character Length 7 70 Picture 9999999 X(70) Name TOTAL COMPUTER COST NEXT PREVENTIVE MAINTENANCE DATE Type Numeric Date Length 7,2 8 Picture Z, ZZZ, ZZ9.99 Z9/99/9999 Notes The NEXT PREVENTIVE MAINTENANCE DATE is calculated by adding the MAINTENANCE INTERVAL to the LAST PREVENTIVE MAINTENANCE DATE Name PHONE NUMBER REPAIR STATUS Type Character Character Length 7 1 Picture 999-9999 X Notes Table of codes: Repair Table Default C