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.

Administration Admissions Environmental Studies 001 010 Geology 002 011 Agricultural Astronomy 003 012 Law 004 013 Library Mathematics 005 Business 014 Chemical Engineering Computer Science Education 006 015 Medicine 007 016 Physics 008 017 Psychology Zoology 009 Engineering 018