Consider the following reports about cereal produced by Kellog’s. The report show the supplier list and ingredient of va
Posted: Fri May 20, 2022 11:15 am
Consider the following reports about cereal produced by
Kellog’s. The report show the supplier list and ingredient of
various products by Kellog (for example; Corn Flake contains Corn,
malt etc..) . (note: all data is fictional)
Ques#2. Consider the following reports about cereal produced by Kellog's. The report show the supplier list and ingredient of various products by Kellog (for example; Corn Flake contains Corn, malt etc... (note: all data is fictional) (10 points) FDA Report #6272 Date: 04/30/19 Issuer: Kellog's Corpororation Report Title: Product Summary by Ingredients Supplier's List Date: 04/30/19 Corn Ingredients Supplier Price Corn 3.75 2.10 Corn Syrup 0.83 Wheat Corn Flakes Krispx Nutrigrain etc. Rice Krispies Frosted Flakes Sugar Pops etc. Rice Krispies Sugar Smacks Corn Flakes etc. Sugar Smacks Nutrigrain etc. Lever Lorrain Johnny Lever Kropt. Harry Potter Malt 3.25 1.10 1.85 1.84 Barley Wheat Given the above reports: a. Identify entities and draw an ERD (make sure to specify nature of relationships and cardinalities) (list any assumptions made)
b. Convert it into 3NF 1stNF 2nd NF 3rd NF
Kellog’s. The report show the supplier list and ingredient of
various products by Kellog (for example; Corn Flake contains Corn,
malt etc..) . (note: all data is fictional)
- Consider The Following Reports About Cereal Produced By Kellog S The Report Show The Supplier List And Ingredient Of Va 1 (212.67 KiB) Viewed 44 times
b. Convert it into 3NF 1stNF 2nd NF 3rd NF