This question is based on stocksdb database. You will also need the DBI and RMySQL packages, as well as the ggplot2 package in R.

a) Load the Transaction table into a data frame tDF in R using the dbReadTable command (similar to what we did in class and assignments). Show the R-Code.

(While you need to create the connection string and run it in R, you need not show that code here; it is sufficient to show the R code for dbReadTable).

b) In the data frame tDF, use the command tDF$PriceInt <- as.integer(tDF$Price) to create a new PriceInt column (This is simply the integer version of the price column).

Plot the histogram of this PriceInt . Show the R-Code and the Result.

c) Plot the histogram of PriceInt using the transaction type as the facet. (Hint: Use the facet_wrap feature in ggplot). Show the R-Code and the Result.

This question is based on stocksdb database. You will also need the DBI and RMySQL packages, as well as the ggplot2 package in R.

a) Load the Transaction table into a data frame tDF in R using the dbReadTable command (similar to what we did in class and assignments). Show the R-Code.

(While you need to create the connection string and run it in R, you need not show that code here; it is sufficient to show the R code for dbReadTable).

b) In the data frame tDF, use the command tDF$PriceInt <- as.integer(tDF$Price) to create a new PriceInt column (This is simply the integer version of the price column).

Plot the histogram of this PriceInt . Show the R-Code and the Result.

c) Plot the histogram of PriceInt using the transaction type as the facet. (Hint: Use the facet_wrap feature in ggplot). Show the R-Code and the Result.