The Program Student Learning Outcome (PSLO) to be assessed will be: Demonstrate proficiency in the use of technological tools.

Technology Assessment Test (Spring 2018)

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.)

Based on the following E-R diagram, please create the appropriate cardinality notations (40%)

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. (60%) use word to create the tables.

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