Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

The problem requires the use of parallel arrays, methods, reading the data from the file and the use of proper formatting techniques. This is a java program.

You have been asked to write an analysis of the Mice population by town in New Jersey. The
accompanying file contains data about each town. The format of the file is the name of the town, square miles and the number
of Mice counted. You will need to produce the report as follow:

Township Square Mice Mice Per Mice/Flea Flea Threat
Name Miles Population Square Mile Coefficient Indicator

Green Town 158.98 9865 62.05 0.39 ORANGE

The Mice/Flea coefficient is calculated by dividing the number (Mice per square mile)/Square miles.


The higher the coefficient the denser the Mice population and the greater the threat of Flea
infestation to humans. The
Flea threat is indicated by a color to indicate the danger to human for diseases such as Murine
typhus disease as follows:

Flea Threat Threat Indicator

Less than equal to 0.35 RED
Greater Than 0.35 and less than or equal to 0.50 ORANGE
Greater Than 0.50 or less than or equal to 0.65 YELLOW
Greater Than 0.65 or less than or equal to 0.75 GREEN
Greater Than 0.75 BLUE

You will create program to offer the user the ability to produce the report as show about in
alphabetical order by township name or in size order by township square mile. The program will also
allow the user to send the report to the screen, to a file or to both. You program must also allow
the user to type in the name of the township to look up the above data for the selected township.

An example of menu may be:

New Jersey Health Services

1 - Mice Report by Town
2 - Mice Report by Town Size
3 - Town Look up
0 - Exit

Your program must use parallel arrays or an array of objects to process the data. Do not use the <Array> class.

[画像:Below is a transcribed list of data for different locations. Each entry includes three columns: the name of the location, an unspecified numeric value, and another numeric value that may represent a count or measurement. This data could be relevant for educational purposes such as geographical analysis, demographic studies, or statistical evaluation. ``` City of Red 70.81 2137 Boro of Orange 101.77 71 Yellow City 83.13 1034 Green Town 54.79 1819 Blueville 45.71 1514 Indigo Village 4.15 1442 Violeton 119.27 2225 Redburg 7.46 977 Orange Park 16.72 133 Yellow Falls 94.5 4556 Green Haven 326.12 1105242 Blue City 44.69 1979 Indigo Township 113.56 365 Violet Point 35.27 4161 ``` ##### Notes to Educators: - **City of Red:** The first number (70.81) could represent some metric such as area in square miles or a population density, while the second number (2137) could denote population count or another statistical measure. - **Boro of Orange:** Shows a high first value (101.77) but a relatively low second number (71). - **Yellow City:** Has a moderate first value (83.13) and a mid-range second number (1034). Each row can be interpreted to reveal interesting insights about these locations. For example, Green Haven stands out with the highest second number (1105242), potentially indicating a significantly higher population or some other large-scale measure. Educators can further expand this basic data with more context about what these numbers specifically represent.]
expand button
Transcribed Image Text:Below is a transcribed list of data for different locations. Each entry includes three columns: the name of the location, an unspecified numeric value, and another numeric value that may represent a count or measurement. This data could be relevant for educational purposes such as geographical analysis, demographic studies, or statistical evaluation. ``` City of Red 70.81 2137 Boro of Orange 101.77 71 Yellow City 83.13 1034 Green Town 54.79 1819 Blueville 45.71 1514 Indigo Village 4.15 1442 Violeton 119.27 2225 Redburg 7.46 977 Orange Park 16.72 133 Yellow Falls 94.5 4556 Green Haven 326.12 1105242 Blue City 44.69 1979 Indigo Township 113.56 365 Violet Point 35.27 4161 ``` ##### Notes to Educators: - **City of Red:** The first number (70.81) could represent some metric such as area in square miles or a population density, while the second number (2137) could denote population count or another statistical measure. - **Boro of Orange:** Shows a high first value (101.77) but a relatively low second number (71). - **Yellow City:** Has a moderate first value (83.13) and a mid-range second number (1034). Each row can be interpreted to reveal interesting insights about these locations. For example, Green Haven stands out with the highest second number (1105242), potentially indicating a significantly higher population or some other large-scale measure. Educators can further expand this basic data with more context about what these numbers specifically represent.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
    Recommended textbooks for you
    Text book image
    Database System Concepts
    Computer Science
    ISBN:9780078022159
    Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
    Publisher:McGraw-Hill Education
    Text book image
    Starting Out with Python (4th Edition)
    Computer Science
    ISBN:9780134444321
    Author:Tony Gaddis
    Publisher:PEARSON
    Text book image
    Digital Fundamentals (11th Edition)
    Computer Science
    ISBN:9780132737968
    Author:Thomas L. Floyd
    Publisher:PEARSON
    Text book image
    C How to Program (8th Edition)
    Computer Science
    ISBN:9780133976892
    Author:Paul J. Deitel, Harvey Deitel
    Publisher:PEARSON
    Text book image
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781337627900
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Text book image
    Programmable Logic Controllers
    Computer Science
    ISBN:9780073373843
    Author:Frank D. Petruzella
    Publisher:McGraw-Hill Education