Reference no: EM13910683
This is the final installment of the project! The focus is to write SQL queries that combine data from both Mondial and GapMinder (GM). For most queries you will need both Mondial and GM data, so you may need to use your bridge table(s).
Deliverable D8 (Warm-Up: Mondial Queries). For each (Mondial) country return the minimal,maximal, and average latitude of all cities in that country. The result should be ordered by continent (first) and country (second).
Deliverable D9 (Mondial + GM) Same as D8 but also include the Life Expectancy, Income, and Electricity for each country in the year 2000.
Deliverable D10 (Mondial + GM) For each continent, compute the average income (GDP/capita) in the year 2000 ...
(a) ... by simply averaging over the country income data in the year 2000 (unweighted average), and
(b) ... by taking into account the population of the country (weighted average).
Deliverable D11 (Extra Credit: Skyline Queries)
In the following, your task is to compute the names of countries which are in the skyline of a certain query. Here, a skyline is defined by giving two attributes (e.g. Life Expectancy and Health Spending)and indicating for each whether the min or max is used. Details and examples of expressing skyline queries in SQL will be given in class.
Deliverable D12 (Extra Credit: MyGapMinder)
In a visualization tool of your choosing, display the XY-plot for all years and all (or some) countries ... (a) ... where X is the Year and Y is the Life Expectancy, and
(b) ... where X is the Health Spending and Y is the Life Expectancy
For simplicity, you can “loosely-couple” Postgres with your visualization tool, by exporting the answers of your SQL queries to a file. Deliverable D13 (Extra Credit: EarthMinder) Put the data of the three result attributes from D9 onto a world map. For example, you can create a KML file and then view it using Google Earth.
|
Old town alexandria and reston
: He rented a location-bought 10 bikes and opened his first store in Vienna near an entrance to the W&OD Trail-where there is also parking-and near the historic Vienna Inn and a number of food and drink establishments-He has since opened stores in O..
|
|
Which choice has the greater present value if all banks pay
: You win a lottery. You have the choice of two ways to be paid. If you pick Payout Scheme X, you get $2,750 today. If you pick Payout Scheme Y, you get three payments: $1,000 today, $1,000 one year from today, and $1,000 two years from today. Which ch..
|
|
What are naomi taxable income items
: What are Naomi's taxable income items from these events for 2011? How much may the employer deduct for these expenses in years 1 and 2?
|
|
2-d environment
: Write a class called point for the 2-D environment. Select appropriate variable(s). Write constructors. Write access methods for the variables.
|
|
The focus is to write sql queries that combine data
: This is the final installment of the project! The focus is to write SQL queries that combine data from both Mondial and GapMinder (GM). For most queries you will need both Mondial and GM data, so you may need to use your bridge table(s).
|
|
Difference between the interest expense and interest paid
: What was the difference between the interest expense and interest paid in 2013-How much long-term debt will mature in 2014
|
|
Meqa assignment 1
: MEQA Assignment 1, 1. Estimate an empirical demand function for QuickKits™.2. Interpret the estimated demand function for QuickKits™.3. Make pertinent recommendations to senior management based on the empirical demand function.
|
|
Implements the features of the minesweeper game
: The map generator generates a rectangle matrix of 9 rows and 10 columns, and each cell of the matrix contains an integer 0 or 1 only. Such a matrix represents the map of the minesweeper game - write a Windows Console Application that implements mos..
|
|
Quality control purposes
: We want to take a sample of 100 items out of a large batch for quality control purposes-Based on past history-the proportion of defective items is 4%-Can we use the normal approximation to the binomial distribution to find the probability of findi..
|