Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

E-1. The HARDWARE INVENTORY LISTING shows all personal computers, sorted by campus and room. E-2. The SOFTWARE INVESTMENT REPORT is used to calculate the total

E-1. The HARDWARE INVENTORY LISTING shows all personal computers, sorted by campus and room. E-2. The SOFTWARE INVESTMENT REPORT is used to calculate the total amount invested in software. E-3. The INSTALLED COMPUTER REPORT shows the information for installed machines. E-4. The prototype for the COMPUTER PROBLEM REPORT lists all machines sorted by the total cost of repairs and includes the number of repairs (some machines do not have a high cost, because they are still under warranty). This prototype is used to calculate the total cost of repairs for the entire university, as well as to identify the problem machines. E-5. The NEW SOFTWARE INSTALLED REPORT shows the number of machines with each software package that are installed in each room of each campus. E-6. The SOFTWARE CROSS-REFERENCE REPORT lists all locations for each version of each software package. E-7. The DELETE COMPUTER RECORD screen is used to select computers to remove from the system. The entry area is the Hardware Inventory Number field. The other fields are for display only, to identify the machine. The users would like the ability to print each record before they delete it. They also want to scroll to the next and previous records. Hint: Examine the fields shown in the HARDWARE INVENTORY LISTING report. E-8. An UPDATE MAINTENANCE INFORMATION screen enables Mike Crowe to change maintenance information about personal computers. Sometimes these are routine changes, such as the LAST PREVENTIVE MAINTENANCE DATE or the NUMBER OF REPAIRS, but other changes may occur only sporadically, such as the expiration of a warranty. The HARDWARE INVENTORY NUMBER is entered, and the matching COMPUTER RECORD is found. The BRAND and MODEL are displayed for feedback. The operator may then change the WARRANTY, MAINTENANCE INTERVAL, NUMBER OF REPAIRS, LAST PREVENTIVE MAINTENANCE DATE, and TOTAL COST OF REPAIRS fields. Mike would like to print the screen information, as well as undo any changes, easily. E-9. The SOFTWARE LOCATION INQUIRY displays information about rooms and machines containing selected software. The TITLE, VERSION NUMBER, and OPERATING SYSTEM are entered. The output portion of the screen should show the CAMPUS LOCATION, ROOM LOCATION, HARDWARE INVENTORY NUMBER, BRAND NAME, and MODEL. Buttons allow the user to move to the next record, the previous record, and to close and exit the screen.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions

Question

How does a joint venture differ from a strategic alliance?

Answered: 1 week ago

Question

=+j Explain the essential nature of repatriation.

Answered: 1 week ago