New Cases on 16 Total Cases for 16 Province Percentage Total June 2021 June 2021 Eastern Cape 497 201,014 11.3 Free State 617 108,515 6.1 Gauteng 7,859 522,366 29.4 KwaZulu-Natal 592 344,651 19.4...

Section B: Study the scenario and complete the question(s) that follow(s):

Question 4:

Use the information in Table 1 to create a database called COVID and a table called stats. You may use the GUI or command prompt to insert the below records into the table.

please make use of php my admin!!!

Extracted text: New Cases on 16 Total Cases for 16 Province Percentage Total June 2021 June 2021 Eastern Cape 497 201,014 11.3 Free State 617 108,515 6.1 Gauteng 7,859 522,366 29.4 KwaZulu-Natal 592 344,651 19.4 Limpopo 390 68,117 3.8 Mpumalanga 546 86,718 4.9 North West 917 83,799 4.7 Northern Cape 426 55,536 3.1 Western Cape 1,402 303,596 17.1 Table 1 - COVID-19 Dashboard in South Africa (16 June 2021)


Extracted text: About the National Institute for Communicable Diseases The National Institute for Communicable Diseases is a national public health institute of South Africa, providing reference to microbiology, virology, epidemiology, surveillance and public health research to support the government's response to communicable disease threats. The NICD serves as a resource of knowledge and expertise of communicable diseases to the South African Government, Southern African Development Community countries and the African continent. The institution assists in the planning of policies and programmes to support and respond to communicable diseases.