You are required to design an English-Turkish dictionary program. In this program, words and their meanings. It must be written to the SQLite database. The name of the database you will create should be “Dictionary”.
Ø Separate functions named “Create Table, Data Entry, Data Delete, DataRead” should be created. The functions of the functions should be as their names suggest.
Ø There should be a table named “ingTrkSozluk”. Table fields should be "ID (integer), ing(text), Trk(text)".
Ø Create a “Class” named “Sozlukyapisi” in your program. "English, Turkish" in this class
They should have properties in their names.
Ø You must log in to your program with a username and password. Username= Admin Password=Asd2020* set as. Username and password information must be entered into the database. User, username and when he enters the password information, the verification must be done through the database.
Ø You should design a menu in your program. In this menu “Add Word, Search Word, Statistics, and Exit”
The name should have four options.
Ø When “Add Word” option is selected, English words and Turkish words are continuously added until “q” is pressed. Their meanings should be taken from the user and written into the database.
Ø After pressing “q” it should go to main menu.
Ø When the “Search for Word” option is selected, English is searched from database until “E” key is pressed. words should be searchable and the searched English word and Turkish should be printed on the screen.
Ø After pressing the “E” key, the user should go to the main menu.
Ø When the “statistics” option is selected, how many words are added to the system until the “Q” key is pressed? and how many words he searched should be displayed.
Ø After pressing the “Q” key, the user should go to the main menu.
Ø When the “Exit” option is selected, the program should be closed.
Ø At least 30 pieces of data must be entered into the database of your program through the program you wrote.
The program must be in Python language.