A driver may have 1 or many violations under a single ticket, we will store the violations made by driver in this table
v_id
ticket_number(this references to foreign key ticketnumber in table user_tickets)
violation_id(this foreign key references to violation_id in table user_violations)
A driver may have 1 or many violations under a single ticket, we will store the violations made by driver in this table
v_id ticket_number(this references to foreign key ticketnumber in table user_tickets) violation_id(this foreign key references to violation_id in table user_violations)