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.

[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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!