Sqlite big assignments: membership supermarket management system

Python + sqlite is used to implement a simple membership supermarket management system,

System basic function:

1. Commodity management functions
Implementation of commodities (number, name, unit of measurement, the purchase price, price, quantity... ) add or delete check change management

2. Member management function
Implementation of members (number, name, phone, grades, discount coefficient) add or delete check change management

3. Shopping checkout function
Input a member to buy commodity code, quantity, calculate the amount payable, confirm and recorded in the sales record, and subtract the number number

4. The sales statistics
Statistical number of all kinds of goods sales per day, and supermarket sales, sales and profit
The aggregate amount of consumption statistics of each member