Create a new Python script named library.py$.$

Write a Python script using the sqlite$3$ module to create a database named 'library.db$\text{'}$ and a table in it named 'books'. This table should have the following columns:

$\text{'}$id$\text{'}$: a unique identifier for each book $($primary key$)\text{'}$title$\text{'}$: the title of the book'author': the author of the book'publication$\_$year': the year the book was published'genre': the genre of the book

Insert data into the 'books' table. This data can be real or made up$,$ but should include at least $10$ different books from at least $5$ different genres.

Write Python scripts using the sqlite$3$ module to perform the following tasks

Select all books in your table Select all books of a specific genre $($of your choice$)$Update the publication year of a specific book Delete a specific book from the table