5. Police Department maintains a list of parking tickets issued to vehicles parked illegally on campus. The following table shows a portion of this list for part of the fall semester.

SID	L_Name	F_Name	Phone	Tag_State	Tag_#	Ticket_#	Date	Code	Fine
38249	Hurryup	Janna	294-03221	IA	BRB_333	14356	9/24/17	2	$50
						15442	10/1/17	3	$75
58871	Lazee	Ina	296-8898	IL	SLO_223	13258	9/15/17	1	$24
						13554	9/17/17	1	$24
						14434	9/26/17	3	$75

a. Convert this table to a relation in 1NF by entering appropriate data in the table.

b. Draw a dependency diagram showing all functional dependencies in the relation, based on the sample data provided.

c. Develop a set of relations in 3NF. Include a new column with the heading Violation in the appropriate relation to explain the reason for each ticket. Values are: 1 = Expired parking meter; 2 = no parking permit; 3 = handicap space violation.