For this assignment you will write a Python program to create and interact with a database. You are given a file containing temperature readings for each day of the week. Using the SQLite connector, your program should perform the following steps:

$1.$ Create a SQLite database

$2.$ Create a table with the following fields:

a$.$ ID $$ primary key

b$.$ Day$\_$Of$\_$Week $$ String

c$.$ Temperature$\_$Value $$ float

$3.$ Read the input file and insert each piece of data into your database table

$4.$ Execute the SQL commands to compute the average temperature for Sunday and Thursday, and print the results to the console.

Assignmentinput.txt file:

Monday $11\mathrm{.}7$

Monday $36\mathrm{.}6$

Monday $16\mathrm{.}0$

Sunday $59\mathrm{.}4$

Monday $87\mathrm{.}9$

Wednesday $18\mathrm{.}0$

Monday $23\mathrm{.}4$

Friday $55\mathrm{.}2$

Thursday $6\mathrm{.}6$

Tuesday $19\mathrm{.}8$

Monday $60\mathrm{.}5$

Tuesday $11\mathrm{.}3$

Thursday $4\mathrm{.}9$

Saturday $45\mathrm{.}6$

Wednesday $89\mathrm{.}4$

Wednesday $38\mathrm{.}6$

Sunday $49\mathrm{.}1$

Friday $59\mathrm{.}8$

Thursday $49\mathrm{.}2$

Friday $19\mathrm{.}7$

Saturday $82\mathrm{.}4$

Friday $96\mathrm{.}7$

Thursday $92\mathrm{.}7$

Tuesday $76\mathrm{.}1$

Friday $71\mathrm{.}8$

Monday $58\mathrm{.}6$

Monday $93\mathrm{.}6$

Thursday $13\mathrm{.}2$

Thursday $62\mathrm{.}7$

Sunday $73\mathrm{.}9$

Wednesday $33\mathrm{.}6$

Tuesday $5\mathrm{.}4$

Tuesday $23\mathrm{.}0$

Monday $47\mathrm{.}3$

Sunday $98\mathrm{.}1$

Wednesday $71\mathrm{.}0$

Wednesday $67\mathrm{.}6$

Saturday $27\mathrm{.}7$

Tuesday $81\mathrm{.}4$

Wednesday $84\mathrm{.}9$

Monday $15\mathrm{.}7$

Thursday $42\mathrm{.}8$

Saturday $81\mathrm{.}6$

Tuesday $41\mathrm{.}7$

Saturday $58\mathrm{.}0$

Friday $62\mathrm{.}9$

Saturday $12\mathrm{.}6$

Saturday $54\mathrm{.}0$

Sunday $74\mathrm{.}0$

Sunday $74\mathrm{.}9$

Sunday $42\mathrm{.}1$

Wednesday $96\mathrm{.}6$

Sunday $90\mathrm{.}7$

Wednesday $92\mathrm{.}8$

Saturday $17\mathrm{.}7$

Thursday $50\mathrm{.}0$

Tuesday $36\mathrm{.}9$

Monday $82\mathrm{.}5$

Thursday $15\mathrm{.}4$

Sunday $26\mathrm{.}0$

Saturday $58\mathrm{.}9$

Monday $98\mathrm{.}4$

Friday $11\mathrm{.}4$

Sunday $100\mathrm{.}7$

Saturday $17\mathrm{.}0$

Wednesday $93\mathrm{.}4$

Friday $100\mathrm{.}6$

Tuesday $46\mathrm{.}7$

Monday $61\mathrm{.}4$

Saturday $43\mathrm{.}0$

Wednesday $36\mathrm{.}3$

Saturday $64\mathrm{.}6$

Tuesday $64\mathrm{.}9$

Tuesday $73\mathrm{.}4$

Saturday $6\mathrm{.}6$