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.

Create or replace, if it already exists, an entity named batchdetails.
Add the attribute batch_id with numerical type, NUMBER(10,0).
Add two characters attributes; batch_number and production_notes both as VARCHAR(255).

Exercise

Adjusting the model

Instructions 1/3

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/3

Exercise