School of Engineering and Technology
An application is needed for a local company that creates clinical trials and treatments using recent scientific discoveries. The company is funded by multiple state universities along with other private and public partnerships. Currently, this company uses Excel spreadsheets to track their budget and disbursement of funds. The goal of this application is to give them…
An Indiana landscaping company wants a new system to store information on their inventory and billing. They have been using Excel spreadsheets to keep track of everything up to this point. This set up has been successfully replaced with a database using SQL Server. The front end was created in Microsoft Visual Studio with web…
The purpose of this project is to determine if a free, open-source program can function in the role of a Security Operations Center for a Fortune 500 Company. This program is needed to analyze a network, or multiple networks, for a variety of threats. It also needs to be able to display alerts from the…
The purpose of this project is to make necessary modifications to a database in order to handle the information of the current and new games in order to meet the client’s requirements. First it was necessary to create a new ER diagram to analyze, understand, and document the functions of the database. Following that, the…
A local hospital department has learning modules for people to test themselves with and would like their database to automatically calculate and save the results to their internal server. Everything for the learning modules has already been set up. My job is to finish it by finding a PHP script that will function properly with…
A local not-for-profit needed a Logical Map of their entire network, since the Physical was already completed. The logical network included the names of the desktop computers, as well as which network they were connected to. These were based on the IYG assets that were in an Excel document, then grouped based on different categories from a Word…
The purpose of the Jagwarz Database Game is to create a game within Jagwarz for an introductory database course taught by the University Department. Before creating the game itself, the database must first be checked for any integrity issues and any database relationship issues between the tables. Once completed, then potential queries were to be…
This security camera is a challenging but well worth it project.The goal of this project is to install a security cameras that can catch a person stealing a computer or trying to cheat on a test. I have had to use the command prompt to look at the IP addresses given to each camera. I…
This project provides university students access to virtual machines and environments for penetration testing, networking security, and forensics practice, as well as SQL databases. With a current total of five machines running virtualization software, our servers currently support 29 usable VMs. Our an application container server can accommodate an expanding number of SQL databases. It was…
A local non-profit organization website dedicated to finding foster homes and adoptive owners for dogs in the state of Indiana needs their adoption process updated. Currently the application process to adopt a dog is done via a pdf that has to be either scanned and emailed, or sent out by regular mail to the organization. The goal of…