Skip to content

A5: CRUD II

Do the UD in CRUD (Update and Delete)
Week 4 Assignment – Due 2/13/2024 – Beginning of Class
100 points

Overview:
Assignment 5 builds upon the previous task of integrating a SQLite3 database with your Python application. In this stage, you will complete the database interaction functionalities by implementing the ‘Update’ and ‘Delete’ operations (UD). This will enable your application to modify existing data and remove data from the database, thereby providing a full spectrum of data management capabilities essential for dynamic applications.

Objectives:
  • Enhance your Python application by adding ‘Update’ and ‘Delete’ functionalities.
  • Ensure robust and efficient interaction between the Tkinter application and the SQLite3 database for data modification and deletion.
  • Strengthen your understanding of database management and CRUD (Create, Read, Update, Delete) operations in a real-world application context.

Deliverables:
  1. Updated Tkinter Application with UD Functionalities
    • Description: Extend the functionality of your Tkinter application to include ‘Update’ and ‘Delete’ operations using the SQLite3 database. This should allow users to modify and remove existing data within the application.
    • Requirements: The application should seamlessly perform these new operations while maintaining its core functionalities. All code should be well-structured, commented, and free from bugs.
  2. Database Interaction Demonstration
    • Description: Conduct a demonstration that clearly shows the ‘Update’ and ‘Delete’ functionalities in action. Emphasize how these operations are executed within the application and interact with the SQLite3 database.
    • Duration: 5-10 minutes per group.

Submission Guidelines:
  • Submit the updated source code files to your group GitHub for the Tkinter application with the CR functionalities. Put your GitHub link into GeorgiaView.
  • Include the SQLite3 database file (.db) even if there were no updates.

Evaluation Criteria (100 points):
  • Effectiveness and reliability of the ‘Update’ and ‘Delete’ operations within the application.
  • Quality of integration and interaction between the application and the database.
  • Demonstrated understanding of CRUD operations in the context of a Python application.