Pellissippi State maintains a complete inventory database of their currently active technology assets. This database is managed via Microsoft Access. Multiple characteristics of each item are stored in the database such as: Room number, ID number, and Owner. The information in this database is periodically sent to the Tennessee Board of Regents for official book keeping. As one might imagine, this information must be accurate and well formed.
This project tasked our team with the creation of an inventory transfer interface for Pellissippi State technicians. Technicians must periodically move equipment from one room to another and update the database to reflect their changes. With their current system, technicians must record the information of the devices being transferred via pen & paper, carry that information to a desktop and manually alter the database with the new information. Our application effectively automates that process and reduces the hassle for the technicians.
Our solution offers technicians a web-based device independent application with which to submit transfers. The application functions via three distinct stages which are listed below.
Upon visiting the web application, technicians are greeted with the login form seen below. The passwords are fully encrypted and can be reset via email confirmation. More information on the password system can be found here.
When the technician enters the ID number of a device, the application searches the inventory database and returns the current details of that device. The details returned include: Model, Current Owner, Current Room #, and Current Department. Allowing the technician to see these details, lets them ensure they are moving the correct item.
When the technician enters the ID number of a device, the application searches the inventory database and returns the current details of that device. The details returned include: Model, Current Owner, Current Room #, and Current Department. Allowing the technician to see these details, lets them ensure they are moving the correct item.
In order to collaborate in a functional way, we used Slack, Trello, and Github.
Contribution: Project Manager / Front-end
Occupation: Intern at Ministry Brands LLC
Contribution: Database Admin / Back-end
Occupation: Broadcast System Engineer at Discovery Inc
Contribution: Special Projects / Back-end
Occupation: Intern at Oak Ridge National Laboratory
Contribution: Back-end Programming
Occupation: Student
Contribution: Front-end Design
Occupation: Student
Contribution: Project Manager / Front-end
Occupation: Intern at Ministry Brands LLC
Specialties: JS/jQuery, Java, C#, PHP, HTML/CSS
I do software stuff...
Contribution: Database Admin / Back-end
Occupation: Broadcast System Engineer at Discovery Inc
Specialties: SQL, PHP, C#, Java
I like long walks on the beach and moonlight dinners. I'm a romantic at heart but have trouble showing my feelings. I'm looking for someone who shares my interest in video games and loves cats.
Contribution: Special Projects / Back-end
Occupation: Intern at Oak Ridge National Laboratory
Specialties: C#, Java, JS/jQuery, PHP
I'm an enthuseist for retro-technology, Linux, and Tetris. My first programming language was javascript, and since then, I've been really interested in making chrome-extensions, videogames, and other nick-nacks in the future. I'm not into beaches, but I do like ping-pong matches...
Contribution: Back-end Programming
Occupation: Student
Specialties: PHP, C++, Java, C#
I do software stuff...
Contribution: Front-end Design
Occupation: Student
Specialties: HTML/CSS, JS/jQuery, Java, C#
A dude trying to figure out what to do with his life after noticing the horrid image of himself being shown directly above. Typically enjoys playing video games pretty hardcore, alongside coming up with random projects to do.