Author: Corina D Specialization Data Engineer Meta
Capstone project with MySQL, Python and Tableau - proposed by Meta.
In this project you are required to create a data model for Little Lemon and deploy it in MySQL database. ✅ This will include a set of tables to store relevant information. ✅ Once you have completed this task, feel free to populate your tables with some records of you own data for testing purposes.✅
In addition you also need to analyze data using the following Little Lemon data file (In Tableau) ✅ <- data here
Once you have created the appropriate models, database schema, and completed the data analysis in Tableau, you then need to commit the project to your GitHub and upload the link.
Your project is expected to include the following items:
-
Relevant diagrams and screenshots in PNG format. (LittleLemonDB.png and LittleLemon_tables_views_storedproc.png)
-
The data model you produced in MySQL WorkbenchLittleLemonDB_withNoCascadeFK_v2.mwb.
-
The SQL file of the Little Lemon database schema. To create use LittleLemonDB_v1.sql and to fill use createinsert_littlelemondb_v2.sql
-
The workbook that includes all worksheets and dashboards, in tableau_capstone_week3.twb.
How to Review Once you have submitted your own application, you are required to evaluate two projects submitted by your peers.
Here the screenshoots running the exercises, so you wont get lost while seting up and running the statements from the database:
-
Examine the repository and locate the file LittleLemonDM.png. Does the image match the one provided below? See our model.
-
The cloned repository contains a procedure called GetMaxQuantity(). Call this procedure and verify that the result of Max Quantity in Order is 5. Here our result
-
Call the ManageBooking() procedure by passing the appropriate parameters. First with an available table number, then with one that has already been reserved. Here our result and here
4.Use the Python client to connect to the database and create an instance of a cursor object. Create an SQL statement that calls the AddBooking() procedure and passes the parameters: BookingID=99, CustomerID=99, TableNumber=99, BookingDate=2022-12-10 Here our result
5.Use the Python client to connect to the database and create an instance of a cursor object. Create a SQL statement that calls the UpdateBooking() procedure and pass the following parameters: Here our results
- Use the Python client to connect to the database and create an instance of a cursor object. Create a SQL statement that calls the CancelBooking() procedure and passes the following parameter:Here our results
Please don't forget to leave a feedback in the exercise peer-review. so I could improve for the next iteration. Many thanks!