Inventory Management Database is a system, which has to be designed to aid a leading company to control and manage its equipment. The company keeps track of all the goods and materials added or moved out of its stock of goods. Currently the company is dependent upon a manual system for their routine tasks. The manual procedure not only makes the process inefficient but also make it liable to fatal errors. Another problem with the manual system is that of security and protection of data.
The company receives order from its various clients and each morning loads a truck full of equipment required by the clients. In addition it also sends some technicians working for the company who are responsible for installing these equipment. There may be a case when particular equipment can not be installed due to one or the other reason. As a result the company has to keep a good eye on the stocks which are dispatched on the truck every morning. In addition the company has to take care of those goods also which are returned in the evening (in case there is an installation failure) when the truck and the technician staff return back after completing the everyday work and satisfying the needs of all clients. Here it becomes necessary for the company to keep accurate records for items in inventory.