Problem
The Departmentof Motor Vehicle (DMV) wants to examine red-light violationsin some counties. To do so, DMV obtains from those countries red-light citations and enters relevant data into a database. It plans to keep track of the driver (e.g., name, address, license number), red-light camera (e.g., location ID, address), and violation report (e.g., date & time, photo evidence, the officer'sID, the officer's remark).
Draw a 3NF ERD (without attributes) using crow's foot notation.