Canteen Management System

Idea for the Canteen Management System:

Taking Fudan University as an example, the school's backend already has a system for managers, but it lacks a display system for users (students). Meanwhile, some cafeterias (such as Dan Yuan) set up a small whiteboard for students to provide feedback, and this method of feedback could obviously be optimized through an online system to improve efficiency and facilitate display. An online display system aimed at students could also help promote and publicize the school cafeteria. From this, the idea for a college cafeteria management system began to take shape.

 

Features

This features is divided for administrators and student users.

Administrators

1. Access user information.
2. View the user interface display.
3. Add, delete, or modify cafeteria information.
4. Add, delete, or modify window information.
5. Add, delete, modify, or search for dish information.
6. Add, delete, or modify tag information.
7. View the categories of tags associated with dishes, and add, modify, or delete tags associated with dishes.
8. Delete comments.

Modify Information:

Student Users

Guideline:

1. Log in, log out;
2. Browse dish information of different cafeterias;
3. Retrieve dishes based on the search box input;
4. Filter dishes by different classification methods;
5. View detailed information about dishes;
6. Read comments and ratings on dishes;
7. Add comments and ratings.

Dish detail display:

Database Design

ER Design:

Detail of the relational model and fields stored in the database:

• auth_user(id, username, password, is_superuser, first_name, last_name, email, is_active)
• canteen(C_, Cname, Cpicture)
• win(W_, Wname, Wlocation, C_)
• dish(D_, Dname, Dprice, is_sell, Dpicture, W_)
• remark(R_, Rcontext, Rmark, id, D_)
• tag(T_, Tname)
• tag_belong(T_, D_)

Primary keys in bold and foreign keys in italic.

Install and Build

Reference to bserv.

NOTE:

To build the dependencies & the project, refer to BUILD-Windows.md or BUILD-ubuntu.md.

Information

Project for Introduction to Database 22 Spring in Fudan University.

Using Framework bserv, A Boost Based C++ HTTP JSON Server.

Link: bserv.