What stage of water watch would you put ellis in

Assignment Help Database Management System
Reference no: EM13752358

Background: This is REAL data. Ellis, KS is currently listed in a Stage 3 Water Emergency. Some argue that this is not reflective of the actual situation. The population of Ellis has remained approximately constant from 2004-2014. The water level in the wells is based upon the level of ground water located in the ground. The graphic provides data on the wells currently in operation (1,2,4,5,7,11,12,13). The wells are measured from the top of the well to the current water level. The measurement recorded is the ‘empty' space in the well. The corresponding % is the percent ‘full' of each well. The total height is a measurement from the bottom of the well to the top. The 3 stages are based upon the average level of all the wells.

Questions:

1. What is the current average percentage of water the wells hold? Assuming the wells actually could not ever be completely full (without the town being flooded), what numbers should be used as the maximum? Using these numbers, what is the current average percentage of water the wells hold?

2. How long will it be until each well is dry, based on the trends from 2007 to 2014? 2004 to 2014? Which should be used? Will Ellis ever run out of water?

3. How much total water was available in the wells in 2004? In 2014? Should this make a difference in deciding the stage?

4. What stage of water watch would you put Ellis in?

Reference no: EM13752358

Questions Cloud

Describing the managements role in the technology : Write a 350-700 word summary describing the management's role in the technology selected and the benefits of it that support the organization's quality initiatives
Exchange commission edgar database : Select a publicly traded corporation for which you would like to work or are currently working. Research the corporation on its own Website, the public filings on the Securities and Exchange Commission EDGAR database and any other sources you can ..
Case study on phase separations solutions : Entrepreneurial firm, PS2, has been presented with two opportunities to significantly expand their business in China. Paul Antle, President and CEO of PS2, has come to you asking for your advice regarding these opportunities.
Write a paper on impact of the black death : Write a paper on Impact of the Black Death.
What stage of water watch would you put ellis in : This is REAL data. Ellis, KS is currently listed in a Stage 3 Water Emergency. Some argue that this is not reflective of the actual situation. What stage of water watch would you put Ellis in
What are the most challenging aspects of this decision : What are the most challenging aspects of this decision. What are the implications of your decision that you are most concerned about.
Alternative courses of action : The process of evaluating financial data that change under alternative courses of action is called:
Which tests had the most and least conversion improvements : A/B and multivariate testing is an important part of determining what helps to drive conversions on a Web site. Which tests had the most and least conversion improvements
Write an essay on navajo culture : Write an essay on Navajo Culture.

Reviews

Write a Review

Database Management System Questions & Answers

  What are the major business objectives

What are the major business objectives and processes that the airline company carries out and list the information systems and subsystems that are used to support their portal and describe how they are related to the overall business objectives and..

  Create a database to control its local libraries

A county wishes to create a database to control its local libraries. Each library has a number of employees, one of whom is designated as the manager of the library and is responsible for supervising employees and the general day-to-day management..

  Create data warehouse for electronics store chain

Create a data warehouse for electronics store chain. Chain has 20 stores in 5 cities. Each store has different sections comprising computers, DVDs, TVs, audio, home appliances etc.

  Write sql statements to calculate average salary

Write SQL statements that do the following: Calculate the average salary for all employees. Calculate the maximum salaries for exempt and non-exempt employees.

  Develop preliminary database tables for huffman trucking log

Use Microsoft Access to develop preliminary (no keys and no relationships) database tables for Huffman Trucking Driver Log.

  Database to keeps track of students in university

University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes.

  Produce budget reports for department at university

Consider system which produces budget reports for department at university. For whichever system you select, answer the following design questions. Who will use output?

  Convert excel files into an access database

The Morris Arboretum tracks donors to their organization in Microsoft Excel. Access for future Arboretum records. In the following project, you convert Excel files into an Access database for Morris Arboretum

  Explain relational database design and implementation

ISYS 224 Database Systems - Relational Database Design & Implementation

  Create a database using oracle packaged procedure

Create a database using Oracle packaged procedure

  Online registration application

Imagine an online registration application. Use your registration form as starting point for your analysis. Identify the entities that a potential database will need, along with their attributes.

  Sort ascending by consultant id and date opened

Sort ascending by consultant ID and Date Opened. Don't show tickets with category ID of 0. HINT: You will require to use SELECT query with an alias in builder for the column.

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!

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