问题描述
为汽车公司设计数据库，以提供给经销商以协助
他们维护客户记录和经销商库存，并协助销售人员进行
订购汽车.
每个车辆都通过车辆识别号(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
推荐答案
这篇关于数据库.ER DESIGNS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！