Data Structure and Algorithms for Inventory System

Running head: DATA STRUCTURE AND ALGORITHMS
DATA STRUCTURE AND ALGORITHMS
Name of Student
Name of university
Author Note

1
DATA STRUCTURE AND ALGORITHMS
Table of Contents
Introduction:...............................................................................................................................2
Associated variables, keys and ranges:..................................................................................3
Operations involved in an Inventory system:.........................................................................4
Suitable Algorithms for the operations:.................................................................................5
Proposed changes:......................................................................................................................8
Conclusion:................................................................................................................................9
References:...............................................................................................................................10

2
DATA STRUCTURE AND ALGORITHMS
Introduction:
The inventory system is associated to retail industry, to manage an inventory system
proper operations are required (Vrat 2014). Inventory systems are used in business,
education, manufacturing, etc. to maintain a stock level (Muller 2019). This system helps in
maintaining the details of the items involved, items could be product details, supplier details,
count of materials price of material, etc. In this report designing of an inventory system is
focused. The company that requires the inventory system deals with the products of two
types, which are food items and household items. The estimated quantity of the household
items is 300 and the estimated quantity of the food items is 200 items for recording the items.
The relevant information that are stored in the inventory are product type, price of the
product, details of the manufacturer for house hold items and expiry date of the food items.
Later due to the dealing with another company the number of products got increased. Some
changes would be required such as suitable algorithm for handling the large set of data. And
which other operations are required for handling the large set of data. Altogether, the total
number of products for household items is approximately 25,000 and the number of food
items has increased to 1500. Therefore, for handling the operations involved in the existing
system is a little different from the operations involved in larger dataset.

3
DATA STRUCTURE AND ALGORITHMS
Associated variables, keys and ranges:
Two classes need to be created for maintaining the inventory one household_items
and another one for food_items. And the associated variables for household items are:
Product id, product type, product name, product price, product manufacturer. The associated
variables for household items are: Product id, Product type, product name, product price,
product manufacturer, expiry date. For each product there should be unique product id hence,
foodproduct_id and product_id has been added as a variable for both the classes of
food_items and household_items repectively and the key will be primary key or unique key.
The range of the variables that has been set can be used if there are 200 or 300 items.
Household_items
Variables Data type Keys Range
Product_id Integer Primary 10
Product_name string Not null 30
Product_type String Not null 20
Product_price Integer Not null 20
Product_manufacturer String Not null 20
Food_items
Variables Data type Keys Range
foodproduct_id Integer Primary 10
Product_name string Not null 30