Welcome to the Cooking Contest Database! This project aims to manage and store data related to cooking contests, including details about recipes, ingredients, portions, cookers, and the contests themselves. The database is designed to efficiently handle various aspects of a cooking contest, from the ingredients used in recipes to the scores given by judges to the participating cookers.
This repository contains a comprehensive framework for organizing cooking contests, complete with recipes, ingredients, cookers, and a structured format for seasons, episodes, and judges.
- Database Management: Utilizes MySQL for robust and scalable data storage.
- Data Generation: Includes a Python script to create and manage dummy data for testing and development.
- Triggers and Procedures: Implements MySQL triggers and procedures to automate and streamline database operations here.
This project is ideal for culinary enthusiasts and event organizers looking to create, manage, and run detailed cooking competitions.
- Recipes Management: Store detailed information about recipes, including ingredients and their portions.
- Ingredients Management: Keep track of all ingredients used in various recipes, along with their nutritional information.
- Cookers Data: Maintain profiles of cookers participating in the contests, including their ranks and personal info.
- Contests Management: Handle data related to cooking contests, including seasons, episodes, and the scores awarded by judges.
- Scoring System: Calculate and store scores given by judges.
To see all images, please visit the PNGs directory.