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

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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!