Solve this by using SQL Server, thank you

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. (LO 4) Based on form above a. (15%) Create UNF, 1-NF, 2NF, 3-NF Normalization (Note: The 3-NF result consists of minimum 4 entities). b. (10%) Draw Entity Relationship (ER) Diagram based on 3-NF result. C. (5%) Give an example of Enhanced ER Model based on ER Diagram in 1b answer 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