User Account

All Pages

Queries against the world database tables

Assignment Help Basic Computer Science
Reference no: EM131156776

Your task for this final project will be to write queries against the World database tables. There are three tables used to store data about Countries, Cities and CountryLanguages. These tables along with the data exists in all the four group databases (IST210JamesJGrp1, IST210JamesJGrp2, IST210JamesJGrp3, IST210JamesJGrp4). You can work as a team or individually but each student must submit their own work. While working as a team you need to highlight what part of the queries you worked on. The ER diagram is shown at the end of this document along with the Database diagram and the sample output for each question. Answer the following queries listed below:

  1. List the Continent, Country Name, District, City Name and City Population of for all cities with a population of over 3 million people. Sort the results by Continent, Country Name, District and City Name. (10 points)
  2. List Country Name, Language Percentage and Country Population where language spoken is English and English is the official language. Sort the result by Percentage desc, and countryname asc. (10 points)
  3. List the Life Expectancy, Population, CountryName, HeadOfState, Official Language where population > 100000000 and English is the official language. Sort the result by LifeExpectancy and population. (10 points)
  4. List CountryName and their Capital City where country's surface area > 2000000. (10 points)
  5. List the headofstate for the country = 'USA'. (10 points)
  6. List all the CountryCodes where headofstate = 'George W. Bush'. (10 points)
  7. List the name of the country and count of cities. (10 points)
  8. List the name of the country and count of cities having count of cities > 10. (10 points)
  9. List the name of the country and sum of population across all cities in the United States. (10 points)
  10. List the name of the country and sum of total percentage of non-english speaking population (10 points)

Submission: Each student must submit their own Final Project document as FinalAssignment.sql file. Just write your queries against each question in this file. When working as a team explain in what specific queries you worked on? DO NOT INCLUDE OUTPUT/RESULT. ONLY THE QUERIES ARE SUFFICIENT

Reference no: EM131156776

Questions Cloud

About high performance and balanced scorecard : What have you learned about high performance and balanced scorecard/competing forces? Are measures missing? What measures are superior? What is your root cause analysis of what makes an organization high performing? What is your new idea for making t..
Analysis patterns and design patterns : What are the differences between analysis patterns and design patterns?
What is the function of the central bank : What is Central Bank? What is the Function of the Central Bank? Purpose of Central Bank? What is State Bank & its Role? Function of State Bank (SB)? Activities and responsibilities of Central Bank?
Describe the steps in an implementation plan : Describe the steps in an implementation plan. Identify possible project issues and determine ways to evaluate project success. Should a separate operationalization plan be developed for moving into a new space? Why? What are three ways to engage the ..
Queries against the world database tables : Your task for this final project will be to write queries against the World database tables. There are three tables used to store data about Countries, Cities and CountryLanguages. These tables along with the data exists in all the four group data..
Describe and calculate the federal income tax : describe and calculate the federal income tax consequences to your client from the proposed estate freeze.- describe all the income tax consequences to both Alex and to Newco and show your calculations.
What is structured query language : What is structured Query Language? Write the SQL command for deleting tuple(row) from the database?
How hipaa security rule protect patient information : As a future health care professional, is it important that you fully understand the HIPAA Privacy Rule that health care professionals must follow. As part of your class, you will be given the chance to earn a HIPAA Certificate of Completion. You w..
Identify the author of the message : For the analysis, you must: Identify the author of the message. Explain the creative techniques used to capture the attention of the audience. Identify and explain the values and points of view that are contained within the message and those that ar..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Project profiling besides budget size

Propose another attribute that might be used for project profiling besides budget size, location, And technical knowledge. Include the following in your answer:

  A boolean matrix has the parity property

A Boolean matrix has the parity property when each row and each column has an even sum, i.e. contains an even number of bits which are set. Here's a 4 x 4 matrix which has the parity property:

  Function that displays the following message to the user

Your program must check for input validity. It must display an appropriate error message and terminate if the three inputs for date (day, month, and year) do not form a valid date.

  Create an annotated bibliography

For the course project, you will create an annotated bibliography of five sources that cites and describes four of the best Internet resources on a specified topic and one of the best library database resources.

  Write a method that will perform the a division operation

Write a method that will perform the a division operation (divide by) on the numbers passed to it in two variables (numerator, denominator) and outputs the results.

  List and describe the options available for the location

List and describe the options available for the location of the information security functions within the organization. Discuss the advantages and disadvantages of each option.

  Rudimentary form of protection

How does the distinction between kernel mode and usermode function as a rudimentary form of protection (security) system?

  Design a tick tac toe game

Design a Tick Tac Toe Game. You must use Arrays to represent the board You may use Pointers

  Mini case: k-mart

Mini Case: K-Mart

  What values if any are stored in x y z

Suppose you are given the following variable declarations: int x, y; double z; char ch; Assume you have the following input statement

  Car sale data and try to apply there learning skills

Choose any topic of your interest and create a power point presentation, you should utilize all features were taken in all finished class works. The slide show should present your work in at least twenty slides using different animation techniques..

  Positive integer number from user and outputs

Write a program that takes a positive integer number from user and outputs the number in the range from 1 to whatever user has entered with maximum sum of its divisors. The maximum sum of divisors should be outputted as well.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd