(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.
AcademicPaperExperts.com is a platform where students from all over the globe can get assignment assistance. It is our endeavor to provide customized assignments which are authentic for students in the United States, United Kingdom, New Zealand, Australia and other countries around the globe. Our team undergoes thorough training to handle all the inquiries in a professional manner. We do not set the bar in custom essay writing, we are the bar. All the custom papers and essays you order are written by our writers in tandem with your requirements.