You are given a database containing the previously described tables to provide some results for MGMT eCash Inc. (That is, your CI will provide you with the database). You should:

a. three (3) crypto codes and accompanying data to the CryptoCodes table. One of the codes you add must be your name shown as one word (e.g. if your name is Catherine Gibson, then your CurrencyName will be catherinegibson and the Symbol will be CRG).

b. historical data for 2017-11-8 (yes make it up). That is add 20 records to the CRYPTOHISTORY table, one record for each of the 20 currencies.

4. Create the following queries:

a. List, sorted by name, each exchange, its trading pairs greater than 200, and the volume (in bitcoins) for the last 24 hours available at the time your investigation started. Name this query Q1-Exchanges.

b. List the name, symbol, price and market capitalization for the top 12 currencies at the time your investigation started. Name this query Q2-MarketCap.

c. From the historical currency data, what was the ATH for each currency? Show symbol, name and ATH. Name this query Q3-ATHCurrency.

d. Either:

What is the average opening price, for bitcoins (BTC), for each month, in the period Jan- 2017 to Jun-2017? Display only the symbol, month (number or name is acceptable) and average opening price formatted as currency. Name this query Q4- AvgBitcoinPrices.

Or:

What is the average price at opening and closing for all cryptocoins beginning with the letter "B" symbol. Display the symbol, currency name and the average price at opening and closing. Name the query Q4-AvgBitcoin Prices.

e. At the time of your study, a number of currencies were trading for over $1000 USD however you are only interested in the ones that are in your list of 20 currencies that are also over $1000 USD. For these currencies only, produce a query that shows the last MGMT2006 Project S1: 2023-2024 4 know market capitalization from the original historical records (i.e. the day before your unique data) and also show the market capitalization at the time of your study, the price, currency name, and symbol. Label columns appropriately to remove any ambiguity. All currency columns should be formatted. Hint: you could create 2 queries, i.e. and intermediate and then a final result. Name the final result query Q5-CompareMarketcaps.

5. In the database, create a report that shows, the totals for the history of each cryptocode. Give the report an appropriate title, format the values as currency and rename the column headings appropriately. Sort the report in ascending order by cryptocode and currency name; display the title on each page. Hints: For queries, when using the totals options, consider the "where" and "expression" clauses also. Investigate "top 10" queries in Access. Create a separate query for the report.