A Minor Project!
Course Code: CS254
Course Title: DBMS LAB
Semester: B. Tech 4 th Sem
Section: S1
Academic Year: 2020-21 Course Instructor: Dr. Annappa B and Mr. Sharath Yaji
- Ishaan Singh, 191CS124, 9739492999, asishaan.191cs124@nitk.edu.in
- Ikjot Singh Dhody, 191CS123, 9885920911, ikjotsd.191cs123@nitk.edu.in
- Aakarshee Jain, 191CS102, 9900139701, pradeepartigmailcom.191cs102@nitk.edu.in
Every club in NITK has an inventory where they store common items that belong to the club. Such items can be borrowed by the members of the club for their own personal use or can be used by the club for upcoming events, etc. However, currently (at the time this readme was written), even as part of IRIS or otherwise, there is no common platform that can manage this data for all clubs.
On our web application, club members will be able to access the club’s inventory and request for items. These items will be queued in a request table. Each of these requests can be approved by the designated leads in that club, like the Convenor or the Inventory Manager.
Once approved, the member can use the item as long as the deadline allows and then, return it to the inventory after use. This action will be logged in the database and accordingly, a list of available items will be displayed to the other members of the club for request.
Clubs will be able to keep a track of their inventory, which would otherwise be a very manual task. This automation will allow club members and supervisors get work done easily by streamlining the request-approval workflow.
Through our mini-project, we aim to provide such an interface that could later be incorporated as a package in the clubs’ own websites or as a part of IRIS.
- Clubs and Members Database
- Inventory Table for storing items of the club
- Members can request for items
- Approval flow for item requests
- Member Dashboard
- Frontend: HTML, CSS, JS, Bootstrap
- Backend: Ruby on Rails
- Database: MySQL