Skip to content

Course project of Database Systems Winter 2020 @ McGill University

Notifications You must be signed in to change notification settings

weimingguo/restaurant_db

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

43 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:

ER

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.

About

Course project of Database Systems Winter 2020 @ McGill University

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages

  • Jupyter Notebook 57.1%
  • Java 34.2%
  • TSQL 8.7%