a$)$ draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data.

b$)$ Develop a set of relations in third normal form. Include a new column with the heading Violation in the appropriate table to explanin the reason for each ticket. Expected values in this new column are: expired parking meter $($ticket code $1),$ no parking permit $($ticket code $2),$ and handicap violation $($ticket code $3).$