Database Design for Seed Store Management System (SSMS)

Storage is an important segment of seed industry. Deterioration of seed quality cannot be eliminated during storage but it can be minimized with better management. The Ministry of Food and Civil Supplies has estimated that insects in store are spoiling about 5.18 million tones of food grains every year. Rapid loss of viability and vigor during storageis of particular concern for seeds like pearl millet, sorghum, tomato, chilly, gram, cowpea and cauliflower as well as poor storer species like onion. Management of seed store involves several parameters viz. crop, variety, class, production year,season, quantity, date of testing, seedquality, packing, size, treatment. All the parameters should be properly recorded at the time of entry and exit from the store.

Inventory management is an area where the computers can be successfully used. Currently there exists neither a database nor any software for Seed Inventory Management in the country. India has lagged far behind the rest of the world in developing software, which addresses the needs of seed storage system. An attempt is being made to design and develop a database system for the management seed store.