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.

                   

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply