Project 1 - English Dictionary App & Library Book Management System

Dictionary Application:

In this project, There are 4 operations

1. Add a word
2. Find meaning of a word
3. Update a word
4. Exit from the application

This application needs an infinite loop to repeat any given operation and breaks only when the
user chooses to exit.

1. Add word and its meaning:

● Take a word and its meaning as an input and keep it in a dictionary.
● Open a file in write mode and using json module dump() the dictionary can be dumped/stored in the file.
● Close the file

2. Find meaning of a word:

● Take the word as an input.
● Open the file in read mode and using json module load(), the dictionary can be loaded from the file.
● After loading the dictionary, check if the given input word is existing in the dictionary and if existing then get the meaning of the word and display
● If the word doesn’t exist, display an appropriate message that the word is not found.
● Close the file

3. Update the dictionary:

● Take the word and its meaning that is to be updated for the given word.
● Open the file in read mode and using json module load(), the dictionary can be loaded from the file.
● After loading the dictionary, Close the file.
● Check if the given input word is existing in the dictionary and if existing then update the given word in the dictionary, with its new meaning given as input.
● Open the file in read mode and using json module dump(), the updated dictionary
can be dumped/stored in the file.

4. Exit the application:

Break the infinite loop

Library Book Management System:

In this project, there are 5 operations

1. Create
2. Read
3. Update
4. Delete
5. Exit

This application needs a database created using sqlite3 module to include a table in it and store
different book records. Also needs a GUI window created using the tkinter module having labels,
input boxes, buttons to interact with the user and perform different operations on the records
present in the database upon clicking a button and use a tree view to display the book records
to the user.

1. Create book records:

● Take the book details from the GUI window.
● Establish connection with the database and insert the book record into the table.
● Commit the changes done to the table.

2. Read book record:

● Establish connection to the database to get the book records.
● Insert the records onto the tree view using tkinter, to display them to the user.

3. Update the records:

● Take the book title along with the details to be updated from the GUI window.
● Establish the connection to the database and check if the book is existing in the table, if yes then update the book with the given details.
● Commit the changes done to the table
● If the book does not exist, display an appropriate message.

4. Delete the records:

● Take the book title that is to be deleted from the GUI window.
● Establish the connection to the database and check if the book is existing in the
table, if yes then delete the book record from the table.
● Commit the changes done to the table.
● If the book does not exist, display an appropriate message.

5. Exit the application:

Destroy the GUI window