Research On The Managing System Of The Automatic Storage & Retrieval System Of Beer

The finished product storage of Changzhou Huaxia Brewery Ltd. is the engineering background of the thesis. According to the existing business of the man-made finished product storehouse and the developing strategy of the company, and based on the investigation on the need for the function of the managing system of the Automatic Storage & Retrieval System, the thesis puts forward some functions as follow: putting in storage, picking up goods, returning goods, changing goods, dealing overdue finished products, making an inventory of goods in a warehouse, managing stock, working without computer, suspending production, hanging operating terminals. It also discusses the realization of the system. Meanwhile, beginning with the analysis of the need few the system, the thesis draws a data flow diagram, studies the entities and their relation involved in the system and sets up the concept data model. Then it establishes a logic data model and opens up the managing system of the Automatic Storage & Retrieval System database supporting the internet structure of the client/Database server by using SQL server 2000 database system. All of these provide great support for the realization of the system in terms of data memory. Besides, after the regularity of the change of the finished product stock volume has been grasped the thesis researches on the tendency of the finished product going out of the storehouse and its inner connection with the stock quota. Using Visual basic 6. 0, automatic prediction of the tendency and calculation of the stock quota have been realized. Through such a series of research, the thesis aims at the technical possibility of the entry of the system into the beer storing field and makes theoretical preparations for the establishment of Automatic Storage & Retrieval System.