Design a generalization-specialization hierarchy for a motor-vehicle sales
Question # 00794607
Posted By:
Updated on: 02/17/2021 11:32 AM Due on: 02/17/2021
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.
-
Rating:
/5
Solution: Design a generalization-specialization hierarchy for a motor-vehicle sales