Assignment title: Information


Q 1. Show a list of all recommendations made after 1st January 2015 on the currencies of US dollar and Euro. Display the details including analyst name, currency code, recommendation, review date and reason. Query 1 Result FirstName LastName CurrencyCode Recommendation ReviewDate Reason John Johnson USD Buy 6/03/2015 Fed financial QE policy Joshua Andersen EUR Buy 15/02/2015 Forecast Eurozone GDP increase Linda Aka EUR Hold 2/01/2015 Euro central bank interest decision You must also provide a short implementation report describing your experiences with this assignment. You may discuss any of the following: a) You may see more than one design choice (such as whether or not to introduce a surrogate key, the data type selection for a particular attribute, etc) whilst implementing this database. If so, describe the relative merits of the alternatives. b) You should clearly show each of the SQL statements for the information requests. Describe your experience with MS Access SQL. (Note: It is optional to justify why your SQL statements are effective in addressing each information request.) c) You may have encountered some limitations in the DBMS you were using whilst trying to implement this database. Describe what you were trying to implement and explain the limitations you encountered. d) You may reflect on what you have learned during this assignment, what areas you think you need to improve on, and how you intend to improve your knowledge of those areas. Use the implementation report to demonstrate that you have thought carefully about the issues that arise when implementing a relational database.