Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A transport company needs to model their activities. There are two types of employees in the company: drivers and operators. For drivers it is interesting

A transport company needs to model their activities. There are two types of employees in the company: drivers and operators. For drivers it is interesting to know the date of issue and type of the driving license, and the date of issue of the taxi drivers certificate. For all employees it is interesting to know their personal number, address and the available phone numbers. The company owns a number of transport. For each transport, there is a need to know its type, year of manufacturing, and date of the last service. There are two types of transport commonly booked by the customers that are MPV and Saloon. There are also other types of transports that the company provides to the customers. The company wants to have a record of car trips. A transport may be picked on a street or ordered through an operator who assigns the order to a certain driver and a car. Departure and destination addresses together with times should also be recorded.

Draw an enhanced entity relationship diagram in UML notation.

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

Understanding Databases Concepts And Practice

Authors: Suzanne W Dietrich

1st Edition

1119827949, 9781119827948

More Books

Students also viewed these Databases questions