+1 123 456 7890 instantessays65@gmail.com

(answered) – 1) Design a database for an automobile company to provide to its

$11.00

(answered) – 1) Design a database for an automobile company to provide to itsDescriptionSolution downloadThe Question1) Design a database for an automobile company to provide to its dealers to assist them in maintainingcustomer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identifiedby a vehicle identification number (VIN). Each individual vehicle is a particular model of a particularbrand offered by the company (e.g., the XF is a model of the car brand Jaguar of Tata Motors). Eachmodel can be offered with a variety of options, but an individual car may have only some (or none) ofthe available options. The database needs to store information about models, brands, and options, as wellas information about individual dealers, customers, and cars.a) Construct an Extended/Entity-Relationship diagram. Your design should specify key attributes ofeach entity set, and structural constraints on each relationship set. Note any unspecifiedrequirements, and make appropriate assumptions to make the specification complete.b) Translate the diagram into relations including primary key and foreign key constraints.

Reviews

There are no reviews yet.

Be the first to review “(answered) – 1) Design a database for an automobile company to provide to its”

Your email address will not be published. Required fields are marked *