Q1 ) Differentiate Inner Join and Outer Join with examples. Further, explain Le
ID: 3763682 • Letter: Q
Question
Q1) Differentiate Inner Join and Outer Join with examples. Further, explain
Left Outer Join and Right Outer Join through examples.
Write the result of the following query. Select *
From Sale RightJoin [Sale-CashRecDuality]
Where [Sale.Sale#]=[Sale-CashRecDuality.Sale#];
Q3) Identify typical resources, internal agents, and external agents associated with each of the following business events:
a. Sales call or similar instigation event.
b. Sales order or similar mutual commitment event.
c. Sale, shipment and/or service engagement or other economic decrement event.
d. Cash receipt or other economic increment event.
e. Sale return or other economic decrement reversal event.
Q4) Horizon Books:
Horizon Books is a bookstore in downtown Madina Munawara. It carries an inventory of approximately 50,000 books. Customers come in and browse the shelves, select their books, and take them to one of three cashiers positioned in different parts of the store. One of the cashiers is situated at an information desk where customers can discover whether a particular book is in stock, place orders for books not currently available in the bookstore, and collect and pay for books previously ordered. The cashier at the information desk has a book database that is consulted for every query. There are no credit sales. All customers pay for their purchases at the time of purchase.
Draw a diagram showing all cardinalities.
Explanation / Answer
An inner join of two tables is like the intersectipon of two tables. So, for example, given tables X(1,2,3) and Y(3,4,5,6), the inner join of these two tables will give us rows whose id is 3.
An outer join is like a UNION of two tables. So on considering the same example discussed above, the result or OUTER join would be 1,2,3,4,5,6.
A left outer join will give all rows in X, plus any common rows in Y. So result would be (1,2,3,4)
A right outer join will give all rows in Y, plus any common rows in X. (3,4,5,6)
For the given query, the result will be the entire Sale-CashRedQuality table, and the columns Amount, Date Cust# and SalesRep# will be added to the result too
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.