jamiecnl's Meta Database Engineer Capstone Final Project: Little Lemon Restaurant Database System
A system for managing bookings, orders, menus, staff, customers, deliveries, addresses, sales, and profit analytics.
- readme.md (Project documentation file)
- LittleLemonDM.png (littlelemondb data model - ERD)
- LittleLemonDB.sql (MySQL, export of the complete Little Lemon database)
- JamieL_DBCapstonePJ_Module2.pdf
- Drop and create database (littlelemondb)
- Tables, views
- Insert and retrieve data
- Optimize, manage, and analyze data
- Stored procedures, functions
- Triggers
- JamieL_DBCapstonePJ_Module3.pdf
- Tableau workspace, data analysis
- Interactive dashboard for sales and profits
- Charts (bar, line, bubble)
- JamieL_DBCapstonePJ_Module4.pdf
- Database client, Python, Jupyter Notebooks, Connector/python, Version Control
- Functionalities
- JamieL_DBCapstonePJ.ipynb (MySQL, DB Client - Python)
- JamieL_DBCapstonePJ.twb (Tableau file - charts and dashboard)
- LittleLemon_data.xlsx (Little Lemon Excel data file for Tableau)
- JamieL_DBCapstonePJ.mwb (MySQL Workbench file)
- JamieL_LittleLemon_ForwardEngr_m2_1.sql (Forward engineering)
- JamieL_DBCapstonePJ_All_Scripts.sql (Insert data, and all SQL scripts for this project)
- Related .PNG files (Screenshots included in all PDF files)