Here is some data on chainsaw juggling records, Chainsaw Juggling Record Holders as of July 2018 Country Number of...

Transcribed Image Text:

Here is some data on chainsaw juggling records, Chainsaw Juggling Record Holders as of July 2018 Country Number of catches Name Janne Mustonen Finland 98 Ian Stewart Canada 94 Aaron Gregg Canada 88 Chad Taylor USA 78 EITHER part 1: Simple SQLite application. Build a Python application which stores the following example data in a SQLite database. Use the sqlite3 library, and write SQL statements. Your program should let the user search for a record holder, by name Your program should display all the record holders in the database • Your program should let the user add a new row for a record holder. • You should be able to update the number of catches for a record holder. • And, you should be able to delete a record, by record holder's name (for example, if a person's record was found to be invalid). Use parameterized statements where appropriate. OR Part 2: Peewee. Build the same program but use Peewee. You should still be able to add, edit, insert, and delete records from your database. To think about: how are the two ways to interact with a database different? Which do you prefer? When might you use one, and when might you use the other?

Answer rating: 100% (QA)

Answer SOURCE CODE import sqlite3 def create table conn sqlite3 connect chainsaw juggling db c conn View the full answer