Assignment: Business Reporting
Diagram a distributed database environment in Microsoft® Visio® using the Appendix A document (Attached)
Include the following in your diagram:
• A production database
• A data warehouse
• Two data marts
• Security and maintenance elements annotated in your first diagram
Create a 3-page summary in Microsoft® Word that:
• Identifies and discusses the database tables used to create your distributed database environment
• Identifies and discusses three SQL queries to develop reports from the data query list in the case study
• Explains the typical operation of a data warehouse and data marts, along with operational considerations and constraints
• Discusses how DreamHome could benefit from data mining and how OLAP and data mining applications could be applied to the DreamHome data model.
• Includes the SQL statements for each of the required queries and screenshots showing the query results
• A thorough explanation of the process you used to determine the data types used in each table
• An explanation of the most difficult process in designing and building the data and how organizations can overcome these difficulties
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Appendix-A.rar