Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[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

image text in transcribed

[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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions