Modern Database Management
Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 3.30PAE

Draw an EER diagram for the following situation: City Transportation Authority needs to keep track of the traffic through and the toll revenues collected from the toll bridges, tunnels, and road toll stops (all of these are toll collection points) managed by the authority. Each toll collection 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 identified by a toll booth number, some of which are manned and some unmanned (using the city's QuickLane collection system). 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 capability rating (MCR) is maintained for the supervisors and a textual performance evaluation for each toll collector.

Blurred answer
Students have asked these similar questions
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored.    Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years).    A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…

Chapter 3 Solutions

Modern Database Management

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
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
9.1.2 Software Development Approaches; Author: EIToppo;https://www.youtube.com/watch?v=Z9znuSQ7Sz8;License: Standard YouTube License, CC-BY