Tuesday afternoon finds Anna and Chip having their weekly analysis and design review session. Chip waves toward
Question:
Tuesday afternoon finds Anna and Chip having their weekly analysis and design review session. Chip waves toward a large stack of documents that are neatly organized on a large table. “I can’t believe that we’re almost finished with the design of this system,” he remarks. “It’s been a long process, but I’ll bet we’ve obtained enough user feedback to ensure a high-quality system. All that’s left is the design of the data entry procedures, and we’ll be ready to start packaging the specs for the programmers.”
“Yes,” replies Anna, “the end is in sight. Let’s start by examining the design of the input portion of the system.”
1. Modify and print the following elements with edit criteria in the Notes (or Values and Meanings for specific codes) area. These may be found in the RepositoryWeb page or in theVisibleAnalyst repository.
Element Edit Criteria
a. SOFTWARE CATEGORY .....Table of codes:
Software Category Code
b. COURSE TRAINING LEVEL CODE ..B - Beginning; I - Intermediate;
A - Advanced
c. OPERATING SYSTEM ........W- Windows Vista Ultimate;
B - Windows Vista Business;
U – Unix
2. Modify and print the following elements with edit criteria placed in the Notes area:
a. Element: SOFTWARE INVENTORY NUMBER
Notes: A modulus-11 check digit must be verified when entering the number. The ADD
SOFTWARE program creates the check digit.
The ADD SOFTWARE program should also check the SOFTWARE MASTER file to ensure that a record with the same inventory number does not already exist.
b. Element: DATE PURCHASED
Notes: Verify that the DATE PURCHASED is less than or equal to the current date.
c. Element: QUANTITY RECEIVED
Notes: Verify that the QUANTITY RECEIVED is less than or equal to the QUANTITY ORDERED.
d. Element: SOFTWARE UPGRADE VERSION
Notes: Ensure that the software UPGRADE VERSION is greater than the current version.
e. Element:SECOND HARD DRIVE
Notes: SECOND HARD DRIVE may exist only if there is an entry for HARD DRIVE.
3. After speaking with Dot Matricks and Mike Crowe, it has become apparent that the campus codes must be sortable for installing hardware and software, as well as for creating inventory sheets. Use Microsoft Access to modify and print the CAMPUS LOCATION CODES table. The first digit represents the campus location. Values are as follows:
1 Central Campus
2 Waterford Campus
3 Hillside Campus
The next three digits represent buildings in the campus, with the following building codes:
Use a combination (your choice) of campus and building codes to build the final table of codes. Include the meaning of the code.
Step by Step Answer:
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall