Course description: Coverage of the architecture and programming of transaction processing, client/server systems, and distributed objects. Programming will involve traditional on-line transaction processing with systems similar to CICS as well as newer client/server systems such as Visual BASIC. Comparison of on-line transaction processing verses dimensional data warehousing.
This course was a continuation of COSC3308 personal computing. It covered more advanced areas of Visual Basic 6 programming. The textbook for the course was Advanced Visual Basic 6: 2nd Edition by Irvine and Liang. I used material from this class in my masters degree to complete a semester-long systems development project in ISM6121 advanced information system analysis and design. Microsoft Visual Basic .NET was becoming more popular during this course, so I took advantage of the Microsoft Academic Alliance contract UT Tyler had with Microsoft to do some of my homework assignments in .NET instead of version 6 of VB.
This project gave me experience with loading multiple forms and passing information between them. It is a wizard for checking out equipment from a fictional company to accomplish various cleaning projects. Based on variables passed to each form, the next form generates a changing list of equipment. The user inputs their contact information, and an invoice can be printed for the equipment to the default printer.
| Attachment | Size |
|---|---|
| COSC3370 David Norman cleaning equipment wizard lab04.zip | 57.78 KB |
This program creates 25 forms with random background colors. The main form has a select menu to activate any one of the 25 forms. Since the forms are created in a sort of random fashion, the main form has to keep track of the randomly generated forms to know how to activate them when selected.
| Attachment | Size |
|---|---|
| COSC3370 David Norman form clone lab05.zip | 146.78 KB |
This project is my first to implement a save function to a comma-delimited file. It accepts input for a fictional freight forwarding service. The values are stored in RAM until save is selected from the file menu. Save writes the information to a file named packages.dat.
| Attachment | Size |
|---|---|
| COSC3370 David Norman freight fowarding service lab03.zip | 38.92 KB |
This project was my first programmed in .NET. It displays images in BMP, JPG, GIF, WMF, or ICO format. It was also a way to practice using methods to open files from the filesystem and load them into memory.
| Attachment | Size |
|---|---|
| COSC3370 David Norman image viewer lab02.zip | 67.2 KB |
This program reads the famous Microsoft Northwind database. It has only partial functionality to read records from the orders and product categories tables. It does nothing more than simply display information.
| Attachment | Size |
|---|---|
| COSC3370 David Norman Northwind reader lab07.zip | 1.25 MB |
This program generates an amortization table based on user input of principal, percent interest, and loan duration. Figuring out the math for the interest paid, principal paid, and balance for each month of the payment schedule was harder than it looked. The percent interest does not accept values below 5.0, not as a bug, but rather as a "feature" required as part of the assignment.
| Attachment | Size |
|---|---|
| COSC3370 David Norman amortization lab09.zip | 33.09 KB |
This was the first assignment of the semester. It was a warm up for people rusty on VB code to get familiar with programming again. It simply does a conversion from Celsius to Fahrenheit or vise versa in real time. Previously, all projects I completed had user-initiated actions by a button click or menu selection. It has a bug that crashes the program if a period is entered as the first character in the text fields even though it does a check for incorrect input.
| Attachment | Size |
|---|---|
| COSC3370 David Norman temperature conversion lab01.zip | 19.26 KB |
The parent form in this project has a project area to hold notepad-like documents. It was my first experience with creating a file open function to read file contents into memory, save the file back to disk in RTF format, and use the tiling functions for windows.
| Attachment | Size |
|---|---|
| COSC3370 David Norman wordperfection lab06.zip | 53.78 KB |