

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
In this document, students are required to use a database to make investment decisions based on daily market prices of five different funds. The goal is to grow an initial $1000 investment as rapidly as possible while following three rules: making an initial investment of $1000, holding only one fund at a time, and making no more than 25 transactions for the entire year. Students must add themselves to the people table and their transactions to the transactions table, then use queries to analyze the data and determine the best times to buy and sell funds. Instructions, examples, and deliverables.
Typology: Assignments
1 / 3
This page cannot be seen from the preview
Don't miss anything!
Imagine if you could predict the daily market price of 5 different investment funds for an entire year. How rapidly could you grow an investment? Obviously, you would know exactly when the funds will increase or decrease. Obviously, you should buy a fund when its market value is low and sell it when its market value is high. However, making good decisions is not as easy as you might think. Especially, when all you are given is raw data. In this homework, we will investigate ways that you can use a database to help make good decisions. The 3 Rules of the Game Its January 1st^ 2004. You have been given a database that predicts the daily market price of 5 different investment funds for the entire year (2004). You can use the database if you follow three rules:
The Database Tables FundNames [Do Not Modify] – The name of the five funds. Used for the lookup fields. Funds [Do Not Modify] – Closing price of the five funds for each day of the year. People [Add yourself] – The names of the investors Transactions [Add your transactions] – Each row is a transaction where you specify the PID of the person who is buy/selling a fund, the amount of the purchase, the date of the purchase, and date of the sale. Queries Analysis [Must Modify] – Returns statistics for every valid transaction that leads to an investment increase. Please modify this query to help you determine when to buy and sell funds. If you modify this query, use Save As to save each version of the query. Increase is the market price increase between the purchased data and sale date. Percentage is the percentage increase between the purchased data and sale date. Time is the number of days between the purchased data and sale date. Normalized is the percentage increase divided by time, which is a good measure of how rapidly the fund is increasing over the time period. Value Increase [Do Not Modify] – Computes the value increase or decrease of each persons’ transactions. Instructions