Make a WPF App in Visual Studio and name it as A$2$YourFirstnameLastname.

$2.$ The app should be able to add and display the information about continents, countries, and their

cities.

$3.$ Download the WorldDB.sql file and use the SQL script it contains to create and populate the

database.

$$ Download from SLATE $->$ Content $->$ Module $6-$ Database Programming $->$ Sample Databases.

$$ When creating a new database, it must be named WorldDB, otherwise, the script will not run

properly. Ben Blanc $($Winter $2024)$

$$ Use LocalDB as database source, unless you$$ve got written permission from your professor to

use a different data source such as SQL Server or MDF file.

$4.$ The following image shows the relationship between these tables:

$5.$ You can use connected model, disconnected model, or typed datasets for this assignment.

$6.$ The application should have four windows:

$$ Home $|$ Add Continent $|$ Add Country $|$ Add City

Fall $2021$

Page $2$ of $3$

Home Window:

$1.$ This window has:

$$ ComboBox: to display list of continents.

$$ ListBox: to display list of countries.

$$ Labels: to display the selected country$$s most common spoken language$($s$)$ and currency.

$$ DataGrid: to display the information of cities, of the selected country.

$$ Buttons: three buttons to add continents, countries, and cities.

$2.$ On the initial window load, the ComboBox is populated with continents.

$3.$ On selecting a continent, its corresponding countries are loaded in the ListBox.

$4.$ On selecting a country:

$$ Its cities$$ information is loaded in the DataGrid.

$$ Its most common spoken language$($s$)$ and currency are displayed in the Labels.

$5.$ If a new country isselected in the ListBox, update the controlsto display the country$$sinformation

accordingly. Ben Blanc $($Winter $2024)$

$6.$ If a new continent is selected in the ComboBox, update the countries ListBox accordingly.

$$ And clear the language and currency Labels and DataGrid.

$7.$ On clicking one of the Add buttons, its corresponding window is displayed.

$$ For example, on clicking the Add Continent button, Add Continent Window is displayed.

$$ Display the Add window as a dialog box. User should not be allowed to go back to the Home

window as long as the Add window is open.

Add Continent Window:

$1.$ This window adds the name of the continent to the database table.

$2.$ This window has:

$$ TextBox: to type the continent$$s name.

$$ Buttons: to add the continent$$s name to the database and to close the window.

$$ Label: to display the validation message.

$3.$ The continent$$s name isrequired. If thisfield isleft blank, display an appropriate message in the label.

$4.$ On closing this window, clear all the fields, and update the Continents ComboBox to reflect the newly

added continents.

Add Country Window:

$1.$ This window has:

a$.$ ComboBox: to display list of continents.

b$.$ Three TextBoxes: to type the country name, language, and currency.

c$.$ Buttons: to add the above information to the database and to close the window.

d$.$ Labels: to display the validation messages.

$2.$ On the initial window load, the continent ComboBox is filled with continent names.

$3.$ Then, the user can type the name of the country, the most common spoken language$($s$)$ and currency

in the textboxes. Ben Blanc $($Winter $2024)$

$4.$ Continent and country fields must be required. If these fields are left blank, display appropriate

messages in the labels.

Fall $2021$

Page $3$ of $3$

Add City Window:

$1.$ This window has:

a$.$ ComboBox: to display list of countries.

b$.$ Two TextBoxes: to type the name of the city and its population.

c$.$ CheckBox: to select if this city is a capital city of the country or not.

d$.$ Buttons: to add the above information to the database and to close the window.

e$.$ Labels: to display the validation messages.

$2.$ On the initial window load, the county ComboBox is filled with countries.

$3.$ Then the user can type the name of the city and its population in the textboxes.

$4.$ The user can select the CheckBox to mark the city as capital city.

$5.$ Country and city name fields must be required. If these fields are left blank, display appropriate

messages in the labels.