Question: 3. Develop a database program that creates a database named cities.db. The cities.db database must have a table named Cities, with the following columns:
3. Develop a database program that creates a database named cities.db. The cities.db database must have a table named Cities, with the following columns: Column Name Data Type I Attributes City Name Text CityID Population Integer Real Primary Key The CityName column stores the name of a city and the Population column stores the population of that city. Write a program that connects to the cities.db database, and allows the user to perform any of the following operations: Display a list of cities sorted by population, in ascending order. 0 Display a list of cities sorted by population, in descending order. Display a list of cities sorted by name. 0 Display the total population of all the cities. Display the average population of all the cities. 0 Display the city with the highest population. Display the city with the lowest population. (20)
Step by Step Solution
There are 3 Steps involved in it
To address the requirements specified in the question we can develop a Python program that interacts with an SQLite database named citiesdb Well use the sqlite3 module to connect to the database and p... View full answer
Get step-by-step solutions from verified subject matter experts
