Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

uml sheet question 2:

Design UML diagram for the license issuing process of vehicles. The
requirements are as follows:
o The country is divided into departments (Cairo, Giza, Alex….
etc.). Each department is described by a code (unique), and several
service locations (e.g., for Cairo department, there are: Heliopolis,
Nasr City etc.).
o Each Vehicle is described by a number (unique: for all vehicles in
the same department), model, type (private, Limousine, taxi….
etc.), color, motor capacity, number of seats, manufacturing year,
license issue date, license expiry date, owner, tax rate, and a set of
fins. The owner, type, and tax rate information are mandatory for
each vehicle. Each vehicle type is identified by a code (unique),
name (unique), and has a set of tax categories. Each tax category
has a specific tax rate.
o Each vehicle fin is described by number (unique), type, date, and
vehicle
o Each fin type is associated with specific value. When a vehicle is
transferred from one department to another or sometimes when its
license is renewed, a new number is assigned to the vehicle. it is
required to keep track of those old numbers (if any) for each
vehicle with period of each (start date and end date. it is also
requires to keep track of the total amount of fins for each vehicle.
o Each owner is described by a national number (unique), name, type
(individual, organization, government, etc. address, and set of
phone numbers.

Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education