- Revisit your OLTP data model and logical database. Address any comments you received from the professor after Week 2 and improve your data model and logical database. Address as many physical design aspects as possible. For completeness, formulate five SQL queries to demonstrate your understanding of that language. Some of your queries must use the INNER JOIN operation construct or the WHERE conditional construct (Note: SQL was covered in a Week 1 activity, in the Week 1 required readings from your text, and in supplemental material).
- Revisit your OLAP data model and address any comments you received from the professor in Week 4 to improve your data model.
- Produce a plan that addresses the data-quality management function for data governance of your case study.
Complete this part of the project in approximately 8-12 pages in a Microsoft Word document.
APA format with citations