Database Capstone Project

This is a capstone project for the Database Engineer Course at Coursera. The project is about creating a database for a fictional company called Little Lemon.

Project Description

Little Lemon restaurant needs to build a relational database system in MySQL to store large amounts of data which they can also easily manage and locate as required. Little Lemon have decided to use MySQL Workbench to develop their new database system.

Project Tasks

1. Set up the database
2. Create and implement an ER diagram
3. Create tables and relationships
4. Create sales reports
5. Build a booking system
6. Generate data insights
7. Create a database client

Technologies Used

MySQL, MySQL Workbench, Python, Git, Tableau