Population Database In the Chap11 folder of the Student Sample Programs, you wil
ID: 3811264 • Letter: P
Question
Population Database
In the Chap11 folder of the Student Sample Programs, you will find a database file
named PopulationDB.mdf. The database has a table named City. The City table
has the following columns:
Column Name Data Type
City nvarchar(50) Primary key
Population float
The City column stores the name of a city and the Population column stores the
population of that city. The database has 20 rows already entered.
Create an application that connects to the PopulationDB.mdf database and allows
the user to perform the following:
• Use data-bound controls to add new rows to the database, change existing
rows, and delete rows.
• Sort the list of cities by population, in ascending order.
• Sort the list of cities by population, in descending order.
• Sort the list of cities by name.
• Get the total population of all the cities.
• Get the average population of all the cities.
• Get the highest population.
• Get the lowest population.
Explanation / Answer
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
Update rows:
SELECT * FROM Cities
ORDER BY population;
SELECT * FROM Cities
ORDER BY population DESC;
SELECT * FROM Cities
ORDER BY name;