Question

The Great American University, like most universities, has limited parking on campus. As a consequence, there are frequent parking infractions resulting in parking tickets being issued on a regular basis. Each parking ticket is written by one Department of Parking and Transportation (DPT) employee and relates to exactly one on-campus parking lot (of which there are several). The ticket is placed under the wiper of the violator’s car, which is assumed to be equivalent to giving the ticket to the violator. It is important to be able to track the number of tickets written by each employee. Each parking ticket is associated with one “violator” who could be a student, faculty/staff, or other (unknown) individual. The DPT collects the parking ticket fine, which must be paid by the violator within 21 days of ticket issuance. The payment is taken by one cashier of DPT. A payment receipt is given to the violator to acknowledge payment. The parking fine amount is deposited into the account maintained at the university credit union. Each parking ticket can only be paid one time, but violators can pay for several tickets together through one payment process.

Required: For the parking ticket issuance and fine collection scenario described above, prepare an REA-patterned entity-relationship diagram.

Answer 1

In the question it has been asked about the REA patterned Entity-Relationship diagram for the parking ticket issuance and fine collection scenario. The diagram for the same is given below as asked in the problem