This week, to complete your final project, you will perform the following tasks:
Revisit your OLTP data model and logical database. Address any comments you received from the professor afterWeek 2and 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 aWeek 1activity, in theWeek 1required readings from your text, and in supplemental material).
Revisit your OLAP data model and address any comments you received from the professor inWeek 4to improve your data model.
Produce a plan that addresses the data-quality management function for data governance of your case study.
Submission Details:
Complete this part of the project in approximately 8-12 pages in a Microsoft Word documen