汽车经销商的数据库设计
我正在考虑为汽车经销商构建一个应用程序。我看到的最大挑战是建立数据库来捕获有关车辆的必要信息（年份、品牌、型号——相当简单，但我知道细节远不止于此）。这些信息可能会用于在其网站上展示经销商的库存（因此，用户可能希望能够根据各种参数等进行搜索）。
关于我可以对此数据库的版本 1 做什么有什么建议吗？有我可以使用的示例吗？谢谢。
I'm looking into building an application for a car dealership. The biggest challenge I see is building the database to capture the necessary information about vehicles (year, make, model -- fairly easy, but I know the details go way beyond that). The information will probably be used to showcase the dealership's inventory on their website (so, users are probably going to want to be able to search based on various parameters, etc.).
Any suggestions on what I can do for version 1 of this database? Any samples out there that I can use? Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您应该查看 http://www.databaseanswers.org/data_models/ ，有很多您可以比较的数据库模型。
You should look at http://www.databaseanswers.org/data_models/ , there is a bunch of db models which you can compare.
我绝对建议您首先在纸上创建数据库。虽然它是图表形式，但它可以在不损失任何时间的情况下进行重构和重新设计，并且可以用来以更清晰的方式解释数据库的内部工作原理 - 如果不是向其他人，也可以向您自己解释。
做到这一点的最佳方法是使用称为 UML 的标准化过程。查看 http://sourcemaking.com/uml/introduction 因为它有很多入门信息具有 UML 和软件开发最佳实践。
I would definitely recommend creating your database on paper first. While it is in diagram form, it can be refactored and redesigned without any time loss, and can be used to explain the inner workings of your database in a much more clearer way - if not to others, to yourself.
The best way in doing this is with a standardised procedure called UML. Check out http://sourcemaking.com/uml/introduction as it has a lot of information on getting started with UML and software development best practices.