Design a generalization-specialization hierarchy for a motor-vehicle

  

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.

                   

"We Offer Paper Writing Services on all Disciplines, Make an Order Now and we will be Glad to Help"