Question: 1. Using the sqlite3 module Unsaved Changes 3 points possible Reset to Starter Code Write a Python function named build_database, that takes a single string

1. Using the sqlite3 module Unsaved Changes 3 points possible Reset

1. Using the sqlite3 module Unsaved Changes 3 points possible Reset to Starter Code Write a Python function named "build_database", that takes a single string argument named "filename". The function should create a sqlite database in the tile provided with the following information within: A table named "students" with two columns, "name" which are TEXT and "points" which is are INTEGERs, and the following rows: 42 Dennis Nick Ike Gabe Be sure to commit and close your connection to the database in your function so that the testing code can open the database file you created. The function shouldn't return (or print) anything, just build the database in the location specified. Run Tests 1 v Grading 4 Full Screen code.py* New 1 import sqlite3 2- def build_database(filename): 3 pass Adding Data 0 / 0 pts - Click for details FAILED 0 Hidden 0/3 pts - Click for details FAILED e Order by name 0/0 pts - Click for details FAILED e Order by points 0 0 / 0 pts - Click for details FAILED

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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 Databases Questions!

In this exercise you will continue building list utility functions. In contrast with the previous exercise, for EX05 you will get practice writing unit tests for your functions which gives you more...

slide_right THIS WAS ALL THE INFORMATION FOR MY FUNCTION THE EXAMPLE of one function def calculate_inx(ROWS: int, COLS: int) -> int: """ Returns the index in the string representation of the game...

Problem 1: convert strings in snake_case to lowerCamelCase or UpperCamelCase. * * C programmers often use snake_case when naming functions or variables. In * JavaScript, we use lowerCamelCase (first...

General Instructions Create a new notebook named HW_05_YourLastName.ipynb and complete problems 1 - 8 described below. Download the files diamonds_partial.txt and titanic_partial.txt , placing them...

c++ In Part A, you will develop functions to convert a string to a row and column. As you develop them, you will write a main function to test them. Perform the following steps: 1. Create a main. cpp...

my code is shown below however it has some errors the following is the description of the exercise and the test cases where I have some issues in based on this can you please rectify my code and can...

second picture is the example similar to that will be appreciated python I try my best to zoom in For this Assignment you will practice some string and list methods and functions, as well as reading...

Practice Problem [no points]: You should read and understand Fibonacci algorithm, write a code in a high level language of your choice and in Assembly to find a Fibonacci number and check your...

Python: Clients and Servers: Problems: Develop two Python scripts: one a server; the other a client that will use the server. You will use the polynomial function module polynomials.py. Do not...

INSTRUCTOR SUPPLIED SOURCE FILE: #define INSTRUCTOR_FILE #ifdef INSTRUCTOR_FILE #include #include #define FILE_NAME_IX 1 // argv index for input file name #define TOTAL_ARGS 2 // number of command...

Each year, Management Accounting reports the results of a salary survey of the members of the Institute of Management Accountants (IMA). One year, the 2,112 members responding had a salary...

Mingu Inc. had the following balances in its shareholders' equity accounts at December 31, 2014: Share Capital 30,000 shares issued and outstanding ....$4,500,000 Retained Earnings .......... 625,000...

Although a few jurisdictions differ, most state rules and the federal rules have set a time limit of _ _ _ _ _ _ for admitting any evidence of convictions.a . 1 yearb. 5 yearsc. 1 0 yearsd. 2 0 years

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

b. Where did they come from?

c. What were the reasons for their move? Did they come voluntarily?

5. How do economic situations affect intergroup relations?