数据库.ER DESIGNS [英] database .ER DESIGNS

问题描述

为汽车公司设计数据库，以提供给经销商以协助
他们维护客户记录和经销商库存，并协助销售人员进行
订购汽车.
每个车辆都通过车辆识别号(VIN)进行识别.每个
单个车辆是公司提供的特定品牌的特定型号.
(例如，XF是塔塔汽车公司的汽车品牌Jaguar的模型).每个模型都可以
提供多种选择，但每辆车可能只有一部分(或没有)
可用选项中的一个.该数据库需要存储有关型号，品牌， 和选项，以及有关各个经销商，客户和汽车的信息.您的设计应包括一个ER图，一组关系模式和一系列约束，包括主键和外键约束

Design a database for an automobile company to provide to its dealers to assist
them in maintaining customer records and dealer inventory and to assist sales staff in
ordering cars.
Each vehicle is identified by a vehicle identification number (VIN). Each
individual vehicle is a particular model of a particular brand offered by the company
(e.g., the XF is a model of the car brand Jaguar of Tata Motors). Each model can be
offered with a variety of options, but an individual car may have only some (or none)
of the available options. The database needs to store information about models, brands,
and options, as well as information about individual dealers, customers, and cars. Your design should includen an E-R Diagram, a set of relational schemas and a list of constraints including primary key and foreign key constraints

推荐答案

我们不做您的作业:设置是有原因的.在这里，您可以考虑自己被告知的内容，并尝试理解它.也可以在那里帮助您的导师识别您的弱点，并将更多的注意力放在补救措施上.

自己尝试，您可能会发现它并不像您想的那么困难！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

这篇关于数据库.ER DESIGNS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！