You have two tables in your relational database: Loan and Lender as illustrated

Question

You have two tables in your relational database: Loan and Lender as illustrated in Exhibit 7-25 below. What information will result from the QBE query applied to the relational database tables in Exhibit 7-25? Exhibit 7-25 Identify the resources, internal agents, and external agents associated with each of the following business events: a. Purchase requisition (instigation) event. b. Purchase order for goods/services (mutual commitment) event. c. Receipt of goods/services (economic increment) event. d. Cash disbursement (economic decrement) event. e. Purchase return (economic increment reversal) event.

Explanation / Answer

in the table,given that loan1 and loan2 are taken from the lender1, loan3 is taken from the lender2.
the query is applied is a 1:M relationship.so, can see one lender has given many loans.
based on the query, that the lenderid, name phn, cont, initialPrinciple are retrieved, can say that:

the lender information as well as how much total principal amount for each lender is retrived frm the query.

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

q3)

internal external resource purchase manager creditor services purchase manager creditor goods and services purchase manager creditor/supplier cash cashier creditor/supplier cash purchase manager creditor/supplier goods and services

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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