CRUD stands for Create, Read, Update and Delete. It is used in database applications to manage data and its persistent storage.
CREATE refers to the methods of adding new data to the database. Adding in database involves the INSERT SQL statement.
READ refers to the methods of retrieving existing data from the database. Retrieving involves the SELECT SQL statement which queries the database to obtain data.
UPDATE refers to the methods of changing the data from the database. This modification involves the UPDATE SQL statement that changes the values of one or more fields in the database.
DELETE refers to the methods of removing existing data from the database. It involves the DELETE SQL statement.
From Chapter 14 Exercise from the book by Toni Gaddis, Starting Out with Python, 5th edition, the CRUD Operation applies. Below is the operation when the program is run.
The technologies used are Python and SQLite.
You may find my code in my GitHub repo here.
