1. Hereunder is the Database ER diagram. Write a reasonable set of assumptions for this.
2. Explanation of normalisation challenges and the resulting changes.
3. Write the Database schema.
 

CountryLocManufacturer iso_code mfd_date vaccine_id total_vaccinations IN 1..N CountryDailyVaccination iso_code daily observation_date LN total vaccinations people vaccinated people_fully_vaccinated. total boosters vaccine type_id 1..N 1.1 iso_code (PK) location 1..1 1..1 vaccine_id [PK] vaccine name Vaccine 1..1 Location 1..1 1.N 1..1 Vaccine Types 1..N vaccine_type_id (PK) vaccine_type_names iso_code 11 1..1 1..N AgeGroup_vaccination age_group_id 1N iso_code observation date people_vacc_per_hundred people_fuly_vacc_per_hundred people with booster_per_hundred CountryObservation iso_code 1.1 last observation_date source_name source_website source_url vaccine type_id 1..N 1.N 1..N 1.1 iso_code observation_date total_vaccinations people vaccinated people_fully_vaccinated total_boosters age_group_id[PK] age_group_name 1.N daily_vaccinations_raw daily vaccinations US StateVaccination location iso_code daily observation_date total vaccinations total_vacc_distributed people vaccinated i people_fully_vacc_per_hundred 1.N total vacc per hundred people_fully_vaccinated people_vaccinated_per_hundred vacc_distributed_per_hundredi AgrGroup 1.N CountryAllObservVaccinations daily_vacc_raw daily_vacc daily vaccination_per_million share_doses_used total boosters total_boosters_per_hundred total vaccination_per_hundredi people_vaccinated_per_hundred people_fully_vaccinated_per_hundred total boosters_per_hundred daily vaccinations_per_million daily people vaccinated daily people_vaccinated_per_hundred