Problem:
The Department of Motor Vehicle (DMV) wants to examine red-light violations in 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's ID, the officer's remark).
Draw a 3NF ERD (without attributes) using crow's foot notation.
Provide a logical database schema.
Provide a physical database schema.