2. The Public Safety office at Millennium College maintains a list of parking tickets issued to...

Transcribed Image Text:

2. The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. The following table show a portion of this list. Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 3 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 a. Convert this table into a relation in INF and named it PARKING TICKETS. b. What are the determinants in the PARKING TICKETS relation? c. Draw a graphical relational schema for PARKING TICKETS with functional dependencies. d. Transform it to a set of graphical 3NF relations, including referential integrity constraints and functional dependencies. 2. The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. The following table show a portion of this list. Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 3 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 a. Convert this table into a relation in INF and named it PARKING TICKETS. b. What are the determinants in the PARKING TICKETS relation? c. Draw a graphical relational schema for PARKING TICKETS with functional dependencies. d. Transform it to a set of graphical 3NF relations, including referential integrity constraints and functional dependencies.