SQL needed for the database

 

Add the Data Warehouse Design and discussion about the ETL process to  the project template section titled “Web and Data Warehousing and  Mining in the Business World.”

Submit your Word document and make sure that it contains: A Screenshot of the ERD, logical data model from previous assignments. The DDL to create the tables, including the table definition and the primary and foreign key definitions 1–2  pages describing the solution Star Schema DDL for a Star schema 2-3 paragraphs about the ETL process