Week 5 final 6211 | Information Systems homework help
Posted: November 19th, 2021
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 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 documen