Q1) Differentiate Inner Join and Outer Join with examples. Further, explain Left Outer Join and Right Outer Join through examples.
Q2) Consider the given tables
Sale
|
Sale#
|
Amount
|
Date
|
Cust#
|
SalesRep#
|
|
S-1
|
7,200
|
1 July
|
C-1
|
E-12
|
|
S-2
|
10,000
|
21 July
|
C-2
|
E-10
|
|
S-3
|
16.000
|
22 July
|
C-5
|
E-10
|
|
S-4
|
10.000
|
26 July
|
C-2
|
E-10
|
|
S-5
|
16.600
|
31 July
|
C-5
|
E-10
|
|
S-6
|
35,000
|
15 Aug
|
C-3
|
E-10
|
|
S-7
|
23.000
|
21 Aua
|
C-4 |
E-99
|
Sale-CaseRecDuality
|
Sale#
|
RA#
|
Applied
|
|
S-2
|
RA-1
|
1,666
|
|
S-4
|
RA-2
|
10.000
|
|
S-1
|
RA-3
|
7,200
|
|
S-3
|
RA-4
|
16,000
|
|
S-5
|
RA-4
|
16,600
|
|
S-2
|
RA-5
|
1,666
|
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.