I am working on defining three entities to track cookbook recipes. In the future, tables will be added to track recipes from web sites and homemade recipes. Do you agree with the entity definitions shown below? Here is some sample data:
Recipe Book Page
Brownies Desserts 14
Brownies Make It Quick 45
Cookbook Recipes: A set of instructions for preparing a dish from a given cookbook.
Cookbooks: The name of a book containing a set of instructions needed to prepare a given dish.
Cookbook Recipe Details: Allows the cook to track recipes and related information. It allows the cook to quickly track and
find information about recipes.
There cannot be duplicate recipe names in a recipes table, although, as shown above, you can have a "brownies"
recipe from two different cookbooks.