Week 26 - Extracting and Using Data

[NavanYatavelli]

1. Build copies of Notebooks with answers/comments for all questions and hacks in

• 2.4a -All answers/comments added
• 2.4b -All answers/comments added

Debugging screenshots showing understanding of key Objects. (.9+)

SQL Table showing the current list of swimmers

Breakpoint in code showing the create method adding data for new swimmer

Breakpoint in code showing the new swimmer has been created

Output of the code cell showing that the new swimmer has been added

SQL Table showing after the new record for swimmer is added

2. Create your own Jupyter Notebook, using your own table. (.9) Notebook with Table

• This uses SQL Alchemy Library Object Oriented Python Classes to interact with DB table "swimmer"
• Added create, read, update, delete functions

3. Create Menu/Tester with all CRUD operations, including Delete and Update). (.9) Menu with CRUD

• This uses SQLite3 Library Connection Cursor API to interact with DB table "swimmer"
• Added create, read, update, delete menu functions

My Quiz Results

This quiz were fairly straightforward. I would say I understand the concepts.

I got this question incorrect. I now understand that A is one of the correct choices because the user wants to retrieve the file without any loss. So lossless compression algorithm before uploading is what user wants.

Now I fully understand the mistake I made. I selected one wrong answer and one correct answer. The correct answer is sort by year, then filter by year, then filter by photographer.