数据库需求分析的简单案例小型自选商场进销存管理系统需求分析的...（A simple case of database requirement analysis small supermarket Invoicing management system needs analysis...）.doc

数据库需求分析的简单案例小型自选商场进销存管理系统需求分析的...（A simple case of database requirement analysis small supermarket Invoicing management system needs analysis...） A simple case of database requirement analysis: small supermarket Invoicing process management system needs analysis Investigation and analysis of application Through the feasibility analysis, the original manual management of a small supermarket Invoicing management system development decision. After a detailed investigation, collection of all kinds of documents, and statements of account page. And by participating in management practice and business management personnel access to the relevant investigation, mastered the following: The mall is a life oriented small supermarket business district food and daily necessities. The original payment is to use two old cash registers, by cashier according to the commodity price tag. The mall consists of 8 people. The main work includes the management of purchase, fill in the receipt and storage in the journals, pricing, price tag, and paste the printed goods shelves and sorting, collection and billing in sales account, after the daily closing settlement business, at the end of each month for the inventory statistics and the preparation of business report table. Because it is manual management, payment and so backward, low efficiency, high labor intensity, more serious loss of goods. The volume of business market: the average purchase once every 3 days, each may have different sources of goods. The average daily number of customers is 1000 people. The average customer purchase 3 commodities. According to the regulations, after the closing of personnel according to the statistical analysis of commodity purchasing account and merchandise sales account, according to the number of goods were accumulated summary of all kinds of goods the same day bought a total storage capacity, cumulative sales and inventory balance volume data, then the data in the inventory account. Below is a list o