Consider the SQL schema generated for the ONLINE_AUCTION database in Laboratory Exercise 8.29 for which the relational database was created and populated in Laboratory Exercise 9.14.

a. Create the database tables in MySQL.

b. Create comma separated data files containing data for at least 20 items with at least 10 buyers and at least 10 sellers. Observe the queries below and make sure that your data will be appropriate for those queries.

c. Using the MySQL loader command, load the data created in (b) into the database.

d. Write SQL queries for the following and execute then in a MySQL interactive session.

i. Retrieve item numbers and descriptions of items that are still active (i.e. bidding has not closed) along with their current bidding price.

ii. Retrieve the item numbers and descriptions of all items in which the member with member id abc24 is the winner.

iii. Retrieve the member ids and names of members who have an average rating of 8.0 or above.

iv. Retrieve the bidding history for the item with item number i246. The bidding history should contain a chronological listing of all bids till the current time including the member id of the bidder and the bidding price.

v. Retrieve the item number and titles of items that fall under the /COMPUTER/HARDWARE/PRINTER category and have "HP" in their titles and on which bidding has not yet closed sorted by time of bid closing.