used car retrieval system group member: wangxin li zhuoqing zhang yiwei wang
TRANSCRIPT
Why we build a used car retrieval system?
?it will be inconvenient for people to anywhere
without a car
the price of a new car is still too high for some group of people
Function & object
Dealers can post detailed car information on the system, and customer could search the particular type of cars.
Dealers can learn customer as well.
Customers can write review for other customers to reference.
2.Normalized tableCUSTOMER (CustomerID, CustomerName, CustomerPhone#,
CustomerAddress, PriceRange)
CAR (VinNumber, Make, Model, Years, Miles, Price, CARFAXReportNumber, CertifiedType, PreownerID, DealerID)
PRE-OWNER (PreownerID, Age, Occupation, Gender, DealerID)
DEALER (DealerID, DealerAddress, Ratings)
ORDER (OrderNumber, OrderDate, CustomerID)
REVIEW (CustomerID, DealerID, Comment)
SEARCH (CustomerID, VinNumber, Date)
Attribute Attribute Description
Data Type
VinNumber ID of car Long Text
Make Brand of car Short Text
Model A type of car in particular brand
Short Text
Years Year the car made in
Date/Time
Miles Miles run by the car
Number
Price The price of Car Number
CARFAXReportNumber
ID of CARFAX report
Number
CertifiedType Whether the car has been certified
Short Text
PreownerID Primary key of Preowner
Number
DealerID Primary key of dealer
Number
Attribute Attribute Description
Data Type
CustomerID Primary key of customer
Number
CustomerName The name of customer
Short Text
PhoneNumber Phone number of customer
Long Text
Address Customer address Short Text
PriceRange Price range the customer prefered
Short Text
Table name :Car Table name :Customer
Attribute Attribute Description
Data Type
DealerID Primary key of dealer
Number
Address Dealer address Short Text
Ratings The evaluate of dealer
Number
Table name :DealerAttribute Attribute
Description Data Type
OrderNumber Primary key of order
Number
OrderDate Date placed the order
Short Text
CustomerID Primary key of cusromer
Number
Table name :Order
4.Data dictionary
Attribute Attribute Description
Data Type
PreownerID Primary key of preowner
Number
Age Age of preowner Number
Occupation Occupation of preowner
Short Text
Gender Gender of the preowner
Short Text
DealerID Primary key of Dealer
Number
Attribute Attribute Description
Data Type
CustomerID ID of customer Number
DealerID ID of car Long Text
comment Customer’s comment to dealer
Long Text
Attribute Attribute Description
Data Type
CustomerID ID of customer Number
VinNumber ID of car Long Text
Date Date when customer select a car as favorite
Date/Time
Table name :Review
Table name :Search
Table name :Pre-owner
6. Select the price ,dealer and information of the car which is selected as favorite by most customer