Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial And Temporal Databases 10th International Symposium Sstd 2007 Boston Ma Usa July 2007 Proceedings Lncs 4605

Authors: Dimitris Papadias ,Donghui Zhang ,George Kollios

2007th Edition

3540735399, 978-3540735397

More Books

Students also viewed these Databases questions