Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the table below: distributor _ id | item _ code | retailer _ id | date _ of _ sell | quantity | total

Consider the table below:
distributor_id|item_code|retailer_id|date_of_sell|quantity|total_cost|
--------------|---------|-----------|------------|--------|----------|
5001|101|1001|2020-02-12|3|8100|
5001|103|1002|2020-03-15|15|4500|
5002|101|1001|2019-06-24|2|5400|
5001|104|1001|2019-09-11|8|2400|
5003|101|1002|2020-10-21|5|13500|
5003|104|1002|2020-12-27|10|3000|
5002|102|1001|2019-05-18|12|9600|
5002|103|1004|2020-06-17|8|2400|
5003|103|1001|2020-04-12|3|900|
How many dimension and measure attributes are present in this table
Question 1 options:
5 dimension and 1 measure
2 dimension and 4 measure
3 dimension and 3 measure
4 dimension and 2 measure

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions