The Public Safety office at Millenium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Use the information provided in the table below to create a database to help the office keep track of tickets and payments. Additional Information:

• A student can have more than one car license (more than one car can be registered to a student).

• A student has only one driver’s license.

• A car can be licensed in only one state.

• The code of the ticket determines the fine. For example, a code 1 ticket is always $25 while a code 2 ticket is always $275. There are about 30 different codes, and the codes do change fairly often.

• The code of the ticket determines the description. For example, a code 1 ticket is always a parking meter violation.