Question

For this assessment, you will continue to use the SQLite3 library to perform common database tasks using Python. You can use Python's default editor IDLE (Integrated Development and Learning Environment) or a Python editor of your choice to complete this assessment.

Note: SQLite is included as part of the Python installation.

Your assessment will be scored on the following criteria:

1. Create a SELECT statement that contains only FirstName, LastName, and EmailAddress from the contacts table
2. Create an UPDATE statement that updates a contacts EmailAddress and PhoneNumber.
3. Delete the information for the last contact added to the contacts table.
4. Execute a SELECT statement to retrieve all the columns of data from your contacts table.
5. Test your code and document testing by taking screenshots.

Answer 1

SELECT statement that contains only FirstName, LastName, and EmailAddress from the contacts table

UPDATE statement that updates a contacts EmailAddress and PhoneNumber.

Delete the information for the last contact added to the contacts table.

SELECT statement to retrieve all the columns of data from your contacts table.