A tollway in Melbourne needs to keep a small database of their registered customers. They do not
Question:
A tollway in Melbourne needs to keep a small database of their registered customers. They do not use toll tags, but record road usage using cameras that recognize vehicle license plates. Before using the road, customers must register an account using an email address. Next they can add one or more vehicles to their account, each vehicle having a unique license plate number. The tollway have (camera-equipped) toll booths located at all entry and it points. When a registered vehicle uses the tollway, a new trip record is created containing information about the entry and exit points. For the given scenario, draw an Entity Relationship Diagram (ERD) to show the database design. Using the crow's foot notation, show all entities and their relationships. Indicate the type of all relationship. If there are any MN relationships, resolve them to 1:M. Entity attributes are NOT required.
College Algebra Graphs and Models
ISBN: 978-0321845405
5th edition
Authors: Marvin L. Bittinger, Judith A. Beecher, David J. Ellenbogen, Judith A. Penna