School of Engineering and Technology
The project goal is to troubleshoot a POS (Point Of Sale) Database. There are some problems with queries about returned damaged equipment. The return table is only showing POS data and not return data. Also, returned items field tickets show up in the database, but are not showing up in field ticket items. This database uses Microsoft SQL Server…
A local organization facilitates the translation of scientific discoveries in the lab into clinical trials and new patient treatments in Indiana and beyond. The organization has numerous spreadsheets to assist in their budgeting and application of benefits for those involved in the trials, including the doctors, staff, etc. Previous work done by the Living Lab has…
A scientific research organization, in collaboration with various universities and other partnerships, wants to aid in translating research and scientific discoveries into practice and clinical trials. This project was previously created in spring by another student. Their mission is to increase translational biomedical research and to improve the health of people, and also gather information from the client, understand…
This application is intended to calculate an employee’s salary based on their job codes or title. The user is to select their title or job code, and the application will prompt with more options that the application will use to make the necessary calculations for the associates’ salary. Project Student: Bonani Ndabambi
The client requested a database for the purpose of tracking service tickets and their status. The database is designed to store data on projects and provide easy viewing for their current status. Through trial and error, I discovered that the uniteAll command would not permit the user to edit any entries in the queries, so…
We have created a database that contains student class assignments, assignment submissions, teacher class assignments. The database can add and delete students, teachers, and assignments. We have also developed a web interface for the application as well. This gives the user a graphical interface to the database and also a unique login function. We have…
A prominent business in the Indianapolis area has asked the Living Lab to assist them in creating dashboards in order to view information about their error and event logs in real time. This data will be used to perform analysis on the data and determine ways to optimize their up-time. Using Splunk, a data mining…
A local organization is having issues with their data. Their current data storage system is comprised of two databases and many spreadsheets, which are used by several people for a variety of purposes. They are finding that using and maintaining this data is difficult, as it has several entry points. Updates are needed in more…
A local research company is requesting to have a web application front end built for an oracle database that stores budgeting information for the finance department. The finance department currently accomplishes this task using a series of convoluted excel spreadsheets, which are cumbersome. In addition to storing data, the application must also help in calculating…
The project goal is to create a database able to help with all daily and seasonal functions for an agricultural company. The client is currently using excel sheets to track the data for both. They input data within these sheets often. The database will be used to help generate reports and views to allow the…