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, the final set of themes identifed are:
CUSTOMER
DEALER
VEHICLE
VEHICLE-IN-STOCK
Based on the information, identify ALL of the themes are related to: VEHICLE
CUSTOMER
VEHICLE-IN-STOCK
DEALER
VEHICLE

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

Relational Database And SQL

Authors: Lucy Scott

3rd Edition

1087899699, 978-1087899695

More Books

Students also viewed these Databases questions

Question

Can you explain the concept of gap management?

Answered: 1 week ago