Finalize a data model and DDL. Make any needed changes to the attached ERD and Physical Data Model. Include any SQL needed for the database, the DDL, the DML to manage the customer and employee rows, and the 3 SELECT statements.
Create a star schema and the DDL to create the Star schema for the data warehouse. Implement a single Fact table to track all orders with the following dimensions: Time, Customer, Product, and Employee
Include all DDL including primary and foreign keys; feel free to create new or needed primary keys.
Develop a specific and detailed discussion about the ETL process is to be used to move data from the OLTP environment to the data warehouse.
This solution should include the following:
A description on your approach
The features of your enhanced ERD
A discussion about handling the M:M relationship between customer and products
The approach used to ensure 3NF
Required SQL statements for the database
Star schema for the fact table and its 4 dimension tables
The DDL for the Star schema for the data warehouse with discussion on Data Warehouse Design
A description of the ETL process
Provide reference for the whole solution
Attachment:- Database Design.docx