ZuoTi.Pro
Question

Recipe PK  Recipe Key Ingredient PK IngredientKey 1. Create a diagram that shows how you would resolve...

Recipe
PK  Recipe Key
Ingredient
PK IngredientKey

1. Create a diagram that shows how you would resolve the relationship in the diagram above.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

1.

Recipe Ingredient PK IngredientKey PK Recipe Key Recipe_Ingredient PK FK Recipe Key PK FK IngredientKey

Recipe can have one or more Ingredients where as An ingredient can be part of many recipes and also it cannot be party of any. Relationship between Recipe and Ingredient is Many-to-Many.We can break the Many-to-Many relationship by adding Bridge table and splitting into One-to-Many : Many-to-One relaitonship.

The bridge table Recipe_Ingredient has the foreign keys Recipe Key , IngredientKey referred from Recipe and Ingredient respectively.

0 0
Add a comment
Know the answer?
Add Answer to:
Recipe PK  Recipe Key Ingredient PK IngredientKey 1. Create a diagram that shows how you would resolve...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1. Write a class that represents a Recipe as shown in the UML diagram below. Recipe...

    1. Write a class that represents a Recipe as shown in the UML diagram below. Recipe -name: string -cookTime: int -prepTime: int - ingredients: ArrayList<String> +Recipe(String name, int cTime, int pTime, String... ingredients) +Recipe(String name, int cTime, int pTime) +getNumberOfIngredients(): int +addIngredient(String ingredient): void +getName(): String +getTotalRecipeTime(): int +get Ingredient(int index): String +remove Ingredient(String ingredient): String

  • For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a...

    For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a many-to-many relationship between DeVry University students and their classes. Since one student can have many classes and each class can have many students, you will need to create an associative entity to store the specific Student_Class data such as grade and attendance. Create the tables as well as the relationships. Don't forget to indicate the Primary Key and Foreign Key in each table. Tables...

  • 1. For the insertFirst method, create a diagram which shows how an existing list (you have...

    1. For the insertFirst method, create a diagram which shows how an existing list (you have to draw it) with 3 elements must be modified by this method. Label the modification steps in the order in which they must be coded. 2. For the removeFirst method, create a diagram which shows how an existing list (you have to draw it) with 3 elements must be modified by this method. Label the modification steps in the order in which they must...

  • How to build Java test class? I am supposed to create both a recipe class, and...

    How to build Java test class? I am supposed to create both a recipe class, and then a class tester to test the recipe class. Below is what I have for the recipe class, but I have no idea what/or how I am supposed to go about creating the test class. Am I supposed to somehow call the recipe class within the test class? if so, how? Thanks in advance! This is my recipe class: package steppingstone5_recipe; /** * *...

  • ER Diagram of Online Sale System Product ProductID OrderID DepartmentID Product Name Price Cutomer PK CustomerID...

    ER Diagram of Online Sale System Product ProductID OrderID DepartmentID Product Name Price Cutomer PK CustomerID Order OrderID PK Full Name FK1 FK2 CustomerID StoreID Sales Amount Date Time PK Store StorelD Store Name Consider the ER diagram of online sales system above. Based on the diagram answer the questions below, a) Based on the ER Diagram, determine the Foreign Key in the Product Table. Just mention the name of the attribute that could be the Foreign Key (2 marks]...

  • Prompt: In this stepping stone lab assignment, you will build a Recipe class, getting user input...

    Prompt: In this stepping stone lab assignment, you will build a Recipe class, getting user input to collect the recipe name and serving size, using the ingredient entry code from Stepping Stone Lab Four to add ingredients to the recipe, and calculating the calories per serving. Additionally, you will build your first custom method to print the recipe to the screen. Specifically, you will need to create the following:  The instance variables for the class (recipeName, serving size, and...

  • Problems Problem 1 The total ingredient cost in a recipe is $4.73; the manager desires a...

    Problems Problem 1 The total ingredient cost in a recipe is $4.73; the manager desires a 37.5-percent food cost. What is the base selling price of the item using the ingredients mark-up method? Should the manager price the item in the above example at the base selling price you calculated? Why or why not? Problem 2 The chef has precosted the recipe for an entrée and a sauce, which is one item on the menu: the food cost is $6.34....

  • 1. describe how you would develop a staff education program and create an outline of key...

    1. describe how you would develop a staff education program and create an outline of key points that you would include CASE STUDY ing from 175 to 321 beds, f few weeks ago you were hired as Director of Patient Edu- stion for a regional medical center located in the Midwest. medical center includes three community hospitals rang- 175 to 321 beds, four outpatient clinics, and five cen- of excellence. The five centers of excellence are located at of the...

  • 3) Create a low-level design diagram (collaboration or sequence diagram) that clearly show how yo...

    3) Create a low-level design diagram (collaboration or sequence diagram) that clearly show how you would structure your code to achieve the following use case. a. The user wants to view the top ten most-watched movies or TV-shows of 2018

  • CAN YOU PLEASE EXPLAIN IN TASK 3 - HOW DO WE REPRESENT TOTAL PARTICIPATION AND KEY...

    CAN YOU PLEASE EXPLAIN IN TASK 3 - HOW DO WE REPRESENT TOTAL PARTICIPATION AND KEY CONSTRAINTS IN SQL CODE. PLEASE PROVIDE SOLUTION AND DETAILED EXPLANATION. I WOULD REALLY APPRECIATE IF YOU CAN HELP ME WITH THE ABOVE 2 QUESTIONS. I WILL DEFINITELY RATE!! Thank you. Task 2 [40 points Given an ER diagram (as shown below), write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT