Question: [1 Mark] [2 Marks) a. Create the database pandemic' with MySQL. b. Create the following virus table in your pandemic database. Field Name Data Type
![[1 Mark] [2 Marks) a. Create the database pandemic' with MySQL.](https://s3.amazonaws.com/si.experts.images/answers/2024/09/66d8dd6db5877_49366d8dd6d3108a.jpg)
[1 Mark] [2 Marks) a. Create the database pandemic' with MySQL. b. Create the following virus table in your pandemic database. Field Name Data Type Length / Field Size VirusID VARCHAR 10 Virus Name VARCHAR bo DOA DATE Severity VARCHAR 20 Cases Reported INT [2 Marks) c. Enter following records into the virus table. VirusID VirusName DOA Severity V101 Alpha Variant 14-04-2021 High V102 Beta Variant 15-09-2021 Critical V103 Omicron 10-12-2021 Mild Cases 5000 12000 1000 d. Write necessary PHP script to establish a connection with the pandemic database and search the record with VirusID from the virus table with the help of a search form and display it on your webpage in a table format as shown below. [5 Marks] Search Pandemic Virus Details: Enter VirusID to Search: V101 Search db connection ok Result is Ready VirusID Virus Name DOA Severity Cases V101 Alpha Variant 2021-04-14 High 5000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
