Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  

A motor-vehicle sales company sells motorcycles, passenger cars, vans, and buses. Model, sales-tax- rate 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. 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. - Activate Windows Go to Settings to activate Windows.

Step by Step Solution

3.42 Rating (146 Votes )

There are 3 Steps involved in it

Step: 1

In addressing this requirement lets start by designing a specializationgeneralization hierarchy Here is a textual description that outlines the hierarchy followed by justifications for attribute place... 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_2

Step: 3

blur-text-image_3

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

Database System Concepts

Authors: Henry F. Korth, S. Sudarshan

4th Edition

978-0073523323, 0-07-255481-9, 73523321, 978-0072554816

More Books

Students also viewed these Programming questions