Reference no: EM13873520
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.
|
The reduction of an asset is a source of funds
: the reduction of an asset is a source of funds
|
|
What risks does this infection pose to the woman
: What disease does this patient have and what risks does this infection pose to the woman?
|
|
Equity multiplier-What was the firms ROE
: Company abc had a profit margin of 6.25% , total asset turnover of 1.5 and an equity multiplier of 1.8. What was the firms ROE? What would happen if the equity multiplier went up to 2.5?
|
|
Calculate the annual cash flows from fixed-payment annuity
: Calculate the annual cash flows (annuity payments) from a fixed-payment annuity if the present value of the 20-year annuity is $1.8 million and the annuity earns a guaranteed annual return of 10 percent. The payments are to begin at the end of the cu..
|
|
Differentiate inner join and outer join with examples
: Differentiate Inner Join and Outer Join with examples. Further, explain Left Outer Join and Right Outer Join through examples.
|
|
Demonstrates a remarkable insight into peoples foibles
: Why do you think Chaucer presents certain characters as real people and others more as caricatures
|
|
Stock and its dividend yield based on that price
: GE : open price 25, closing price 26 , bid 25.50, offer 26, days range 25-26, 52 week range 20-28, volume 2 million shares , avg. daily volume 1million shares, market cap 200 billion, earnings per share $1.50, dividend $1.10. Tell me the price an inv..
|
|
Determining the final temperature of the gas
: Determine (a) the final temperature of the gas and (b) the final pressure if no mass was withdrawn from the tank and the same final temperature was reached at the end of the process.
|
|
What is the value to the company and the supplier
: what is the value to the company and the supplier in developing and implementing a Third Party Supplier Relationship Management System (3 P.L.S.M.S.)? How can such a system provide greater efficiency
|