3. (4 points) Write a program to read the DSN server list data from file DNSList.txt...

 

Transcribed Image Text:

3. (4 points) Write a program to read the DSN server list data from file DNSList.txt save data to the database file DNSList.sqlite using a database with the following schema to maintain the counts.. CREATE TABLE DNS (IP TEXT, Reliability INTEGER, Description TEXT) If the reliability of an IP <50, write "low" to description column, otherwise, write "Nornal" to description column. You can take the reliability of an IP at the end of IP address line. The program prints all rows of the table when sorted in descending order by reliability. The output should be as follows: DNS server list: IP 107.191.48.176 169.53.182.120 **** 213.184.225.37 109.228.14.251 212.83.168.230 82.127.173.1221 46.105.214.115 Reliability 99 99 Description Normal Normal 55 Normal 52 Normal 48 Low 32 Low 31 Low 3. (4 points) Write a program to read the DSN server list data from file DNSList.txt save data to the database file DNSList.sqlite using a database with the following schema to maintain the counts.. CREATE TABLE DNS (IP TEXT, Reliability INTEGER, Description TEXT) If the reliability of an IP <50, write "low" to description column, otherwise, write "Nornal" to description column. You can take the reliability of an IP at the end of IP address line. The program prints all rows of the table when sorted in descending order by reliability. The output should be as follows: DNS server list: IP 107.191.48.176 169.53.182.120 **** 213.184.225.37 109.228.14.251 212.83.168.230 82.127.173.1221 46.105.214.115 Reliability 99 99 Description Normal Normal 55 Normal 52 Normal 48 Low 32 Low 31 Low