Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an EER diagram for the following situation: City Transportation Authority needs to keep track of the traf - fic through and the toll revenues

Draw an EER diagram for the following situation: City Transportation Authority needs to keep track of the traf- fic through and the toll revenues collected from the toll bridges, tunnels, and road toll stops (all of these are toll col- lection points) managed by the authority. Each toll collec- tion point has a unique name. Toll collection point data that should be maintained are a description, the day operations started at the collection point, and location coordinates. Each toll collection point has a number of toll booths identi- fied by a toll booth number, some of which are manned and some unmanned (using the city's QuickLane collection sys- tem). The city wants to separately track passenger vehicles, trucks, buses, and motorcycles. Each of these categories has a different toll amount at each toll collection point. At the vehicle level, only those vehicles using the QuickLane system can be identified with their license plate number, the make and model of each vehicle are also mainTained in the database. There are two types of employees: toll collectors and supervisors. Each supervisor is responsible for specific toll booths at a particular moment, and at this point, the system does not need to keep track of historical data regarding supervisory assignments. Each toll collector reports to a specific supervisor. The city wants to maintain records about the employees' names, addresses, phone numbers, and their years of service. A managerial capabil- ity rating (MCR) is maintained for the supervisors and a textual performance evaluation for each toll collector.

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

Harness The Power Of Big Data The IBM Big Data Platform

Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos

1st Edition

0071808183, 9780071808187

More Books

Students also viewed these Databases questions