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

  Discuss developing a mechanism within http for doing this

Discuss developing a mechanism within HTTP for doing this.

  Determine if the given subset is a subspace

Determine if the given subset is a subspace of the given vector space. Prove your claim - Is the set P of all polynomials of the form p(x) = a+x2, with a ? R, a subspace of P2?

  Question regarding the internet starting a business

Imagine you are planning to start your own business. What type of business would you start, and what type of ownership would you prefer? How would you fund this business? Dream big for this assignment. Think of a business you would like to start i..

  Write a program that reads from the external file

write a program that reads from the external file input.txt, counts the letters in every word , replaces the word by that number and then writes the numbers to an external file output.txt

  How could a business use information technology

How could a business use information technology to increase switching costs and lock in its customers and suppliers? Use business examples to support your answers

  Express the angle with respect to the tangential velocity

Express the angle with respect to the tangential velocity vector (ie, +90° points radially out). (Points : 5) A) 10.9 m/s2 at -75° B) 10.9 m/s2 at +75° C) 37.9 m/s2 at -75° D) 37.9 m/s2 at +75°

  The five essential elements of an enforceable contract

Critical Analysis Paper. Give an example of a contract that you or someone you know entered into (for example, rental agreement, cell phone agreement, property purchase or lease-car, home, furniture, etc.

  What does the tree look like after these operations

What does the tree look like after these operations execute if the tree is

  Write the code segment needed to set the data variable

Write the code segment needed to set the data variable to 25, and the tag string to "Hello World".

  Find out the number of candidate keys

Find out the number of candidate keys

  Create a world with at least four objects

A popular topic in Physics is the study of rotational motion. Create a world with at least four objects (such as a compass, mailbox, mantle Clock, and tire).

  Layers in the protected mode work together

Describe how the layers in the protected mode work together? How memory space is allocated to a user process? How does the file system NTFS works and how it recovers after a system failure?

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