7. Using Oracle but without returning all the rows themselves, how many rows wou

Question

7. Using Oracle but without returning all the rows themselves, how many rows would be returned by the product of the customer table and orders table in the TAL database.

RepNum LastName FirstName Street City State PostalCode Commission Rate Item ItemNum Description On Hand Category Storehouse Entity names Customer Customer Num CustomerName Street City State PostalCode Balance CreditLimit RepNuma Orders Order N OrderDate Column names Customer Num appear inside rectangles Orderline Order N Item Num Numordered Quoted Price An entity appears as a rectangle Line indicates a relationship Absence of a dot indicates the "one" part of the relationship Dot indicates the "many" part of the relationship

Explanation / Answer

Here product refers to cartesian product.

In oracle, cartesian product of two tables mean "each row of table 1 is joined with every row of table 2".

Let there be 'm' rows in table Customer and 'n' rows in table Orders.

So, product will give us |Customer| x |Orders| = m*n = mn rows.

Related Questions

Navigate

• Browse (All)
• Browse 7
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.