Robot Store Management System
Group name: LiuSCuiX
Group member
Xiangyu Cui, Shuhao Liu
Top level description
Our group intends to design a Robot Store Management System which is designed for offline management of small supermarkets. It allows customers and system operators to access the system. This system enables customers and operators to log in or sign up for their account. For a customer, it is easy to check order details, create new orders and submit refund requests. Each order is checked by a specific operator and the operator arranges the order process of confirmation and delivery and deals with the possible refund request.
Language
We decided to use SQL storage combined with python and this system will be tested and used on PC.
In the python to database connection programs, we intend to use mysql queries to establish a connection to MySQL and build the database structure. If a form already exists and someone wants to submit a command to the form, we need to return the data. It will use all mysql queries to build an offline version database system.
Options function
We might create a web frame to get the bonus point, it might use Django to build a web interface, if we have enough time.
All of our group members are interested in technology and science. We did a survey and found the number of robot stores is growing at a fast rate. So, we discussed and finally decided to design a management system to help these stores to operate.
The project has the project Handbook, which possesses all the program functions and end user test case.
Github: https://github.com/AndyFCui/OnlineShop-Database
Programming Language: Python, MySQL
Python Version: 3.10
Python Edition Control: Anaconda
Python Package: pymysql
MySQL Version: 8.0.33
IDE: PyCharm, Workbench
Program User Interface: Terminal
MySQL default user: root, your_passwd
• ./data: This folder store our pre-saved file information
• ./operator_sys: this folder store our code and procedure
-
o res: this folder store our procedure
-
o src: this folder store our python code
• ./uml: this folder store our database uml and activity uml
• ./final report: this file is our final report.
• ./project demo: this file is our vide to show our project.
• ./Self-contained dump file: this file is our SQL dump
• ./README: this file is technology requirement.
Anaconda: https://www.anaconda.com/
Pycharm: https://www.jetbrains.com/pycharm/download/#section=windows
Mysql: https://www.mysql.com/downloads/