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