Database Design Testing (ID_testing,date,observerId) Observer(observerId,observer_name) Type(TypeId,typename) Essentialoil (ID_essential,essentialname,typeId,batchcode) Constituent (ID_constituent,cname,min_percentage,Test_percentage,status) 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. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization 2. Develop the ERD that you create to implement Generalization / Specialization.
Testing (ID_testing,date,observerId)
Observer(observerId,observer_name)
Type(TypeId,typename)
Essentialoil (ID_essential,essentialname,typeId,batchcode)
Constituent (ID_constituent,cname,min_percentage,Test_percentage,status)
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. Make an ERD (Entitiy Relationship Diagram) based on the results of Normalization
2. Develop the ERD that you create to implement
Generalization / Specialization.
Step by step
Solved in 2 steps with 2 images
