Scribd
Upload
3 views1 page

Data Model for Revenue and Quantity Analysis

The document outlines a data model that includes various aggregations such as country and customer names by quantity, product names by cost and quantity, and monthly summaries. It also highlights many-to-many relationships involving country and region revenue plans with total prices. Overall, it presents a structured approach to organizing and analyzing sales data.

Uploaded by

deshmukhparth36
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
3 views1 page

Data Model for Revenue and Quantity Analysis

The document outlines a data model that includes various aggregations such as country and customer names by quantity, product names by cost and quantity, and monthly summaries. It also highlights many-to-many relationships involving country and region revenue plans with total prices. Overall, it presents a structured approach to organizing and analyzing sales data.

Uploaded by

deshmukhparth36
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Data Model

1. country by sum of Quantity


2. Country and customer name by sum of quantity
3. Product name by Sum of Product cost and Quantity
4. Month by Sum of quantity
5. Country Name, Product name by sum of quantity

Many to Many
1. Country Revenue plan and Total price
2. Region Revenue plan and Total Price

You might also like