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

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. 

Step by Step Solution

3.30 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!