HomeworkLib
Question

Consider a cube defined on the following dimension hierarchies: {customer < customer_street < customer_city < customer_state}...

Consider a cube defined on the following dimension hierarchies:

{customer < customer_street < customer_city < customer_state}
{supplier < supplier_city < supplier_state}
{product < product_line < product_ category}

The number of cuboids that contain the customer_street and product attributes is:

Group of answer choices

1. 36

2. 4

3. 80

4. 20

engineering   Computer-Science   
1 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Ans (1) The number of cuboids that contain the customer_street and product attributes is 36

0 0
Add a comment
Know the answer?
Add Answer to:
Consider a cube defined on the following dimension hierarchies: {customer < customer_street < customer_city < customer_state}...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • This is a Datawarehousing - Data Mining - Cube Cuboids Question: Consider a cube defined on...

    This is a Datawarehousing - Data Mining - Cube Cuboids Question: Consider a cube defined on the following dimension hierarchies: {customer < customer_street < customer_city < customer_state} {supplier < supplier_city < supplier_state} {day < month < quarter < year} {product < product_line < product_category} The number of cuboids that contain the supplier and quarter attributes is: (a) 96 (b) 12 (c) 20 (d) 144 What is the answer and why?

  • What is wrong with the following query? select firstname , lastname from Customer intersect select productid...

    What is wrong with the following query? select firstname , lastname from Customer intersect select productid , price , quantity from order_detail join orders on order_detail.orderid = orders.orderid; Group of answer choices 1 Nothing is wrong with this query 2 When working with set operators both queries have to contain the same number of columns. 3 The wrong set operator is being used. This query should use EXCEPT. 4 The wrong set operator is being used. This query should use...

  • 7.13. Consider the following View definition and update statement: CREATE VIEW TOPPRODUCTS(PRODNR,PRODNAME,QUANTITY) AS SELECT PRODNR, PRODNAME,...

    7.13. Consider the following View definition and update statement: CREATE VIEW TOPPRODUCTS(PRODNR,PRODNAME,QUANTITY) AS SELECT PRODNR, PRODNAME, AVAILABLE_QUANTITY FROM PRODUCT WHERE AVAILABLE_QUANTITY>100 WITH CHECK OPTION UPDATE TOPPRODUCTS SET QUANTITY=80 WHERE PRODNR=0153 What will be the result of this? a. The update can be successfully made but only the PRODUCT table will be updated. b. The update can be successfully made and both the View and PRODUCT table will be updated. c. The update will be halted because of the WITH CHECK...

  • What is wrong with the following SQL statement? select first_name , last_name , phone from Customer,...

    What is wrong with the following SQL statement? select first_name , last_name , phone from Customer, Orders where customer.customerid = orders.customerid; Group of answer choices 1 You cannot join customer.customerid to orders.cutomerid 2 Nothing is wrong with this statement. 3 The join is wrong. You can only join tables in the FROM clause. 4 The result will be a Cartesian Product.

  • Problem 6-4 Part 2 2. Use the following list of attributes and information from the UML Class Diagram to identify the...

    Problem 6-4 Part 2 2. Use the following list of attributes and information from the UML Class Diagram to identify the number of the appropriate attribute for each blank in the table listing below. Attributes: 1. Cash account # 2. Cash account balance 3. Check# 4. Check amount 5, Check date 6. Employee# 7. Employee name 8. Inventory category# 9. Inventory category description 10. Number of rental inventory items available in this category 11. Purchase order # 12. Purchase order...

  • 2. Use the following list of attributes and Information from the UML Class Diagram to identify...

    2. Use the following list of attributes and Information from the UML Class Diagram to identify the number of the appropriate attribute for each blank In the table listing below. Attributes 1. Cash account # 2 Cash account balance 3. Check # 4. Check amount 5. Check date 6. Employee # 7. Employee name 8. Inventory category # 9. Inventory category description 10. Number of rental inventory Items available in this category 11. Purchase order # 12 Purchase order date...

  • Consider the following. 729 Cube roots of - -(1 + (31) + 2 tek = Volco...

    Consider the following. 729 Cube roots of - -(1 + (31) + 2 tek = Volco (a) Use the formula Zk 0 + 2tk cos + i sin to find the indicated roots of the complex number. (Enter your answers in trigonometric form. Let 0 3 0 < 21.) n Zo = 21 = 22 = (b) Write each of the roots in standard form. (Round all numerical values to four decimal places.) 20 = 21 = 22

  • Python: 1) Consider the following code segment: try : inputFile = open("lyrics.txt", "r") line = inputFile.readline()...

    Python: 1) Consider the following code segment: try : inputFile = open("lyrics.txt", "r") line = inputFile.readline() print(line) _____________________ print("Error") What should be placed in the blank so that the program will print Error instead of crashing if an exception occurs while opening or reading from the file? Group of answer choices a- except RuntimeError : b- except EnvironmentError : c- except IOError : d- except IndexError : 2) Consider the following code segment: line = "hello world!" parts = line.split()...

  • Consider the relation Proj as defined in the worksheets. What is the result of running the...

    Consider the relation Proj as defined in the worksheets. What is the result of running the following query? SELECT p1.projname, COUNT(p2.projname) as count FROM Proj p1 LEFT JOIN Proj p2 on p1.projno = p2.majproj GROUP BY p1.projname ORDER BY count DESC; 1. The query returns the number of sub-projects that each project has. 2. The query returns all of the projects that have sub-projects, and the number of sub-projects that they have. 3. The query shows each main project and...

  • Customer Profitability Analysis    Rogers Aeronautics, LTD, is a British aeronautics subcontract company that designs and...

    Customer Profitability Analysis    Rogers Aeronautics, LTD, is a British aeronautics subcontract company that designs and manufactures electronic control systems for commercial airlines. The vast majority of all commercial aircraft are manufactured by Boeing in the U.S. and Airbus in Europe; however, there is a relatively small group of companies that manufacture narrow-body commercial jets. Assume for this exercise that Rogers does contract work for the two major manufacturers plus three companies in the second tier. Because competition is intense...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT