Database

Database Project description SLP 4 is in two parts. Part I is all about SQL and Part II is about data warehousing topics. Part I For the Trident University Student database, generate reports that specified in Module 2 SLP. 1. Students who live in California 2. Students who live outside California 3. Names of students who take ITM440 course 4. Names of students who live in California and take ITM440 course 5. Student names, courses they have taken, and letter grade for each of these courses. 6. Any other information you would like to retrieve from the database (Since we recommended modifying the table created in Module 2 for Module 4, you should have all the related field needed to query the database for items 1-6 here. As you query the table based on requirements 1-6, please provide screenshots of SQL statements and results) Part II For the second part of the SLP, write a paper (25 pages) that includes your SQL statements and screenshots of the result of your queries in OpenOffice. (In addition to the SQLs above, you need to do a short essay on any topic of interest as listed below. Write a 2-5 page paper. As discussed in Case 4, your SLP part I and II should be created in a single MS Word document properly labeling Part I SQL and Part II short essay on topic. The write up should be APA with cover page, discussion, conclusions, and references. The discussion section will included screenshots of SQL and the essay. Include a couple of external references in the paper.) Write a report based on a topic related to data warehouse that interest you. You can choose a topic from the following list, or come up with a topic on your own. You are strongly encouraged to use the Trident online library for this assignment. It is okay to use wiki to help you understand certain concepts, but do not use it in your paper. 7. Data warehouse architecture 8. Data warehouse data sources, loading, cleaning, summarizing, granularity 9. Metadata in a DW 10. Data Modeling and the DW 11. Design principles for DWs 12. Strategic use of the Data warehouse 13. Justification of creating a data warehouse 14. Data warehouse security 15. Data warehouse and data marts 16. Maintaining the data warehouse 17. Online analytical processing (OLAP) and the data warehouse 18. Decision Support Systems and the data warehouse 19. Database marketing and the data warehouse 20. Data mining and the data warehouse 21. Organizing and managing the data warehouse project