Recipe Vault App and MunchAI

Project Description

The Recipe Database is a relational database system designed to manage and organize culinary data across a normalized 17 table schema, supporting recipes, ingredients, instructions, tags, cuisines, units, and categories. The schema enforces referential integrity through a network of primary and foreign key relationships, enabling complex multi-table queries that retrieve complete recipe profiles including ingredient quantities with units, step-by-step instructions, cuisine classifications, and user-defined tags in a single join. Designed with scalability in mind, the data model cleanly separates concerns between lookup tables such as Units, Tags, and Cuisine and transactional junction tables such as RecipeIngredients and RecipeTags, following third normal form principles to eliminate redundancy. The accompanying SQL query library covers a full range of development and analytical use cases including complete recipe views, ingredient and tag-based searches, cuisine filtering, and aggregate reporting on recipe distribution by cuisine type. Documentation includes a detailed data dictionary specifying data types, size constraints, null policies, and indexing strategies for every column across all 17 tables, alongside an entity-relationship diagram illustrating the full schema architecture. The project demonstrates relational database design, query optimization with selective JOIN strategies, schema documentation best practices, and the ability to model a real-world domain with complex many-to-many relationships.