locked
Recipe Database RRS feed

  • Question

  • User-70584582 posted

    I need help making a recipe databse for a school project. The brief requires the user to be able to enter a recipe and store it , come back and retrieve the recipe and also have the ability to calculate recipe figures using the ones originally input e.g if the original says 2 eggs per person the program should be able to make that 4 eggs if the user changes the amount serving to 2.

    Thanks , Oscar

    Thursday, May 2, 2013 12:17 PM

Answers

  • User-1822989843 posted

    Hi Oscar,

    Welcome to ASP.Net Forums..

    As far as Your Query is concerned .. This is a basic Question of Database Design..

    Make Two tables One recipe name with RecipeId as Primary Key Then create Another table as Ingredient table with IndId as Pk and Name and Quantity as other field and RecipeId as Fk..

    The Next step is to calculate the Quantity of the Ingredients based upon the Number of User.. This can be done programmatically where you could multiply the quantity with the number of user in runtime and display the result accordingly..

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 3, 2013 2:46 AM

All replies

  • Thursday, May 2, 2013 5:26 PM
  • User-1822989843 posted

    Hi Oscar,

    Welcome to ASP.Net Forums..

    As far as Your Query is concerned .. This is a basic Question of Database Design..

    Make Two tables One recipe name with RecipeId as Primary Key Then create Another table as Ingredient table with IndId as Pk and Name and Quantity as other field and RecipeId as Fk..

    The Next step is to calculate the Quantity of the Ingredients based upon the Number of User.. This can be done programmatically where you could multiply the quantity with the number of user in runtime and display the result accordingly..

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 3, 2013 2:46 AM