Movie Database on SQL Server

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 and modification, before exporting it as a csv file for importation into the SQL tables.

Project Student: Blake Neu

Compensation Calculator

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 benefit rates found on their website. The department currently uses an excel spreadsheet designed to use the posted salary amount, then gives an estimated total of compensation expected to be received as remuneration. A web application with a small database was designed and implemented, and still in the design stages.

Project Student: Bonani Ndabambi

 

Administrative Database

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, and then implementing the design into tables using SQL Server.

Project Students: Kurt Pittman

Reflexion Application Project

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 be able to clock their time on the assignment site. They would like the instructor to be able to: create assignments, deadlines, and quizzes; be able to track their students location, be able to assign grades through the application as it is also interfaces with a Learning Management System (such as Canvas), and be able to notify students via notifications as well.

Project Students: Darius Mpinga, Ronny Ovando, Amadou Traore

Point-Of-Sale Database

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 on backend and Microsoft Access on the front-end.

Project Student: Khurram Khan

Budgeting Website Development

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 created a database (in Oracle) which contains tables and stored procedures, along with a basic website for viewing, editing, and creating data.  The focus of the continued development will be to continue working on the creation and editing of the data via a website, and making it so data can be imported (such as a Fringe Benefit schedule) at any time.

The website application has been updated so that quick entry of data can be entered without the user needing to click update constantly (using AJAX).  Also, the users can now import a file with the correct columns and update certain areas very quickly using an export from other various systems.  Along with these updates, some database structure changes were made to better fit the .NET Entity Framework and additional fields were added for auditing purposes.  Along with these fields, an auditing factory was integrated so that any inserts, updates, or deletions would be tracked.  The user interface was updated so the user does not have to “page” through data one web page at a time, and not get a list of hundreds of records at a time, a search function was integrated, along with other various improvements.  Finally, the application now uses IU CAS authentication to provide security of the website.  Overall, this was a fun, and at times frustrating, project to work on, and I feel confident leaving the project in the hands of the next programmer.  Utilizing the resources I have already worked into the main parts, and expanding on those to the other areas that are in need, along with the documentation I am providing, they should be able to get started quickly and efficiently move through the rest of the requirements for the client.

Project Student: Chad Beckner

Scientific Institute

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 their needs and wants, organize their data, and design a database that integrates the data from all entry points and for all uses. We had to design and implement their database so the be able to access their data as the wanted.

Member: Amadou Traore

SalaryCalc Application

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

Ticket System

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 a solution needed to be constructed. Two separate views were constructed in order to meet these requirements.

Project Student: Khurram Khan

EASEL Project Update

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 joined the two entities to create a base prototype so the client can present it to their stakeholders for full funding of the application.

The prototype is built with PHP and hosted in mySQL server at the moment. The client’s goal is to have this application deployed to mobile devices. The interface also uses JavaScript and CSS to deliver a clear and smoother Graphic User Interface.

Students: Darius Mpinga, Ronny Ovando, Amadou Traore