De Anza College User and Server Connection Request Data Flow Diagram

ONLY NEED UML

The user (client) requests data from the (server) database. The database sends back the data to the user. At acquisition of the data, the user draws an XY Plot to plot the data.

DataFile: UNData.xml

GUI Layer:

Use TKinter to produce a pull-down for the user to select a country. Then construct a Database query to extract the yearly data (1990,2017). The data may be query either country year-by-year or in one query by country.

Data Layer:

The business layer sends a SQL query to the Database and the Database sends back a JSON string with the requested data.

Business Layer:

Creates the SQL database from the UNData.xml file, and constructs the query. After the query has been processed, format the returned data from the database as a JSON string.

User Layer:

The user selects a country, and passes that name to the business layer. The business layer sends back a JSON string, that the user processes. The data is then displayed using MatPlotLib.

Server Socket:

The database access is controlled by the Server Socket. The client sends a query, and the server sends a JSON string.

Client Socket:

Requests data from the server. After receiving the data from the server, the client displays the data.