The Public Safety office at NCC maintains a list of parking tickets issued to vehicles parked illegally on the campus. Parking Ticket Table below shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space). STID LName FName PhoneNo State LicNo Ticket# Date Code Fine Violation 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/10 2 $25 Parked in Fire Lane 38249 Brown Thomas 111-7804 FL BRY 123 16017 11/13/10 1 $15 Parked On Grass 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/10 3 $100 Handicap Spot no Handicap Sticker 82453 Green Sally 391-1689 AL TRE 141 16293 11/18/10 1 $15 Parked On Grass 82453 Green Sally 391-1689 AL TRE-141 17892 12/13/10 2 $25 Parked in Fire Lane a) Develop an E-R diagram with the appropriate cardinality notations from the below table. b) Map the ER diagram created in step (a) above into a relational schema.

pls and thank you