Question: It is clear. A. Modify the data model shown below to satisfy some new business requirements. The data model records the needs of a cereal

It is clear.
A. Modify the data model shown below to satisfy some new business requirements. The data model records the needs of a cereal manufacturing company like Kellogg's Nestl, etc. BRAND refers to trademark brands such as Special K Coco Pops etc. For each brand, PRODUCTS include cereals, bars, etc. For each product they keep its ingredients, and they offer to customers some recipes with the product. New requirements include Keeping a list of nutrients. A nutrient may relate to a number of ingredients. In relation to each product's ingredients, we should keep the quantity of each ingredient in a given product Products are categorized in many ways. For example, they belong to the Healthy Line, Kids Line, etc. RRAND Brand Name Description PRODUCT INGREDIENT Product came IngredientName Description > Product Type RECIPE Recipe Name B. Convert the above dato model to the database design of an operational database by extracting a set of relations. Consider using surrogate keys where necessary and show for all of your relations the primary, foreign and candidate keys
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
