The Public Safety office at CSUSM maintains a list of parking tickets issued to vehicles parked illegally on the campus. The Table above shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.)

a. Based on the following Entity-Relationship (E-R) diagram, please create the appropriate cardinality notations

b. Create a database with multiple tables in your assigned database environment with records shown above in the parking ticket table. Indicate the primary keys and foreign keys in each table if possible.

Parking Ticket Table St ID N Date Code Ticket BRY 123 15634 16017 TRE 141 14987 16293 17892 St Lic Fine $25 $15 $100 L Name F Name Phone No Lic No 38249 10 17/12 11/13/12 10/05 12 11/18/12 12/13/12 Brown Thomas 111-7804FL 82453 Green Sally 391-1689 AL $25