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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!