Data base assignment

List your outcomes (objectives) for this unit/module so that students understand the learning that is to take place. Compare the data needs of transaction processing systems with those of decision support systems. Describe the data warehouse concept and list its main feature. Compare the enterprise data warehouse with the data mart. Design a data warehouse. Build a data warehouse, including the steps of data extraction, data cleaning, data transformation, and data loading. Describe how to use a data warehouse with online analytic processing and data mining. List the types of expertise needed to administer a data warehous List the challenges in data warehousing.