Database System — MS Access

Recipe Management System

Project Report

Recipe Management System IN ACTION

Viewing Ingredients by Allergen Report. This report pulls information from the Ingredients by Allergen Query.

Project About

The Dietary-Safe Recipe Management Database is a relational database system.

Built using Microsoft Access, the project serves as a foundational blueprint for a future mobile application designed to assist individuals with rare metabolic conditions and dietary restrictions.

Database Architecture

The system is built on a relational model consisting of five key tables:

Primary Entities:

  • tblRecipes: Stores recipe names and preparation instructions.

  • tblIngredients: A master list of ingredients and their safety status (specifically for Galactosemia).

  • tblAllergens: Categorizes allergen types such as Dairy, Gluten, or Peanuts.

  • 2 Junction Tables: Facilitate many-to-many relationships, allowing one recipe to have many ingredients and one ingredient to be linked to multiple allergens.

User Interface & Functionality

  • Queries: Specialized SQL queries enable users to extract targeted information, such as listing all recipes containing a specific allergen like dairy.

  • Forms: User-friendly interfaces simplify data entry for adding new recipes, ingredients, or allergen categories.

  • Reports: The system generates professional summaries, such as the Ingredients By Allergen report, which groups all stored items by their known dietary risks.

Core Objectives

  • Centralization: Create a single, reliable repository for recipes, ingredients, and allergen data.

  • Verification: Allow users to quickly verify if a recipe is safe for their specific dietary restrictions.

  • Integrity: Ensure accurate links between ingredients and allergens to prevent redundancy and data errors.

Project Significance

The project successfully met its goals of identifying and reporting on unsafe ingredients. It functions as the technical foundation for a larger-scale mobile application: SafeZone Dietary Restriction Community Mobile App

View SafeZone Project

Diagrams

Entity Relationship Diagram

Entity Relationship Diagram

Queries

Ingredients By Allergen Query

Ingredients By Allergen Query

SQL: Ingredients by Allergen Query

SQL: Ingredients by Allergen Query

Recipes by Ingredient Query

Recipes by Ingredient Query

SQL: Recipes by Ingredient Query

SQL: Recipes by Ingredient Query

Unsafe Ingredients for Galactosemia Query

Unsafe Ingredients for Galactosemia Query

SQL: Unsafe Ingredients for Galactosemia Query

SQL: Unsafe Ingredients for Galactosemia Query

Forms, Reports, & Tables

Allergen Form

Allergen Form

Ingredients Form

Ingredients Form

Recipes Form

Recipes Form

Ingredients by Allergen Report

Ingredients by Allergen Report

Ingredients List Report

Ingredients List Report

Unsafe Ingredients List Report

Unsafe Ingredients List Report

Allergen Table

Allergen Table

Ingredients Table

Ingredients Table

Recipes Table

Recipes Table