restaurant_db
This Restaurant Management System will store the information and constraints required to efficiently manage a restaurant system. This system could store two kinds of orders from customers and distribute staff with different responsibilities.
Project Reports
| Deliverable | Content |
|---|---|
| deliverable_1 | Created the ER-diagram for our restaurant management system. Specified all the entities and relationships in the system. Here is our report1 (pdf). |
| deliverable_2 | Created all the tables and generated data in PostgreSQL server. Generated queries to support multiple functionalities in the DB. Here is our report2 (pdf) (md). |
| deliverable_3 | Used Java JDBC to create the main application (video demo) for the restaurant manager. Visualized data by using the matplotlib library in Python. Here is our report3 (pdf) (md). |
Here is our ER-diagram:
Here is one example visualization image:
Read our deliverable reports for more information.
Group Members
| Name |
|---|
| Weiming Guo |
| Hengxian Jiang |
| Yingjie Xu |
| Helen Ren |
Notice
Please do not copy any code from this repository for academic purposes.