Create the necessary tables and table relationships for the following:

 

Use the following information to create a database that supports all of the business needs for the Parking Permit Office. Create the necessary tables and table relationships. Populate the tables with the existing data. Enter data to give yourself a permit. Parking permits are issued to students, faculty, and staff. Only one parking permit per person is permitted. All types of individuals are treated in the same manner. Parking permit requests include: O Parking permit number > O O Citations are issued for parking violations. Citations are issued to both permit and non-permit holders. Each citation has only one violation. Citations include: O O O O Vehicle license plate number Person's name BE EM HA OA RA RD SD WL Citation Number Date of citation There are 8 types of violations: Violation Code Description Improper Parking Building Entrance Expired Meter Improper Parking Handicapped Area Improper Parking Other Area Improper Parking Reserved Area Time of citation Type of violation O Improper Parking Roadway Improper Parking Service Drive Improper Parking Walk/Lawn O O Fine $20 $15 $75 $20 $50 $15 $17 $22 For vehicles without permits License plate number For vehicles with permits Payments of fines are tracked. Payments can be made in installments. Payment records include: Payment Amount Date of Payment Permit number and license plate number Citation Number Existing Data O Assigned Permits can be found in "Permits Assigned to Owners.txt" O Existing Payments are in "Payments.xls" O License Plate numbers can be found in "license plate.txt" O O "citations.xls" All existing forms of data will continue to be collected. Name of people that are repeated across data files are the same individuals.