Please fill in the following Python code below, with the answers in correlation with the database and Questions in the provided images

Python Code:

import sqlite$3$

from sqlite$3$ import Error

def openConnection$(\_$dbFile$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Open database: $",\_$dbFile$)$

$$conn $=$ None

$$try:

$$conn $=$ sqlite$3.$connect$(\_$dbFile$)$

$$print$("$success$")$

$$except Error as e:

$$print$($e$)$

$$print$("++++++++++++++++++++++++++++++++++")$

$$return conn

def closeConnection$(\_$conn, $\_$dbFile$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Close database: $",\_$dbFile$)$

$$try:

$\_$conn.close$()$

$$print$("$success$")$

$$except Error as e:

$$print$($e$)$

$$print$("++++++++++++++++++++++++++++++++++")$

def createTable$(\_$conn$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Create table"$)$

$$print$("++++++++++++++++++++++++++++++++++")$

def dropTable$(\_$conn$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Drop tables"$)$

$$print$("++++++++++++++++++++++++++++++++++")$

def populateTable$(\_$conn$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Populate table"$)$

$$print$("++++++++++++++++++++++++++++++++++")$

def Q$1(\_$conn$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Q$1")$

$$try:

$$output $=$ open$(\text{'}$output$/1.$out', $\text{'}$w$\text{'})$

$$sql $=\_$conn.execute$("$SELECT $*$ FROM warehouse"$)$

$$table $=$ sql$.$fetchall$()$

$$header $="\{$:$>10\}\{$:$<40\}\{$:$>10\}\{$:$>10\}\{$:$>10\}"$

$$output$.$write$(($header$.$format$("$wId$",$ "wName", "wCap", "sId", "nId"$))+\text{'}$

$\text{'})$

$$for i in range$(0,$ len$($table$))$:

$$output$.$write$(($header$.$format$($str$($table$[$i$][0]),$ str$($table$[$i$][1]),$ str$($table$[$i$][2]),$ str$($table$[$i$][3]),$ str$($table$[$i$][4])))+\text{'}$

$\text{'})$

$$output$.$close$()$

$$except Error as e:

$$print$($e$)$

$$print$("++++++++++++++++++++++++++++++++++")$

def Q$2(\_$conn$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Q$2")$

$$try:

$$output $=$ open$(\text{'}$output$/2.$out', $\text{'}$w$\text{'})$

$$header $="\{$:$<40\}\{$:$>10\}\{$:$>10\}"$

$$output$.$write$(($header$.$format$("$nation$",$ "numW", "totCap"$))+\text{'}$

$\text{'})$

$$output$.$close$()$

$$except Error as e:

$$print$($e$)$

$$print$("++++++++++++++++++++++++++++++++++")$

def Q$3(\_$conn$)$:

$$print$("++++++++++++++++++++++++++++++++++")$

$$print$("$Q$3")$

$$try:

$$input $=$ open$("$input$/3.$in$","$r$")$

$$nation $=$ input.readline$().$strip$()$

$$input$.$close$()$

$$output $=$ open$(\text{'}$output$/3.$out', $\text{'}$w$\text{'})$

$$header $="\{$:$<20\}\{$:$<20\}\{$:$<40\}"$

$$output$.$write$(($header$.$format$("$supplier$",$ "nation", "warehouse"$))+\text{'}$

$\text{'})$