Write a program that performs the following tasks:
Read article information from a CSV file named article_data.csv.
Insert the data into new tables of the library.sqlite database. The tables could b Journal and Article, ensuring journal entries are not duplicated.
- Prompt the user to enter a journal's name. The program will then print a list of articles from that journal. If no articles are found for the journal, print "No arti found in the journal."
Content of the input file article_data.csv
article_id, title, journal
1, Impacts of Climate Change on Marine Life, Journal of Marine Science
2, Advancements in Renewable Energy Technologies, Energy and Environment
3, The Role of Microplastics in Marine Ecosystems, Journal of Marine Science
4, Innovations in Water Desalination Techniques, Environmental Technology
Result of the program:
Zoom
+ 100%
Close
