I am a college student needing some help with Lucidchart. I am working on the attached data dictionary and need some help with the following:

Directions

1. Use Lucid ChartLinks to an external site.
2. describe the entities for a Logical Entity Relationship Diagram (ERD) based on the data dictionary .
3. describe the entities for a Physical ERD based on the data dictionary .
4. Explain the justification for the level of normalization (e.g., why did you not normalize or more than you chose to).

Original Source Field Name	Database Field Name	Data Type	Short Description	Is the Field Required?
location	location_id	object	Description of location	Yes
date	date_id	object	Description of date	Yes
total_cases	total_cases_id	float64	Description of total_cases	Yes
new_cases	new_cases_id	float64	Description of new_cases	Yes
total_deaths	total_deaths_id	float64	Description of total_deaths	Yes
new_deaths	new_deaths_id	float64	Description of new_deaths	Yes
date	date_id	datetime64	Date of the vaccination record	Yes
location_key	location_key_id	object	Key representing the location	Yes
new_persons_vaccinated	new_persons_vaccinated_id	float64	Count of new persons vaccinated	Yes
cumulative_persons_vaccinated	cumulative_persons_vaccinated_id	float64	Description of cumulative persons vaccinated	Yes
new_persons_fully_vaccinated	new_persons_fully_vaccinated_id	float64	Description of new persons fully vaccinated	Yes
cumulative_persons_fully_vaccinated	cumulative_persons_fully_vaccinated_id	float64	Description of cumulative_persons_fully_vaccinated	Yes
new_vaccine_doses_administered	new_vaccine_doses_administered_id	float64	Description of new_vaccine_doses_administered	Yes
cumulative_vaccine_doses_administered	cumulative_vaccine_doses_administered_id	float64	Description of cumulative_vaccine_doses_administered	Yes
new_persons_vaccinated_pfizer	new_persons_vaccinated_pfizer_id	float64	Description of new_persons_vaccinated_pfizer	Yes
cumulative_persons_vaccinated_pfizer	cumulative_persons_vaccinated_pfizer_id	float64	Description of cumulative_persons_vaccinated_pfizer	Yes
new_persons_fully_vaccinated_pfizer	new_persons_fully_vaccinated_pfizer_id	float64	Description of new_persons_fully_vaccinated_pfizer	Yes
cumulative_persons_fully_vaccinated_pfizer	cumulative_persons_fully_vaccinated_pfizer_id	float64	Description of cumulative_persons_fully_vaccinated_pfizer	Yes
new_vaccine_doses_administered_pfizer	new_vaccine_doses_administered_pfizer_id	float64	Description of new_vaccine_doses_administered_pfizer	Yes
cumulative_vaccine_doses_administered_pfizer	cumulative_vaccine_doses_administered_pfizer_id	float64	Description of cumulative_vaccine_doses_administered_pfizer	Yes
new_persons_vaccinated_moderna	new_persons_vaccinated_moderna_id	float64	Description of new_persons_vaccinated_moderna	Yes
cumulative_persons_vaccinated_moderna	cumulative_persons_vaccinated_moderna_id	float64	Description of cumulative_persons_vaccinated_moderna	Yes
new_persons_fully_vaccinated_moderna	new_persons_fully_vaccinated_moderna_id	float64	Description of new_persons_fully_vaccinated_moderna	Yes
cumulative_persons_fully_vaccinated_moderna	cumulative_persons_fully_vaccinated_moderna_id	float64	Description of cumulative_persons_fully_vaccinated_moderna	Yes
new_vaccine_doses_administered_moderna	new_vaccine_doses_administered_moderna_id	float64	Description of new_vaccine_doses_administered_moderna	Yes
cumulative_vaccine_doses_administered_moderna	cumulative_vaccine_doses_administered_moderna_id	float64	Description of cumulative_vaccine_doses_administered_moderna	Yes
new_persons_vaccinated_janssen	new_persons_vaccinated_janssen_id	float64	Description of new_persons_vaccinated_janssen	Yes
cumulative_persons_vaccinated_janssen	cumulative_persons_vaccinated_janssen_id	float64	Description of cumulative_persons_vaccinated_janssen	Yes
new_persons_fully_vaccinated_janssen	new_persons_fully_vaccinated_janssen_id	float64	Description of new_persons_fully_vaccinated_janssen	Yes
cumulative_persons_fully_vaccinated_janssen	cumulative_persons_fully_vaccinated_janssen_id	float64	Description of cumulative_persons_fully_vaccinated_janssen	Yes
new_vaccine_doses_administered_janssen	new_vaccine_doses_administered_janssen_id	float64	Description of new_vaccine_doses_administered_janssen	Yes
cumulative_vaccine_doses_administered_janssen	cumulative_vaccine_doses_administered_janssen_id	float64	Description of cumulative_vaccine_doses_administered_janssen	Yes
new_persons_vaccinated_sinovac	new_persons_vaccinated_sinovac_id	float64	Description of new_persons_vaccinated_sinovac	Yes
total_persons_vaccinated_sinovac	total_persons_vaccinated_sinovac_id	float64	Description of total_persons_vaccinated_sinovac	Yes
new_persons_fully_vaccinated_sinovac	new_persons_fully_vaccinated_sinovac_id	float64	Description of new_persons_fully_vaccinated_sinovac	Yes
total_persons_fully_vaccinated_sinovac	total_persons_fully_vaccinated_sinovac_id	float64	Description of total_persons_fully_vaccinated_sinovac	Yes
new_vaccine_doses_administered_sinovac	new_vaccine_doses_administered_sinovac_id	float64	Description of new_vaccine_doses_administered_sinovac	Yes
total_vaccine_doses_administered_sinovac	total_vaccine_doses_administered_sinovac_id	float64	Description of total_vaccine_doses_administered_sinovac	Yes
Country name	country_name	text	The name of the country	Yes
Date	date	date	The date the data was reported	Yes
New Cases	new_cases	integer	The number of new COVID-19 cases reported on the given date	Yes
Total Cases	total_cases	integer	The total number of COVID-19 cases reported in the country up to the given date	Yes
New Deaths	new_deaths	integer	The number of new deaths reported on the given date	Yes
Total Deaths	total_deaths	integer	The total number of deaths due to COVID-19 reported in the country up to the given date	Yes
New Vaccinations	new_vaccinations	integer	The number of new COVID-19 vaccinations administered on the given date	Yes
Total Vaccinations	total_vaccinations	integer	The total number of COVID-19 vaccinations administered in the country up to the given date	Yes
State	state	text	The name of the state	Yes
Hospitalized	hospitalized	integer	The number of COVID-19 patients currently hospitalized in the state	Yes
In ICU	in_icu	integer	The number of COVID-19 patients currently in intensive care in the state	Yes
On Ventilator	on_ventilator	integer	The number of COVID-19 patients currently on ventilators in the state	Yes
County Name	county_name	text	The name of the county	Yes
State Name	state_name	text	The name of the state	Yes
Date	date	date	The date the data was reported	Yes
Total Tests Conducted	total_tests	integer	The total number of COVID-19 tests conducted in the county up to the given date	Yes
Positive Cases	positive_cases	integer	The total number of positive COVID-19 cases reported in the county up to the given date	Yes