Write a Python program to do the followings.

Create an SQLite database $"$MyDB$.$db$".$

Create a table named "Product".

Determine the data types of its attributes as necessary.

Set "ProductiD" as the primary key.

Populate the table with the following data.

If a piece of data is missing, put None for it$.$

Create a table named "Sales".

Determine the data types of its attributes as necessary.

Set $("$ProductiD$"+$ "Date$1")$ as a primary key.

Set "ProductiD" as a foreign key with reference to "Product" table.

Populate the table with the following data.

If a piece of data is missing, put None for it$.$

Try to insert the following row into "Product" table and see what happens.

Display "Insertion error into Product" if it gives you an error $($use try..except$).$

Try to insert the following row into "Sales" table and see what happens.

Display "Insertion error into Sales" if it gives you an error $($use try. except$).$

Select all the attributes from "Product" table whose prices are greater than $5.$

Select all the attributes from "Product" table for the products with no description

$($use $"$IS NULL"$).$

Select the distinct types from "Product" table.

Select names, types, and descriptions from "Product" table whose description include the

word "tool" $($use $\%$ bath before and after the word$)($use $"$ to put a quote within a string$).$

Find the total quantity of all products sold on $"11-10-2023".($Hint: run a select SQL query

first. Iterate on the resultant tuples to find the sum. $($or$)$ Do Google search to know how to

do it in a select SQL query using "GROUP BY$".)$

Select product names, dates, and sales amounts $($i$.$e$.,$ price $"$ quantity$)$ of all the sales

records. $($Hint: you need to join two tables.$)$Please help me solve this $1.$ Write a Python program to create an array of $5$ integers and display the array items. Access individual element through indexes. $2.$ Write a Python program to append a new item to the end of the array. $3.$ Write a Python program to reverse the order of the items in the array. $4.$ Write a Python program to get the length in bytes of one array item in the internal representation. $5.$ Write a Python program to get the number of occurrences of a specified element in an array. $6.$ Write a Python program to insert a new item before the second element in an existing array. $7.$ Write a Python program to remove a specified item using the index from an array. $8.$ Write a Python program to remove the first occurrence of a specified element from an array. $9.$ Write a Python program to demonstrate adding Elements to an Array, Accessing element from array $10.$ Write a Python program to demonstrate slicing of elements in an Array $11.$Python code to demonstrate searching an element in array $12.$ Python code to demonstrate how to update an element in array