Team Name
Team GI
Timeline
Fall 2021 – Spring 2022
Students
- Tochy Egeonu
- Jonathan Banda
- David Rademacher
- Ian McKenzie
- Jacob Ryan
Sponsor
Shawn Gieser
Abstract
The senior design labs is in current need of managing the items they store, lend out, and receive by students enrolled in senior design. Senior design lab would like to be able to easily manage and review all of the equipment that current students borrow. Easy reporting and accurate information about students is critical in addressing items not returned. We will build a database backed website to host as a centralized source for the senior design lab to gather and store information regarding items lent out. The system will need to work in a cyclic manner allowing a user to identify the student checking in/out, process item to be checked in/out, and update the system according. Other features such as report generation and reminders may be implemented to assist the senior design lab in recovering borrowed items from students or take action accordingly.
Background
The UTA CSE program currently does not have a method to track the items stored within the lab. The CSE department is in position of various types of expensive equipment such as computer, virtual reality equipment, and many other items. These items are lent out to student within the senior design classes to aid them in their project. Without proper knowledge of what item is currently being used could cause scheduling collisions, which may as well delay a groups progress. The CSE department also takes a great risk lending these items out to student. Without knowledge of which student is currently using the item means if the item is lost, the blame would fall on multiple people. Being able to know who has what specific item checked out would help bring an oversight to these particular problem. Being able to know how many equipment is available for use, and who is specifically using the ones lent out would be a great improvement to the UTA CSE department. Since students are already given student ID, we can use the information stored in them to help simplify the database management. This also means that students who do not have their ID on hand will not be able to checkout any equipment from the CSE lab.
Project Requirements
- Create users with different privilege levels (user/admin)
- Add, remove, and edit items within the database
- Visualize department inventory status
- Checkout & return items
- Generate reports
System Overview
The entirety of our system will rely on calls made to the database. Therefore, we need the foundation of our architecture to be comprised of a database layer. The database layer plays an important role in maintaining integrity and functionality of the entire system. Working along side the database layer should be a login layer. The login layer serves its purpose in encapsulating/restricting privileges granted to users. This layers is essential in integration of the system. Other than those two layer there is only one other high level layer that must be taken into consideration, which is a dashboard layer. The dashboard layer consists of all the sub modules features of the system. This layer handles the flow and functionality of the systems features. The Layer that will put everything together is the Web Application Layer which in other words is the “API” layer that handles request to and from the database that are made on the web app. It will use the REST framework in order integrate properly.
Project Files
System Requirements Specification
