Results 1 to 5 of 5
  1. #1
    Mandla is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    2

    Database Design for summer camp

    Create a sample menu database for use in our camp kitchen to enable the kitchen manager to plan menu and ingredient lists. Each week he needs to know how many ingredients he needs in order to be able to cater for the number of guests coming to camp that week (anything from 10 to 200 people per meal for 7 days of the week). You can work out what tables you would need to include bearing in mind the following:

    ¨ A weekly menu (7 days) with three meals a day.

    ¨ For each meal the kitchen manager needs to be able to select from a list of different recipes. There will be at least three options for each meal which the manager will select. EG For lunch the manager could choose between hot dogs, spaghetti and sausage rolls with mashed potato.

    ¨ He should be able to enter the recipe description and all the ingredients for each meal choice and ingredients. There might be sub-menus for some recipes eg A recipe to bake the bread rolls when serving hot dogs.



    ¨ The kitchen manager should have the option of adding more meal choices with their corresponding recipes and ingredient.

    ¨ A kitchen manager should be able to use this database to tell him how many ingredients he will need to feed a specific number of people. For example, if he is catering for hot dogs for lunch on Monday for 200 people, he needs to know many hot dogs he will he need to order and how much bread roll mix will he need to buy.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Is this some sort of homework/class assignment?

    Is there a question here???

  3. #3
    Mandla is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    2
    It my assignment lol

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I don't think you will find anyone willing to do your assignment for you, but if you have specific questions, we may be able to answer them or at least give you some hints and point you in the right direction.

  5. #5
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    You might look here to get some design ideas that you could adapt/modify to your needs.

    http://www.databaseanswers.org/data_models/

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

Similar Threads

  1. Replies: 11
    Last Post: 02-18-2021, 12:11 PM
  2. Camp management software
    By Fatbiker in forum Access
    Replies: 3
    Last Post: 08-07-2015, 01:21 PM
  3. Designing db for a day camp
    By mordecai98 in forum Database Design
    Replies: 3
    Last Post: 11-11-2013, 01:07 AM
  4. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  5. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 AM

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