Design a generalization-specialization hierarchy for a motor-vehicle sales

Question # 00794607 Posted By: dr.tony Updated on: 02/17/2021 11:32 AM Due on: 02/17/2021
Subject Education Topic General Education Tutorials:
Question
Dot Image

Design a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles which have an engine number and cost; cars which have a chassis number, an engine number, seating capacity and cost; trucks which have chassis number, an engine number and cost.

 Map the following ER diagram to a relational database. Give the relation names and attributes in them. Also mention the primary key and foreign keys if any for each table.

                   

Dot Image
Tutorials for this Question
  1. Tutorial # 00792800 Posted By: dr.tony Posted on: 02/17/2021 11:33 AM
    Puchased By: 2
    Tutorial Preview
    The solution of Design a generalization-specialization hierarchy for a motor-vehicle sales...
    Attachments
    Design_a_generalization-specialization_hierarchy_for_a_motor-vehicle_sales.ZIP (18.96 KB)

Great! We have found the solution of this question!

Whatsapp Lisa