This assignment requires you to develop an ER Diagram and design OLTP database that shows all tables (and attributes) and relationships based on the giving information and ER Diagram.
Step 1: Please consider the ER Diagram for an OLTP database below:
Step 2: Develop an OLAP database design based on the following information:
Fact: Quantity and Price of each item sold
Granularity: All sales
Dimensions: Products, Customers, Dates
Step 3: Develop the ER Diagram that shows all tables (and attributes) and relationships.