Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started