Andrea Garcia, Andriy Molchanov, Dimitrios Chavouzis
Faculty Sponsor: Dr. Mendes
We are creating an automated inventory system for the Biology department of Davidson College. Currently, the department organizes its inventory using CSV files and a scan system. We will create a database support (using SQL) and a front-end website (HTML, JavaScript, CSS and PHP) connected with that database. Through the website, the faculty and students of the department will be able to log-in, filter, search, and quickly find the item they are looking for. The item’s current location and its location history will also be available. The functionality of the website is not only for querying the database but for updating it as well. The website will work with the current scan system, allowing the faculty to update the database in a more convenient way. The functionalities will vary since not all the users of the website will have the same access to it (faculty will have access to more functionalities than students). Our overall goal is to create a product that will be used by the client (Biology Department of Davidson College) and will successfully solve their current problem.