OLAP Sales Entity Relationship Diagram ERD OLAP DATABASE design to Monitor Sales By Product, Customer and Date, ERD and Preview

OLAP DATABASE design to Monitor Sales By Product, Customer and Date, ERD and Preview

OLAP SALES ERD

Click Below or Copy Link in Browser To Download!

http://www.askassignment.com/product/olap-database-design-monitor-sales-product-customer-date

$ 20

ON SALE

Regular price: $ 25

You Save: $ 5

 

 

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.

Email at support@askassignment.com for complete solution

Attachments:

File Attachment 1:
[OLAP ERD for Sales.vsd]

File Attachment 2:
olap_product_customer_date_sales.zip[olap_product_customer_date_sales.vsd
olap_product_customer_date_sales.png]