One 、 Project introduction
1. Project name
Bicycle rental system
2. Project brief introduction
Bicycle rental system is a bicycle rental management system for customer service ,
It can be used for the user to register, log in, borrow and return the car , Calculate the cost according to the time of borrowing and renting the car
3. Project environment
The system uses Python Language writing ,
Use Django frame
Database usage MySQL Database services
Two 、 System function module design
1. System module diagram
The bicycle rental system consists of front desk and back-end , The interface between the two is independent without link connection , To ensure data security ,
2. Detailed explanation of system modules
The front desk : From the home page, you can choose to log in and register
register : Registered account , After success, go to the login interface
Sign in : Enter account password to log in , Successfully transferred to personal center
Personal center : User information interface and historical order information
You can choose to rent a car or return it , You can also log out
Car rental : When the user status is available, you can rent a car
Return car : When the user has an order that has not been returned, the vehicle can be returned
Log out : Login account , Exit session , Back to home
backstage : Manage system data
Module management can choose whether to shut down the system
Data management can directly add, delete, modify and query the database
3、 ... and 、 Database design
1. The overall E-R chart
2. Entity analysis
Entities have users , vehicle , Order
user ( full name , password , Gender , Telephone , User state , Car rental status , Accounts payable )
vehicle ( The vehicle number , Vehicle status , Vehicle unit price )
Order ( user [ Foreign keys ], vehicle [ Foreign keys ], Order start time , Order end time , The order price )
Four 、 Database physical structure design
1. Database structure design
User table Person
Field name data type Main foreign key describe
PersonName Char name
PersonPassWord Char password
PersonGender Char Gender
PersonPhone Char Telephone
PersonStatus Char state
AccountPaybale Char Accounts payable
IsAdmin Float Car rental status
Vehicle list Bike
Field name data type Main foreign key describe
BikeType Char The vehicle number
BikeStatus Char Vehicle status
BikeUnitPrice Float Car rental unit price
The order sheet Order
Field name data type Main foreign key describe
Person Char Foreign keys Person surface user
Bike Char Foreign keys Bike surface vehicle
StartTime Data Starting time
EndTime Data End time
OrderAccountPayable Float Price
5、 ... and 、 System class diagram design
1.OOD Use case diagram
2. Class diagram
Screenshot of program operation :
Python Bicycle rental system complete source code :Python Bicycle rental system