Database Design
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
ENTITY DEFINITIONS
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.
ADDITIONAL COMMENTS
There cannot be duplicate recipe names in a recipes table, although, as shown above, you can have a "brownies"
recipe from two different cookbooks.
Recipe Book Page
Brownies Desserts 14
Brownies Make It Quick 45
ENTITY DEFINITIONS
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.
ADDITIONAL COMMENTS
There cannot be duplicate recipe names in a recipes table, although, as shown above, you can have a "brownies"
recipe from two different cookbooks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Jim Horn: This is not homework. Should there be “cookbook recipes,” “website recipes,” and “homemade recipes” entities?
@plusone3055: I did not get this design problem from a book. I do not understand your answer; it sounds like you are referring to a book.
The only book I am using to learn database design is the following:
http://www.amazon.com/Database-Design-Mere-Mortals-Hands-/dp/0201752840/ref=sr_1_2?s=books&ie=UTF8&qid=1431613709&sr=1-2&keywords=database+design+for+mere+mortals
@plusone3055: I did not get this design problem from a book. I do not understand your answer; it sounds like you are referring to a book.
The only book I am using to learn database design is the following:
http://www.amazon.com/Database-Design-Mere-Mortals-Hands-/dp/0201752840/ref=sr_1_2?s=books&ie=UTF8&qid=1431613709&sr=1-2&keywords=database+design+for+mere+mortals
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeffrey Coachman: I am using the advice from Michael Hernandez’s book about how to define entities. Here is the link to his book:
http://www.amazon.com/Database-Design-Mere-Mortals-Hands-/dp/0201752840/ref=sr_1_2?s=books&ie=UTF8&qid=1431613709&sr=1-2&keywords=database+design+for+mere+mortals
The database will track information about recipes from different sources. By sources, I mean books, websites and homemade recipes. What other facts do you need to know? The focus of this question is on the "recipes" table(s). I do not want advice on future design, just about "recipes."
http://www.amazon.com/Database-Design-Mere-Mortals-Hands-/dp/0201752840/ref=sr_1_2?s=books&ie=UTF8&qid=1431613709&sr=1-2&keywords=database+design+for+mere+mortals
The database will track information about recipes from different sources. By sources, I mean books, websites and homemade recipes. What other facts do you need to know? The focus of this question is on the "recipes" table(s). I do not want advice on future design, just about "recipes."
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I still feel that the scope of this Q should be narrowed.
JeffCoachman
Do you agree with the entity definitions shown below?It is not clear what a valid "answer" would be to a question this broad and undefined...
JeffCoachman
ASKER
Thank you, Jeffrey Coachman, Jim Horn, plusone3055 and ScottPletcher.
I actually have the book where this problem is in ;)
its just been modified a little bit here
from
TRecipes
TrecipieIngredients
TrecipeInstructions
the chapter is on 1NF
to Author.
heres a hint..
Connect the dots with intrecipieID
and create indexes for your ingredients and instructions