Reference no: EM13914444
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.
(a) Compute the country skyline for (Life Expectancy MAX, Health Spending MAX) for the year 2000.
(b) Same as (a) but for (Life Expectancy MAX, Health Spending MIN).
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.
|
Activity area assist in the generation of profits
: What are the key activity areas for securities firms? How does each activity area assist in the generation of profits and what are the major risks for each area?
|
|
When preparing capital budgeting analysis for new project
: When preparing capital budgeting analysis for a new project, Chris Johnson, a chief financial officer at BT Industries, faced a dilemma. The project involved a production of new type of shipping containers, What is the Present Value of this project?
|
|
Pay off this debt assuming
: Today, you borrowed $3,100 on your credit card to purchase some furniture. The interest rate is 12 percent, compounded monthly. How long will it take you to pay off this debt assuming that you do not charge anything else and make regular monthly paym..
|
|
What is the total number of stickers
: The producity of a worker at a scrapbook sticker company increased as an Arithmetic Sequence (Progression) over a period of 7 days. That is, on day n she produced an = a1 + (n - 1)d stickers. If a7 = 160 and d = 10 what is the total number of stick..
|
|
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).
|
|
Estimate the sales price of product
: You are evaluating a product for your company. You estimate the sales price of product to be $230 per unit and sales volume to be 11,300 units in year 1; 26,300 units in year 2; and 6,300 units in year 3. The project has a 3 year life. The tax rate i..
|
|
Regarding the use of probability distributions
: Which one of the following statements is correct regarding the use of probability distributions?
|
|
Discuss the implication of correlation coefficient
: Please draw the efficient frontiers and discuss the relevant implication under the following assumptions: (a) Risk free assets are possible and short sale is not allowed; (b) Risk free assets are impossible and short sale is not allowed. Please discu..
|
|
Account earns compounded monthly
: How much will you have in an account after 25 years if you put $1300 per month in the account earns 8% compounded monthly?
|