Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CustName cAdd dealerName dAddress cID dID vinNum make model year trim msrp stockDate sellDate sellPrice John Doe 1 2 3 Main Street Acme Cars Inc

CustName cAdd dealerName dAddress cID dID vinNum make model year trim msrp stockDate sellDate sellPrice
John Doe 123 Main Street Acme Cars Inc 1000 First Ave C001 D2345 Z001 Chevrolet Corvette 20201LT $59,995 Oct-15-2020 Oct-16-2020 $72,000
John Jr. Doe 123 Main Street Acme Cars Inc 1000 First Ave C016 D2345 Z001 Chevrolet Corvette 20201LT $59,995 Oct-15-2020 Oct-16-2020 $72,000
Maggie Smith 234 Peach Street Acme Cars Inc 1000 First Ave C001 D2345 Z101 Chevrolet Corvette 20203LT $71,945 Sept-12-2020 Sept-20-2020 $77,000
John Jr. Doe 123 Main Street Buy Buy Cars 1 Auto Ave C016 D7894 M103 Chevrolet Malibu 2019 LS $24,095 May-15-2019 Aug-7-2019 $21,400
Kim Wayne 456 Washington Ave Cars Anon 2000 Last Mile C786 D3713 V128 Toyota Camry 2019 LS $28,395 Nov-7-2018 Dec-27-2018 $27,545
Column Explanations
CustName Customer's name model model of the vehicle
cAdd Address where customer lives year year of the vehicle
dealerName Name of the dealer trim trim of the vehicle
dAddress Address where dealer is located msrp msrp of the vehicle
cID unique identifier for customer stockDate arrival date for vehicle in stock with the dealer
dID unique identifier for dealer sellDate date on which vehicle in stock with the dealer was sold
vinNum unique identifier for each vehicle in stock with the dealer sellPrice price at which vehicle in stock with the dealer was sold
make brand of the vehicle
Based on the table and column explanations, one of the themes identified is: VEHICLE-IN-STOCK
Select ALL the columns that belong to the theme
CustName
cAdd
dealerName
dAddress
cID
dID
vinNum
make
model
year
trim
msrp
stockDate
sellDate
sellPrice

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_2

Step: 3

blur-text-image_3

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

Beginning Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

More Books

Students also viewed these Databases questions