College
College of Engineering and Polymer Science
Date of Last Revision
2024-06-04 07:22:40
Major
Computer Information Systems
Honors Course
CISS 451
Number of Credits
3
Degree Name
Bachelor of Science
Date of Expected Graduation
Spring 2024
Abstract
Large commercial companies often use warehouses to store and organize their product inventory. However, manually keeping track of inventory through physical means can be a tedious process and is at risk for a variety of potential issues. It is very easy for records to be inaccurate or duplicated, especially if large reorganizations are undertaken, as this can cause issues such as duplicate product ID numbers. Therefore, it was decided that an inventory management system utilizing a SQL database should be created. The system needed to have capabilities including allowing the entry of product information, the ability to search database records based on attributes, the ability to update product attributes, and the ability to delete records, ideally with a confirmation prompt. Additionally, the system needed to have measures in place to prevent duplicate or redundant records from being entered. Expected business benefits from this program included being able to retrieve inventory records at increased speed, being able to reorganize and update product information quickly and more efficiently, and being able to avoid potentially costly errors from conflicting or redundant records.
Research Sponsor
Zarreen Farooqi
First Reader
John Hoag
Second Reader
Mia Simmons
Honors Faculty Advisor
Zarreen Farooqi
Proprietary and/or Confidential Information
No
Recommended Citation
Bartlett, David, "Managing Inventory With a Database" (2024). Williams Honors College, Honors Research Projects. 1818.
https://ideaexchange.uakron.edu/honors_research_projects/1818
Included in
Databases and Information Systems Commons, Data Storage Systems Commons, Software Engineering Commons