This project aims to develop and manage databases for the fictional businesses Bagel Corner and Mister Coffee. It includes tasks such as creating entity-relationship models, constructing databases in MySQL, and scripting SQL for various data operations.

• Languages Used
• Technologies Used
• Features
• Installation
• Usage
• Bagel Corner Database Blueprints
• Mister Coffee Entity-Relationship Diagram
• License

• SQL

• MySQL

• Entity-Relationship (ER) Modeling for Bagel Corner and Mister Coffee.
• Database creation and management in MySQL.
• SQL scripting for data insertion, manipulation, and querying.
• Optimization of database performance through indexing and view creation.

1. Install MySQL on your machine.
2. Clone the project repository.
3. Execute the included bagel_corner_mister_coffee_db_script.sql SQL script in MySQL to initialize the databases.

• Interact with the databases using MySQL Workbench or a similar tool.
• Execute the SQL scripts to perform various database operations.

To see an example of a PDF form for orders placed with Bagel Corner: Bagel Corner Catering Order Form

MIT License