Question: *Produstsypplier Table Primary key Foreign keys: none 100 101 102 ACA AIG *Productline Table Primary key: Pr Foreign keys: none Disability Insurance Life Insurance Product

 *Produstsypplier Table Primary key Foreign keys: none 100 101 102 ACAAIG *Productline Table Primary key: Pr Foreign keys: none Disability Insurance Life

*Produstsypplier Table Primary key Foreign keys: none 100 101 102 ACA AIG *Productline Table Primary key: Pr Foreign keys: none Disability Insurance Life Insurance Product Table Primary key: Product Foreign keys: SuplD (references the Produstble) Foreign keys: s the P PLID 10 Payments 20 Payments Accent-Life 10 Transaction Table 107 107 35 eign keys (references the Product table) 40570 40579 ICHARD V.U 1020.00 Protector and Protector improved accelerated 447.48 40570 -TranDetail Table Primary key, dSRSNum gBee Foreign keys: dSRSNum (references the Transaction table) Foreign keys: dep freferences the Salesee table) 1430 2623 3396 25 75 100 e SalsRep Table Primary key Foreign keys: none 1057 Adam Carson Jean Campo Guy Tripper 1197 Q8. Report the sales transaction that brought in the largest commission for FinBroker (indicate the sales transaction number, the sales contract submission date and the commission amount made in the answer). Q9. List the names of customers who bought an investment amount greater than the average investment amount of financial products sold by FinBroker Q10. List the transactions along with the names of the customers that brought in an investment amount higher than the average investment amount for each product line

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!