ID Testing: ID Essential Oil: Date: Essential Oil Name: Observer ID: Essential Oil Type: Single/ Blended Observer Name: Batch Code: ConstituentID Constituent Minimum Test Status Name Percentage Percentage Content Content
Before an Essential Oil product is marketed, testing is carried out based on the production batch from any essential oil. This is done to maintain the quality and content of the existing constituents in essential oils. Where the Test Percentage Content must reach the Minimum standard Percentage Content for each constituent. If there is one type of constituent that does not fulfill minimum standard, the batch will not be marketed because it does not meet the standard quality.
Question
1. Create 1-NF, 2-NF, 3-NF Normalization for the available forms.
2. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization 3-NF.
3. Develop the ERD that you create to implement Generalization / Specialization.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
