1 / 27

Used car retrieval system

Used car retrieval system. Group member: Wangxin Li Zhuoqing zhang Yiwei Wang. outline. Introduction Analyze Query Conclusion. outline. Introduction Analyze Query Conclusion. Why we build a used car retrieval system? ?.

kaleb
Download Presentation

Used car retrieval system

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Used car retrieval system Group member: Wangxin Li Zhuoqing zhang Yiwei Wang

  2. outline • Introduction • Analyze • Query • Conclusion

  3. outline • Introduction • Analyze • Query • Conclusion

  4. 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

  5. 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.

  6. outline • Introduction • Analyze • Query • Conclusion

  7. 1. E-R model

  8. 2.Normalized table • CUSTOMER (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)

  9. 3. relationship

  10. 4.Data dictionary Table name :Car Table name :Customer Table name :Dealer Table name :Order

  11. Table name :Pre-owner Table name :Search Table name :Review

  12. outline • Introduction • Analyze • Query • Conclusion

  13. 1.Select dealers and sort by the amount of comment

  14. 2.Select the dealers which possess the highest rating.

  15. 3. Select dealers whose rating is larger than three and select customer comment of them.

  16. 4. select name and rating of dealer who owns most kinds of car model types .

  17. 5.Select the car which has the least miles or with the lowest price

  18. 6. Select the price ,dealer and information of the car which is selected as favorite by most customer

  19. 7. Select the top three of the most favorite car types.

  20. outline • Introduction • Analyze • Query • Conclusion

  21. Conclusion • Customers can find suitable cars • Dealers can learn customers well

  22. Thank you!

More Related