Using SET operations, display a list of customers that are interested in a car (prospect table) of
Fantastic news! We've Found the answer you've been seeking!
Question:
Using SET operations, display a list of customers that are interested in a car (prospect table) of the different make and model which they already own. Allow for white space and case differences.
SI database is to be used for the above question, I've attached it below
Transcribed Image Text:
OPTIONS optioncode CHAR(4) optiondesc VARCHAR2(30) optioncost NUMBER(7,2) # optionlistprice NUMBER(7.2) custname custstreet PROSPECT custname VARCHAR2(20) NOT NULL carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) caryear CHAR(4) VARCHAR2(12) carcolour cartrim. VARCHAR2(16) optioncode CHAR2(4) |+ CUSTOMER custcity custprovince custpostal custhphone CHAR(13) custbphone CHAR(13) Specialty Imports E-R Diagram VARCHAR2(20) VARCHAR2(20) NOT NULL VARCHAR2(20) NOT NULL CHAR(2) CHAR(7) NOT NULL DEFAULT "ON" NOT NULL NOT NULL NOT NULL SERVINV servinvno CHAR(5) servdate DATE NOT NULL custname VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL partscost NUMBER(7,2) laborcost NUMBER(7,2) taxrate NUMBER(4.2) DEFAULT 13.0 SERVWORK servinvno CHAR(5) workdesc VARCHAR2(80) ||| Ho BASEOPTION ++ PURCHINV purchinvno CHAR(6) purchfrom VARCHAR2(15) purchdate DATE optioncode CHAR(4) carserial CHAR(8) carserial CHAR(8) custname VARCHAR2(20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL NOT NULL caryear extcolour VARCHAR2(12) NOT NULL H cartrim VARCHAR2(16) NOT NULL enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinvno CHAR(6) purchcost NUMBER(9.2) freightcost NUMBER(9.2) carlistprice NUMBER(9.2) CAR CHAR(4) Text TRADEINV saleinvno CHAR(6) carserial CHAR(8) tradeallow NUMBER(9,2) INVOPTION saleinvno CHAR(6) -ooptioncode CHAR(4) optionprice NUMBER(7,2) SALEINV saleinvno CHAR(6) saledate DATE NOT NULL salesman VARCHAR2(20) NOT NULL custname VARCHAR2(20) NOT NULL carserial insfire NOT NULL CHAR(8) CHAR(1) CHAR(1) inscollision insliability insproperty CHAR(1) CHAR(1) taxrate licfee discount NUMBER(8,2) commission NUMBER(8,2) carsaleprice NUMBER(9,2) NUMBER(4,2) DEFAULT 13.0 NUMBER(6,2) empname startdate title EMPLOYEE VARCHAR2(20) Ho DATE NOT NULL commissionrate NUMBER(3.1) VARCHAR2(26) manager VARCHAR2(20) OPTIONS optioncode CHAR(4) optiondesc VARCHAR2(30) optioncost NUMBER(7,2) # optionlistprice NUMBER(7.2) custname custstreet PROSPECT custname VARCHAR2(20) NOT NULL carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) caryear CHAR(4) VARCHAR2(12) carcolour cartrim. VARCHAR2(16) optioncode CHAR2(4) |+ CUSTOMER custcity custprovince custpostal custhphone CHAR(13) custbphone CHAR(13) Specialty Imports E-R Diagram VARCHAR2(20) VARCHAR2(20) NOT NULL VARCHAR2(20) NOT NULL CHAR(2) CHAR(7) NOT NULL DEFAULT "ON" NOT NULL NOT NULL NOT NULL SERVINV servinvno CHAR(5) servdate DATE NOT NULL custname VARCHAR2(20) NOT NULL carserial CHAR(8) NOT NULL partscost NUMBER(7,2) laborcost NUMBER(7,2) taxrate NUMBER(4.2) DEFAULT 13.0 SERVWORK servinvno CHAR(5) workdesc VARCHAR2(80) ||| Ho BASEOPTION ++ PURCHINV purchinvno CHAR(6) purchfrom VARCHAR2(15) purchdate DATE optioncode CHAR(4) carserial CHAR(8) carserial CHAR(8) custname VARCHAR2(20) carmake VARCHAR2(10) NOT NULL carmodel VARCHAR2(10) NOT NULL NOT NULL caryear extcolour VARCHAR2(12) NOT NULL H cartrim VARCHAR2(16) NOT NULL enginetype VARCHAR2(10) NOT NULL enginetype VARCHAR2(10) NOT NULL purchinvno CHAR(6) purchcost NUMBER(9.2) freightcost NUMBER(9.2) carlistprice NUMBER(9.2) CAR CHAR(4) Text TRADEINV saleinvno CHAR(6) carserial CHAR(8) tradeallow NUMBER(9,2) INVOPTION saleinvno CHAR(6) -ooptioncode CHAR(4) optionprice NUMBER(7,2) SALEINV saleinvno CHAR(6) saledate DATE NOT NULL salesman VARCHAR2(20) NOT NULL custname VARCHAR2(20) NOT NULL carserial insfire NOT NULL CHAR(8) CHAR(1) CHAR(1) inscollision insliability insproperty CHAR(1) CHAR(1) taxrate licfee discount NUMBER(8,2) commission NUMBER(8,2) carsaleprice NUMBER(9,2) NUMBER(4,2) DEFAULT 13.0 NUMBER(6,2) empname startdate title EMPLOYEE VARCHAR2(20) Ho DATE NOT NULL commissionrate NUMBER(3.1) VARCHAR2(26) manager VARCHAR2(20)
Expert Answer:
Answer rating: 100% (QA)
To display a list of customers who are interested in a car prospect table of a different make and mo... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these databases questions
-
How could your values and beliefs impact on this child and their family (perhaps even unintentionally) in a negative way? Provide an example of what could happen if you had not learned about cultural...
-
Draw the relational model for this EER for vacation property rentals RENTER Renter ID First Name Middle Initial Last Name Address Phone# EMail Signs HI RENTAL AGREEMENT Agreement ID Begin Date End...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Let S represent the amount of steel produced (in tons). Steel production is related to the amount of labor used (L) and the amount of capital used (C) by the following function: S = 20 L0.30 C 0.70...
-
The telescoping arm ABC is used to provide an elevated platform for construction workers. The workers and the platform together have a mass of 240 kg and have a combined center of gravity located...
-
Looking just at the present, how will the changes in the way care is provided (delivery) change the needs of the patient who wants to be more involved in the decisions of their care?
-
Calculate the mean for each of the following sets of data: a. 1, 1, 2, 3, 3 b. 1, 4, 4, 5, 6, 7, 8 c. 47, 56, 62, 69, 70, 73 d. .75, .23, .48, .60, .98, .65, .08, .12., .39 e. 11.02, 13.67, 17.39,...
-
For the customers in Exercise, In exercise At a major credit card bank, the percentages of people who historically apply for the Silver, Gold, and Platinum cards are 60%, 30%, and 10%, respectively....
-
A company applies overhead at a rate of 1 5 5 % of direct labor cost. Actual overhead cost for the current period is $ 8 2 5 , 0 0 0 , and direct labor cost is $ 5 0 0 , 0 0 0 . Determine whether...
-
This unadjusted trial balance is for Challenger Construction at the end of its fiscal year, September 30, 2023. The beginning balance of the owners capital account was $46,000 and the owner invested...
-
What is an example of how integrating with the use of enterprise resource planning (ERP) can help an organization, from research or your own personal experience?
-
Describe the possible barriers to entry and exit for (a) a group of nurse practitioners who specialize in primary care wanting to establish their own independent office to care for patients with...
-
Repeat Exercise Graphics P25.10, using a DTD for validation. Data from Exercise P25.10 Write a program that can read an XML document of the form: 5 10 20 30 5 10 25 40 Hello, World! 20 30 and show...
-
Implement a stack as a linked list in which the push, pop, and isEmpty methods can be safely accessed from multiple threads.
-
At a local hospital, a decision was made to downsize the nursing staff. The local television station sent a reporter and camera crew to interview the administra- tor regarding the impact of this...
-
The static getAvailableCurrencies method of the java.util.Currency class yields a set of Currency objects. Turn it into a stream and transform it into a stream of the currency display names. Print...
-
Kapoor Builders Limited decides to pay 2.5 percent of the value of debentures as underwriting commission to the underwriters but the Articles of the company authorize only 2.0 percent underwriting...
-
Why do bars offer free peanuts?
-
Discuss the priorities among the various parties who may have competing interests in collateral and the rights and remedies of the parties to a security agreement after default by the debtor.
-
Pantron I Corporation and Hal Z. Lederman market a product known as the Helsinki Formula. This product supposedly arrests hair loss and stimulates hair re-growth in baldness sufferers. The formula...
-
The Talent Company, manufacturer of a widely advertised and expensive perfume, sold a quantity of this product to Young, a retail druggist. Dentley and Bird visited Youngs store and Dentley, desiring...
-
What would be the length of a half-wave antenna for a radio station that emits its signal at \(90.5 \mathrm{MHz}\) ?
-
A sinusoidal electromagnetic wave has a maximum electric field magnitude of \(E_{\max }=500 \mathrm{~N} / \mathrm{C}\). What is the root-mean-square value of the electric field?
-
Full-body scanners at airports are sometimes referred to as millimeter-wave scanners and sometimes as terahertz scanners. Does this make sense?
Study smarter with the SolutionInn App