Skip to content

Latest commit

 

History

History
23 lines (13 loc) · 1.28 KB

README.md

File metadata and controls

23 lines (13 loc) · 1.28 KB

Season Restaurant Database

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