Data Structure and Algorithm for Inventory Systems

Running head: DATA STRUCTURE AND ALGORITHM
DATA STRUCTURE AND ALGORITHM
Name of the Student
Name of the University
Author Note

1DATA STRUCTURE AND ALGORITHM
Executive Summary
This report discusses the regarding the two different inventory systems. It elaborates how the
several operations in that inventory systems needs to be performed. It discusses the searching
and sorting algorithms performed in this type of inventory systems. This assignment illustrates
different innovative techniques for the optimization of the inventory systems. This report
elaborates the proposed changes in the algorithm of searching as well as sorting category. This
report concludes that how algorithm can improve the changes the inventory systems.

2DATA STRUCTURE AND ALGORITHM
Table of Contents
Introduction......................................................................................................................................3
Discussion........................................................................................................................................3
Choice of variables, keys and ranges...........................................................................................3
Choice of the algorithm for searching and sorting......................................................................6
Justification for choosing the algorithm for each operation........................................................6
Proposed changes.........................................................................................................................9
Conclusion.....................................................................................................................................12

3DATA STRUCTURE AND ALGORITHM
Introduction
This report discusses choosing exact variables, keys, and ranges that have used in that
system. This assignment provides the required justification related to this matter (Bestle, Abbas
and Rui 2014). It describes several operations that are required for the efficient performance of
the system (Aumüller and Dietzfelbinger 2016). The efficient sorting and searching algorithm
needs to be implemented for performing this operation. It provides the proper justification of the
chosen algorithm and also the proposed modification of those algorithms.
Discussion
Choice of variables, keys and ranges
The variables used for the household database are prodtype, prodname, prodprice,
prodmanufacturer (Bestle, Abbas and Rui 2014). The variable used for food items database is
fdtype, fdname, fdprice, fdmanufacturer, fdexpiry.
The data type of prodtype is varchar2(20). The data type of prodname is varchar2(20).
The data type of prodprice and prodmanufacturer is respectively integer and varchar2(20). In
case of food database the data type for fdtype is varchar2(20) (Bogdanov, Laur and Talviste
2014). The data type of fdname is varchar2(20). The data type of fdprice is integer. The data type
for fdmanufacturer is varchar2(20). The data type for fdexpiry will be date. The primary key of a
household item is prodtype (Hansen and Narayanan 2013). The primary key for food items will
be fdtype. The range of the prodname prodtype, prodprice and prodmanufacturer is three
hundred. It is because; there are three hundred types of household items manufactured by the