Chapter 9

1. Chapter 9 Describing Process Specifications & Structured Decisions

2. Chapter 9 Use Visible Analyst to view the Process repository entry for UPDATE PENDING COMPUTER ORDER E – 1

3. Chapter 9 Modify and print the ACCUMULATIVE HARDWARE SUBTOTALSProcess entry. Add the Process Description, “Accumulate the hardware subtotals. These include the number of machines for each hardware brand.” E – 2 AFTER BEFORE

4. Chapter 9 Modify and print the CONFIRM COMPUTER DELETION Process entry. Add the following Process Description: Use the COMPUTER RECORD to format the Deletion Confirmation screen (refer to the Delete computer Prototype screen). Prompt the user to click the OK button to confirm the deletion; otherwise, click the Cancel button to cancel the deletion. If the operator clicks OK to delete the record, delete the record and display a “Record Deleted” message; otherwise, display a “Deletion Canceled” message. E – 3

5. Chapter 9 Create Process specifications for process 6.6, VALIDATE COMPUTER CHANGES. The Process Description for the process is as follows: E – 4

6. Chapter 9 E – 4 Computer Change Information Computer Record Confirm Changes Validate Changes Enter Computer Changes Confirm Correct Record Rewrite Computer Master Display Computer Record Obtain Computer Master Key Computer ID 6.8 6.6 6.2 6.7 6.4 6.3 6.5 6.1 Validate Computer ID Key ID Not Found Error Computer Master Computer Master D4 D4 Rejected Changes Display Record Confirm Computer Record Keyed Changes Valid Changes Rejected Changes Computer Changes Change Errors Confirmed Changes Computer Master Record

7. Chapter 9 Create process specifications for process 1.4, CREATE SOFTWARE LOG FILE. Use the data flow diagram examples to determine inputs and outputs. Process details are as follows Format the SOFTWARE LOG RECORD from the following information: The confirmed NEW SOFTWARE RECORD elements. The following system elements: SYSTEM DATE, SYSTEM TIME, USER ID, NETWORK ID. When the record has been formatted, write to the SOFTWARE LOG FILE E – 5 AFTER BEFORE

8. Chapter 9 E – 5 (Cont.)

9. Chapter 9 Produce process specifications for process 3.1.7, FIND MATCHING HARDWARE RECORD. This process is part of a program producing a report showing all computers on which each software package is located. Use Visible Analyst to view data flow diagram 9.7. Use structured English to depict the following logic: For each SOFTWARE RECORD, loop while there is a matching hardware inventory number. Within the loop, accomplish the following tasks: Randomly read the COMPUTER MASTER file. If a record is found, format the MATCHINGCOMPUTERRECORD information. If no record is found, format a NO MATCHING error line. Furthermore, if the found COMPUTER RECORD is inactive, indicating that it has been removed from service, format an INACTIVE MATCHING COMPUTER error line E – 6

10. Chapter 9 E – 7

11. Chapter 9 Create the FIND SOFTWARE LOCATION decision table, representing the logic for an inquiry program for displaying all locations for a given SOFTWARE TITLE and VERSION. The conditions have been created and optimized, resulting in five rules, illustrated in Figure E9.3. Enter the actions that need to be entered and an X in the column related to the conditions. If you are using a word processor, print the final decision table. The conditions and actions are represented by the following logic: The SOFTWARE MASTER file is located for the specified TITLE. If the matching record is not found, an error message is displayed. Because there may be several versions The VERSION NUMBER on the record is checked for a match to the version entered. If the requested version is not found. Further records are read using the alternate index. If all records are read and the version number is not found, an error message, VERSION NOT AVAILABLE, is displayed. Once the correct software has been located, a matching COMPUTER MASTER record is obtained. If the COMPUTER MASTER is not found, the error message. MACHINE NOT FOUND is displayed. For each matching machine, the CAMPUS TABLE is searched for the CAMPUS LOCATION code. If the code is not found, the message CAMPUS CODE NOT FOUND is displayed. If no errors occur, the requested information is displayed. E – 8 Decision Table: Find Software Location

12. Chapter 9 E – 9

13. Chapter 10 Preparing The System Proposal

14. Chapter 10 E – 1

15. Chapter 10 E – 2

16. Chapter 10 E – 3

17. Chapter 10 Investigate the features and prices for C++ packages. Make a summary list of your findings. Summary Cost : FREE Features : Powerful Add-ons Product support Online Resource Tech community Few member at CPU are using E – 5

18. Chapter 10 E – 6 * = Price per Processor

19. Chapter 10 • Full featured database system • Whether you're a lone developer, small and midsize business, or large corporate enterprise, there's an edition of the world's #1 database tailored to meet your business and technical requirements • Protects from server failure, site failure, human error, and reduces planned downtime • Full-featured database systems on the market today used by high-end • Users/database administrators are able to perform a restore operation while an instance of SQL Server is running • Works with familiar tools like Microsoft Word/Sharepoint E – 6 (Cont.)

20. Chapter 10 Microsoft Access • An entry-level database that offers a flexible environment for database developers and users • Users can create tables, queries, forms and reports, and connect them together with macros • Data can be exported to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. • A relational database system developed by IBM Corporation • Serve a number of different operating systems platforms. • According to IBM, DB2 leads in terms of database market share and performance. E – 6 (Cont.)

21. Chapter 10 • My SQL is a relational database management system that implements many industry standards including SQL and ODBC along with C and Perl • Database/client can connect to mysql server using many protocols Paradox • Full-bore relational database with extremely easy-to-use QBE (query-by-example) user interface • Crash-proof, with various traps for protecting data integrity as well as a file-check-and-repair routine E – 6 (Cont.)

22. Chapter 10 Investigate the features and prices for PHP, Visual Basic, .NET, Ruby on Rails, and Java. Make a summary list of your findingsAnswer: Use computer magazine or Google. Things to research would be Price Ease of use Debugging tools Programming editor used E – 7

23. Chapter 10 • It's Free! • PHP supports a full-featured C-like scripting language. • PHP supports typed variables, arrays and even Perl-like associative arrays. • Platform Independence • Object Oriented • Built in Networking • Simple E – 8 • Ruby On Rails • Database Access Library: Ruby on Rails includes a database access library - Active Record - that simplifies data handling in databases. Active Record automatically maps tables to classes and rows to objects. • Libraries for common tasks: Ruby on Rails includes a host of libraries that simplify the coding of common programming tasks such as form validations, sessions management, etc. • Debugging: Detailed error logs are provided, making it easier to debug applications.

24. Chapter 10 Using the information gathered in the exercises above, calculate the total cost for three unique solutions. E – 9

25. Question & Answer