Little Lemon Menu Sales Report System

This project is part of the Meta Database Engineer Professional Certificate course. The objective is to create a Python application that interacts with a MySQL database to manage bookings, orders, and generate sales reports for Little Lemon, a small family-owned Mediterranean restaurant.

Requirements

• Python
• MySQL server
• Jupyter notebook
• MySQL Connector/Python API

Installation

1. Install Python. You can download it from the official Python website.

2. Install MySQL server. You can download it from the official MySQL website.

3. Install Jupyter notebook. You can install it using pip: pip install notebook

4. Install MySQL Connector/Python API. You can install it using pip: pip install mysql-connector-python

Usage

1. Clone this repository to your local machine
2. Navigate to the project directory
3. Run the program
4. Follow the on-screen instructions to use the application.

Functionality

• View Bookings: View all the bookings in the database.
• Add Booking: Add a new booking to the database.
• Cancel Booking: Cancel a booking by providing the booking ID.
• Generate Sales Report: Generate a sales report showing total quantity and revenue for each menu item.
• Calculate Revenue: Calculate the total revenue generated from all orders.
• View Orders: View all orders in the database.
• Add Order: Add a new order to the database.