Resource download address ：https://download.csdn.net/download/sheziqiong/85760390
Resource download address ：https://download.csdn.net/download/sheziqiong/85760390
Catalog
One ． Development environment and development tool development environment ： 1
3、 ... and ． Functional requirements analysis 3
Four ． The system design 4

1. Data conceptual structure design （ System ER chart ） 4
2. Database relational schema design 5
3. Database physical structure design 5
   5、 ... and ． The realization of system functions 6
4. Sign in 6
5. Stock purchase 6

Otherwise, the purchase record of the current day will be directly modified 9

garage 9
3. sales 10

Otherwise, you can directly modify the sales record of the current day 12

4. Return goods 13

If there is no return record of the current day, create a new return record 15

Otherwise, you can directly modify the return record 15

5. Book inventory query 15

By default ： View all books 16

6. Sales data query 17

By default ： View all books 17

6、 ... and . summary 18
One ． Development environment and development tool development environment ：
operating system ：Windows 10 Enterprise Version 20H2
Database management system ：MySQL 5.7
programing language ：Python 3.8
development tool ：
Graphical interface library ：Tkinter
MySQL Client library ：PyMySQL Two ． System requirements analysis
Bookstores can realize the sales management of books through the book sales management system , The main data processed by this system are : Book information 、 Purchase order 、 Sales data 、 Return order 、 Supplier information, etc .
System data dictionary :
data structure :
Book list :
describe : Information data items of books in the bookstore inventory :
Book number :
describe : A numeric number definition that uniquely identifies the books in the library : Integer numbers
Title :
describe : Definition of the book title : Character type name
Number :
describe : The definition of inventory in this book : Integer numbers
Cost price :
describe : The purchase price of the book
Definition : Floating point number ( Keep two decimal places )
What's the price :
describe : The selling price of the book
Definition : Floating point number ( Keep two decimal places )
Supplier list :
describe : Supplier information data item of incoming books :
Number :
describe : Definition of the numerical number identifying the supplier : Integer numbers
name :
describe : Supplier name definition : Character type Chinese character name
Book number :
describe : The number definition of the book provided by the supplier : Integer numbers
Price :
describe : Definition of the price at which the supplier sells the book : Floating point number ( Keep two decimal places )
Purchase list :
describe : Information data items of incoming books :
Book number :
describe : Number definition of purchase order : Integer numbers
Number :
describe : Quantity definition of purchase order : Nonnegative integer number
Supplier No :
describe : Definition of the supplier number of the purchase book : Integer numbers
sell 、 Return form :
describe : sell 、 Information data items of returned books :
Book number :
describe : sell / The book number definition when returning goods : Integer numbers
month :
describe : The definition of the month in which the book is sold : Non zero integer number
Japan :
describe : The definition of the number of days to sell the book : Non zero integer number
Number :
describe : The number of books sold ( Including return )
Data flow :
Definition : Integer customer number :
describe : Definition of the customer number who bought this book : Integer numbers
Inventory of
Book table data flow :
explain : “ Book list ” The flow direction and source of data structure in the system : Stock purchase 、 Return goods 、 Sales transactions
Where does the data flow go : Book inventory query transaction 、 Book sales data query transaction purchase table data flow :
explain : “ Purchase list ” The flow direction and source of data structure in the system : Purchase transaction
Where does the data flow go : Book and table information transaction sales 、 Return table data flow :
explain : “ sell 、 Return form ” The flow direction and source of data structure in the system : Return goods 、 Sales transactions
Where does the data flow go : Book and table information transaction process :
Real time book inventory calculation :
explain : With the purchase 、 sales 、 Ongoing return transactions , It can calculate the current books in real time
Input : Incoming data flow 、 sell 、 Return data flow output : Calculate the current inventory of each book
Sales data calculation :
explain : Calculate the day according to the date / Monthly sales data input : Incoming data flow 、 sell 、 Return data flow output : Calculate the day / Monthly sales data











Resource download address ：https://download.csdn.net/download/sheziqiong/85760390
Resource download address ：https://download.csdn.net/download/sheziqiong/85760390