Results 1 to 5 of 5
  1. #1
    LoftusAK is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    Beginners questions

    I am new to Access, taking a class for school, and am having a hard time designing my tables so that they have a reasonable amount of fields. It feels like I either have too many or only two, including the ID.


    I am trying to design a database that will allow me to find recipes from cook books based on what I have in my kitchen, instead of finding a recipe and hoping I have all the ingredients. I guess what I'm asking is if anyone might be able to offer some advice on what I should keep in mind when building my tables and creating relationships; do I really have to put each ingredient and measurement in a separate table and create junction tables between all of them?

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Just a few thoughts :

    We have many COOKBOOKS.
    Each COOKBOOK has many RECIPES.
    Each RECIPE has many INGREDIENTS.
    Each RECIPE might belong to a particular CATEGORY ( perhaps something like, Veg Dishes, Salads, Meat Dishes, Desserts, etc).
    Each INGREDIENT has perhaps a MEASURE type associated with it (ounce, teaspoon, pounds, gms, etc).

    tblCookBooks
    CookBookID - PK
    cookBookName
    cookBookAuthor
    ....

    tblRecipes
    RecipeID - PK
    CookBook_ID - FK
    RecipeName
    RecipeCategory_ID - FK

    tblRecipeCategory
    RecipeCategoryID - PK
    RecipeCategory

    tblRecipesIngredients
    RecipesIngredientsID - PK
    Recipe_ID - FK
    Ingredient_ID - FK
    IngredientMeasureQuantity

    tblIngredients
    IngredientID - PK
    IngredientName
    IngredientMeasureType_ID - FK

    tblIngredientMeasureType
    IngredientMeasureTypeID - PK
    IngredientMeasureType

    Functionally do not know anything about Cooking & Recipes, hence you might as well take my thoughts with a pinch of salt.

    Edit : There is a good possibility, that you might need to include the IngredientMeasureTypeID as FK in tblRecipesIngredients instead of tblIngredients .

    Thanks

  3. #3
    LoftusAK is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2
    Thank you for the advice. This will help me greatly in designing my tables and building the necessary relationships.

  4. #4
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    H2H - Happy to Help.

    Thanks

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 04-01-2012, 12:50 PM
  2. QBF Questions
    By brandonze in forum Forms
    Replies: 2
    Last Post: 08-04-2011, 01:49 PM
  3. New Guy Structure questions
    By cgjames in forum Database Design
    Replies: 11
    Last Post: 01-19-2011, 07:16 AM
  4. Beginners question
    By nashr1928 in forum Access
    Replies: 4
    Last Post: 07-19-2010, 11:20 AM
  5. a beginners question
    By bluelondon in forum Access
    Replies: 0
    Last Post: 07-12-2007, 04:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums