The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Recipes with Grocery List Maker...
This data model was designed to handle Recipes with the added advantage of adding to your Grocery List.  (Note, there only tables included in this database the balance is up to you!  Some tables contain sample data.)
Business Rules...

will have different Levels (Easy, Intermediate and Hard)

may have other Recipe Parts, i.e. Apple Pie recipe will be associated with Pie Crust recipe

will have steps

There will be many Recipes


Main Entities...


Download Sample (Access 2007 and up and an unzipping program needed)

will have Ingredients

can be in multiple Categories

will have Nutritutional Information

will of different Cusines

can be eaten at different times of the day (Courses)

Added bonus of Menus so you can attach items like Turkey, Mashed Potatoes, etc. to a Christmas Menu


will come in different sizes

There will be many Groceries


will have different Brands

will come from different Stores

will be Categorized

Added bonus of Grocery Items entered are from Grocery List Maker database

You can design the database to that Recipes added will automatically add ingredients to Grocery List

Ingredients can be linked to Groceries