In this proof of concept (POC), I have developed a streamlined contact application utilizing SQLite as the underlying database. The primary aim of this project is to acquire foundational programming skills in SQL, comprehend effective code structuring in Python, implement comprehensive testing methodologies, employ requirement files for dependency management, and generate relevant diagrams to enhance understanding and documentation.

1. Set the enviroment
   1. Ensure you have Python installed on your machine
   2. Learn that SQLite3 comes pre-installed with Python
   3. Using the Python sqlite3 library
      1. Connect to a memory Database
   4. Create a table named contacts with columns like id, firstname, lastname, email, and phone  
2. Create functions for basic operations
   1. Implement functions:
      1. Add a contact
      2. Retrieve a contact
      3. Update a contact
      4. Delete a contact
   2. Implement a menu-driven uesr interface.

You can find the creation and the insertion SQL scripts in the documents table.

You are going to work with a database in memory with the following structure

and the initial data is the following

• SQL
  • SQLite
  • Queries for a CRUD operation:
    • INSERT -> CREATE
    • SELECT -> READ
    • UPDATE -> UPDATE
    • DELETE -> DELETE
• Documentation:
  • Entity Relationship Diagram (ERD) - Only Table Objecs
• Extensions:
  • Excel Viewer
  • Drawio
• Python:
  • Create Enviroment with PIP
  • Introduction To Classes
  • Read a file