IUPUI School of Engineering and Technology
A professor at a large, urban university has requested an interactive learning tool through which instructors can assign students a series of experiences, each of which has associated tasks. Experiences will be scheduled by each student, completed in real-time, and may include a variety of questions and media submission types. Previously, PHP code, database structure, and low-fidelity…
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 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…
The project consists of creating a movie and TV show database for students to use in a database course. Scraper.io was used to retrieve data from IMDB for the sample data. Python was then used to clean the data, sort it, and split it up. Excel was used to store the data for easy formatting…
This project is to design and implement a Compensation Calculator for a local government personnel website. The personnel department would like to add to their website a web application that will help a new or potential associate calculate the total amount of compensation to be received in their new position based off the current year’s…
For this project, I created a back-end database for an administrative office within an educational institution. The client is currently storing all of their information in excel files, and needed a database in order to have a more professional representation of their data. I achieved this goal by designing the database using an ER diagram,…
Our client would like to develop a mobile application that the instructor can track their students. They would like the students to be able to: post their location, submit their assignments, use different media to submit their assignments (picture, video, voice), be able to send a notification to the instructor if they need assistance, and…
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…