Adjusting the model
Cocofarm is a business specializing in chocolate review and analysis. They use the productqualityrating entity as part of their data model. This entity contains comprehensive data about various chocolate bars, including their manufacturers, place of production, reviews, bean origin, cocoa percentage, ingredients, and ratings. The business uses this data to provide detailed reviews and quality ratings of chocolate, helping consumers and professionals make informed choices.
The business has decided to enhance its review process by adding production batch details for each chocolate product. Your task is to adapt the existing data model to include these production batch details and establish a relationship between that new entity and the current product quality rating.
This exercise is part of the course
Introduction to Data Modeling in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create entity
___
-- Add numerical attribute
___,
-- Add characters attributes
___,
___
);