We have looked at a variety of ways to store information using Python. But a com


We have looked at a variety of ways to store information using Python. But a company of any size does not use text files, or pickle things. They use, in almost all case, a relational database management system. We are going to use sqlite3 for this assignment, and it will do just fine for the amount of data we intend to wrangle.The database for this assignment is named tickets5.db. The tickets5.db will be provided as a zipped file later on this page. The database has a little over 20 records, all of which started out as part of a database put together in Minnesota that cataloged speeding tickets issued in 2014. The original database had thousands of records. I have whittled it down for this assignment to about 22 simplified records. The table holding these records is named tickets. The first rows look like this.tickets tableThe tickets table has these 5 fields. Do not modify the database name, the table structure, or modify the column names; your code should work with my copy of the database.tid is an auto-incrementing primary keythe next 3 fields: actual_speed, posted_speed and age, are all of type integerthe last field, violator_sex, is of type string.Here is the link to the database. Unzip before using:  tickets5.zipYour program should be able to read the table in this database and be able to perform the following functions.program menu.Your program must have a main() function and separate functions to handle the display of all tickets, and the ability to add a new ticket record to the tickets table. For option 3 your function should allow the user to enter either ‘Male’ or ‘Female’ and then have your code filter the tickets table and show either all the Male offenders or all of the Female offenders.When data is printed it all the data should be properly aligned and look neat. Whether you are printing all the tickets or only part of them, your output should display this information: ticketID, Posted MPH, MPH Over, Age, and Violator Sex.outputIt is important to note that the original table has Posted MPH (posted_speed) and actual_speed. You must calculate and display the MPH over the posted speed limit rather than displaying the actual_speed itselfmph over = actual speed posted speed.For example the ticket associated with tid = 1 was doing 95 in a 70mpg zone, so miles over is 95 70 = 25.I added some pics that were there as well tickets5.zip file