Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What would the SQL code in Oracle look like for these questions based on the tables? *Produstsypplier Table Primary key Foreign keys: none 100 101
What would the SQL code in Oracle look like for these questions based on the tables?
*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 Q2. How many "Life Insurance" products are there for sale through FinBroker? Q3. Report the total investment amount in 'Mutual Fund' products sold by Einbtoker Sales Representatives in February 201 04. What are the products (ie, names) and the names of the customers who bought products that have been supplied by suppliers with "Sun" in their nameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started