Week 4 – Business Reporting and Analytics

  Resources: Completed Week One Individual Assignment "DreamHome Case Study" Completed Week Two Individual Assignment "Object Oriented Axioms Pattern and SQL Question Definition" Completed Week Three Individual Assignment, "Database Operations and Axioms Recovery" Appendix A, "User Requirements Specification for DreamHome Case Study" of Database Systems: A Practical Approach to Design, Implementation and Management(6th edition). Update the subjoined DreamHome assignments: Diagrams from the completed Week One Individual Assignment "DreamHome Case Study" Diagrams from the completed Week Two Individual Assignment "Object Oriented Axioms Pattern and SQL Question Definition" Completed Week Three Individual Assignment, "Database Operations and Axioms Recovery" Diagram a orderly axiomsbase environment in Microsoft® Visio® using the "DreamHome Case Study" in Appendix A of Database Systems: A Practical Approach to Design, Implementation and Management (6th edition) and your completed DreamHome-related assignments from Weeks One, Two, and Three. Include the subjoined in your diagram: A formation axiomsbase A axioms magazine Two axioms marts  Security and subsistence elements annotated in your earliest diagram Create a 3-page abstract in Microsoft® Word that: Identifies and discusses the axiomsbase tables used to imagine your orderly axiomsbase environment Identifies and discusses three SQL queries to enlarge reports from the axioms question inventory in the event study Explains the usual exercise of a axioms magazine and axioms marts, concurrently after a while exerciseal considerations and constraints Discusses how DreamHome could good from axioms mining and how OLAP and axioms mining applications could be applied to the DreamHome axioms pattern. Includes the SQL statements for each of the required queries and screenshots showing the question results A perfect explication of the regularity you used to individualize the axioms types used in each table An explication of the most perplexing regularity in sharp and edifice the axioms and how organizations can overpower these perplexingies Submit the Microsoft® Visio® rasp of your annotated diagram and the Microsoft® Word rasp of your abstract.