Deliverables

I. By using the different functions of the database we are able to more easily tell when to buy or sell a stock. All of the information that is stored in the database is available to use and easily organized by using the various functions. Organizing the data is a huge part of the importance of the functions of the database because it makes all of the stored data more available and easier to read, comprehend, access, and utilize the data.

Stocks, Transction_type_code, and Transactions tables are all used in Kelly’s database each for specific reasons. A table is a simple way to organize the data especially in an assignment such as this. All of these tables played important roles in organizing our data and helping us to figure out when to buy or sell our stock in this database. All of the tables had specific functions in which we were able to use to our advantage. For example, the stocks table describes the available stocks or shares in the market by storing related data. We were able to use the Transaction_type_code table to lead us to create the Transaction Rollup query in our database. The Transactions table is an extremely useful table that chronologically lists all of the transactions used over a period of time. These types of transactions include the number of shares as well as the price paid for the shares on top of how much money was earned through the shares.

A query is a report that provides specific data, and in this particular report there were four queries. The average price paid in a given period of time to specific securities is shown by the average purchase price query. This query listed the number of remaining shares and what the total market value of the securities is on top of the securities that were bought by the user. The remaining shares of each security are listed in the Transaction Rollup Query. Shares