Question: Here is some data on chainsaw juggling records, Chainsaw Juggling Record Holders as of July 2018 Country Number of catches Name Janne Mustonen Finland

Here is some data on chainsaw juggling records, Chainsaw Juggling Record Holders

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?

Step by Step Solution

3.39 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer SOURCE CODE import sqlite3 def createtable conn sqlite3connectchainsawjugglingdb c conncursor ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!