Question

In: Computer Science

Consider the STAR schema with dimensions Customer, Product, and Time. The fact table has a measure...

Consider the STAR schema with dimensions Customer, Product, and Time. The fact table has a measure called Purchase_Price. This measure is:

- additive

-non-additive

-semi-additive

Solutions

Expert Solution

There are three types of facts:

1) Additive

They are facts that can be summed up through all of the dimensions in the fact table.

2) Non-additive

They are facts that cannot be summed up for any of the dimensions present in the fact table.

3) Semi-additive

They are facts that can be summed up for some of the dimensions in the fact table, but not the others.

Answer:

In this scenario, the dimensions are customer, product and time. The fact table has measure Purchase_Price.

This measure is additive because one can sum up this fact along few of the dimensions.

Explanation:

Summing the purchase price for all customers will provide information about the total cost of sales procured by the customers..

Summing the purchase price for all products will provide insight about the sales cost for the products.

Summing the purchase price for time (like a week or month or year) will provide information about the purchase for the duration.


Related Solutions

Which of the following best describes a dimension table in a star schema: Most attributes will...
Which of the following best describes a dimension table in a star schema: Most attributes will likely be text Most attributes will likely be numeric The primary key should be a single integer surrogate key Both a. and c. Which of the following best describes a fact table in a star schema: Most attributes will likely be text Most attributes will likely be numeric The primary key should be a single integer surrogate key Both a. and c. Which of...
You are to construct a star schema for Simplified Automobile Insurance Company. The relevant dimensions, dimension attributes, and dimension sizes are as follows:
Modern Database Management, 13th EditionJeff Hoffer9-39. You are to construct a star schema for Simplified Automobile Insurance Company. The relevant dimensions, dimension attributes, and dimension sizes are as follows:InsuredPartyAttributes: InsuredPartyID and Name. There is an average of two insured parties for each policy and covered item.CoverageItemAttributes: CoverageKey and Description. There is an average of 10 covered items per policy.AgentAttributes: AgentID and AgentName. There is one agent for each policy and covered item.PolicyAttributes: PolicyID and Type. The company has approximately 1...
A company has a star product whose estimated demand is in the attached table Month 1...
A company has a star product whose estimated demand is in the attached table Month 1 2 3 4 5 6 Demand 50 70 30 90 10 100 An order costs $ 150, the cost of the product is $ 75 and the cost to keep in inventory is 15%. For each period, determine the replenishment plan and the associated cost. Using the Minimum Unit Cost method, interpret the purchase order program.
Consider the following database schema:                Product(maker, model, type)                PC(model, speed
Consider the following database schema:                Product(maker, model, type)                PC(model, speed, ram, hd, rd, price)                Laptop(model, speed, ram, hd, screen, price)                Printer(model, color, type, price) Give SQL statement for each of the following: (Grouping and Aggregation) Write the following queries in SQL: Find the average speed of laptops costing over $2000. Find the average price of PC’s and laptops made by manufacturer “D”. Find, for each manufacturer, the average screen size of its laptops. Find the manufacturers...
Consider the following database schema:                Product(maker, model, type)                PC(model, speed
Consider the following database schema:                Product(maker, model, type)                PC(model, speed, ram, hd, rd, price)                Laptop(model, speed, ram, hd, screen, price)                Printer(model, color, type, price) Give SQL statement for each of the following: (Subqueries, Join operations) Write the following queries in SQL: Find the makers of PC’s with a speed of at least 1200. Find the printers with the highest price. Find the laptops whose speed is lower than that of any PC. Find the model number...
SQL query exercises: Consider the following database schema:                Product(maker, model, type)              &
SQL query exercises: Consider the following database schema:                Product(maker, model, type)                PC(model, speed, ram, hd, rd, price)                Laptop(model, speed, ram, hd, screen, price)                Printer(model, color, type, price) Consider the Drivers-Cars-Reserves DB for a small rental car company:                Drivers(id, name, rating, age)                Cars(vin, maker, model, year, color)                Reserves(did, vin, date) Give SQL statement each of the following operations: Find the colors of cars reserved by Smith. Find all id’s of drivers who have a...
For the given database schema. Answer the following questions. Company Database customer(cust_id, name, address) product(product_id, product_name,...
For the given database schema. Answer the following questions. Company Database customer(cust_id, name, address) product(product_id, product_name, price, quantity) transaction(trans_id, cust_id, time_date) product_trans(product_id, trans_id) Identify the primary keys and foreign keys for the relations and specify at least two different types of integrity constraints that would be applicable for different relations given.
1. Explain quality, from a customer perspective. a. Characterize product quality based on four dimensions. b....
1. Explain quality, from a customer perspective. a. Characterize product quality based on four dimensions. b. Distinguish service quality from product quality based on its distinct measurement. c. Apply the quality cycle to a product or service. 2. Explain how mistake-proofing and the supply chain are integrated with quality management planning. a. Attribute how cost of quality is related to financial performance. b. Recall the two key quality pioneers and their main ideas. c. Compare and contrast ISO 9000 standards...
Consider Starbucks as a production system in which the final product is a customer. For this​...
Consider Starbucks as a production system in which the final product is a customer. For this​ system: a. Define quality from the​ producer's and​ customer's prospective. b. Develop a​ fitness-for-use description for final product quality at Starbucks c. Give examples of the cost of poor quality​ (internal and external failure​ costs) and the cost of quality assurance​ (prevention and​ appraisal) cost for Starbucks
Table 1: Customer Wait Time (in minutes) at the Downtown Lube & Oil SAMPLE Day 1...
Table 1: Customer Wait Time (in minutes) at the Downtown Lube & Oil SAMPLE Day 1 Day 2 Day 3 Day 4 Wait Time (minutes) 25 28 28 28 28 33 30 37 21 24 26 39 32 27 28 38 28 37 34 36 22 29 36 43 34 29 28 33 25 30 34 30 24 27 25 36 29 33 44 45 Sometimes both x-bar chart and p-chart are available to monitor the same process. In Table...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT