Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXERCISE 2. A motor-vehicle sales company sells motorcycles, passenger cars, vans, and buses. Model, sales-taxrate and sales-volume are attributes necessary for all kinds of vehicles.

EXERCISE 2. A motor-vehicle sales company sells motorcycles, passenger cars, vans, and buses. Model, sales-taxrate and sales-volume are attributes necessary for all kinds of vehicles. Vehicles are categorized into commercial and non-commercial vehicles. Buses and vans belong to the first category and motorcycles and cars belong to the second. For commercial vehicles we want to record the maximum number of passengers allowed and the commercial vehicle tax rate. Some kinds of non-commercial vehicles attract luxury vehicle tax rate. Cars alone can be of several types, such as sports car, sedan, wagon, etc. 1. Design a specialization-generalization hierarchy for this requirement. [15] 2. Justify your placement of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level. Write a small paragraph explaining everything no need to go into great detail.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Databases Technologies And Applications

Authors: Zongmin Ma

1st Edition

1599041219, 978-1599041216

More Books

Students also viewed these Databases questions

Question

1. Differentiate between high and low culture.

Answered: 1 week ago