Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Created a database for a fictitious restaurant with stored procedures for data retrieval and connection pools to handle requests .

License

TheDataCode/Automating-Restaurant-Operations-with-MySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

History

17 Commits

Repository files navigation

Season Restaurant Database Data Retrieval

Created a MySQL database for a fictitious restaurant (season_restaurant) using MySQL/Python connector.

Summary of project

Created connection pools to handle user requests.
Created Stored Procedures to automate repeated report.

Stored Procedures:

PeakHours():
Created a procedure that retrieves peak hours and their corresponding number of bookings

GuestStatus():
Created a stored procedure that retrieves guest activity status and employees assigned to these guests.

BasicSalesReport():
Stored Procedure that returns aggregated sales report in the database

season_restaurant_db

About

Created a database for a fictitious restaurant with stored procedures for data retrieval and connection pools to handle requests .

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

AltStyle によって変換されたページ (->オリジナル) /