Er diagram and design oltp database

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper HERE Order a Different Paper HERE

 

The purpose of this assignment is to allow you to practice designing and developing an ER diagram by using an appropriate tool.

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.

Steps:

Step 1: Please consider the ER Diagram for an OLTP database below:

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.