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

Share

COinS
 
 

To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.