Consider a table consisting of data about dishes and the ing…

Consider a table consisting of data about dishes and the ingredients used to prepare them. Three attributes are present in this table: DishID, which is the ID for a dish; IngredientID, which is the ID for a specific ingredient; IngredientPrice, which is the price for the ingredient. The price of an ingredient is independent from the dishes the ingredient is used.   Consider the following two scenarios:  Scenario 1: Each dish has exactly one ingredient being used;  Scenario 2: Each dish has one or more than one ingredients used.   You may also assume that the relation table is already in 1NF, meaning that there are no multi-valued attributes and the primary key(s) are identified. This means that in scenario 1, the primary key is DishID and in scenario 2, the primary keys are DishID + IngredientID. Which of the following statement is true?