Diagram A Distributed Database Environment In Microsoft Visio Include The Follow

Diagram a distributed database environment in Microsoft Visio. 

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