Please help, I'm rating every answer.

Case Description: To combat COVID-19 pandemic, the State of New York (NYS) has developed a comprehensive vaccination plan to distribute CDC-approved vaccines for all state residents.

You are invited to design a relational database to keep track of all the COVID-19 vaccinations administered in the state.

Specifically, when a person is administered a COVID-19 vaccine dose, a vaccination record is generated to keep track of:

• Person-related details, including PersonName, ZipCode, PersonCounty, FullyVaccinated (Y/N)
• Vaccine-related details, including VacID, VacName, DoseReq (1 or 2 doses)
• Vaccination-related details, including: VacID, VacName, DoseNum (1st or 2nd dose), VacDate
• Vaccination Site-related details, including: SiteID, SiteName

COVID-19 vaccines can be classified into the following three types:

• mRNA vaccine: Uses lab-created mRNA encapsulated within nanoparticles (e.g., Pfizer, Moderna)
• Vector vaccine: Uses weakened virus (viral vector) (e.g., Johnson & Johnson, Oxford-AstraZeneca)
• Protein subunit vaccine: Uses weakened/attenuated, or inactivated (killed) virus (e.g., Novavax)

Question: Draw an Extended Entity Relationship Diagram (EERD) for this NYS COVID-19 Vaccination System. List all entities, primary keys (underlined), foreign keys (marked as [FK]), attributes, and relationships (including generalization/specialization, disjoint/overlapping/partial/total completeness relationship)