ERD - OLAP SALES OLTP

Description: ER Diagram
Download from below link:
Description: ER DiagramDescription: ER Diagram

    http://www.askassignment.com/product/olap-database-design-monitor-sales-product-customer-dateOLAP SALES ERD
  1. 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:
Description: ER Diagram

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.




No comments:

Post a Comment

Subscribe to: Posts (Atom)