Load sample data into the database tables design and test queries to return the following information:
• All rows and columns for employees
• All rows and columns for customers
• A count of sales orders
• A list of customers who have placed orders
• Sales order information including individual items
Prepare a write-up in Microsoft word to illustrate how busicorp may benefit in the prospect from data warehousing and data mining comprise the types of data you would transfer in the warehouse and what aspects of business may benefit from the information which could be mined from the warehouse.