solve NUMBER 2 by using SQL Server and by typing. ( For the number 1a & 1b ) -> https://www.chegg.com/homework-help/questions-and-answers/essential-oil-id-eo-name-botanical-family-extraction-method-steam-distillation-cold-presse-q67896932?trackid=JBpyoxWE

I PREFER TYPED ANSWERS

Thank you :D !

Essential Oil ID: EO Name: Botanical Family: Extraction Method: Steam Distillation/ Cold Pressed/ Absolute Extraction/ Resin Tapping Part of plant: Flower/ Seed/Root/ Fruit/ Leaf/ Stem/ Resin/ Bark Origin Country ID: Origin Country Name: ORAC: Chemical Constituent ID Chemical Constituent Name Percentage Number of Chemical Constituent: 1. a & b answer -> https://www.chegg.com/homework-help/questions-and- answers/essential-oil-id-eo-name-botanical-family-extraction-method- steam-distillation-cold-presse-967896932?trackid=JBpyoxWE 2. (LO 3) Based on ER Diagram in 1b answer, write DML statement to: a. (10%) show essential oil name that still does not have any chemical constituent recorded. b. (10%) show essential oil name, chemical constituent name, percentage that has ORAC value greater than 100.000, sorted by essential oil name and chemical constituent name. C. (15%) show essential oil name that consists of Eucalyptol or Limonene as chemical constituent by using Nested Sub Queries. d. (15%) create a view to show essential oil name, number of chemical constituents for each essential oil that comes from France or Italy