53. The hase phenomenon has hit Malaysia in June 2013. Schools, the government and the provate sectors, have all been badly hit by closures or their employees who get in medical leave. The quality of air is measured using the Air Pollutant Index (API) reading and status for a particular district. The corresponding status for the API reading is given in TABLE below: API Status 0-50 Good 51-100 Moderate 101-200 Unhealthy 201-300 Very unhealthy More than 300 Hazardous Mr Jamil Awang, the managing director of Sulaiman & Ahmad Co., a company located in Port Klang, Selangor, has directed you to update and provide him woth the maximum API reading and status. You are given the 24 hourly API readings of Port Klang for 24 hours in one day. Write a complete JAVA program to identify the maximum API reading and its corresponding status for one day.

53. The hase phenomenon has hit Malaysia in June 2013. Schools, the government and the provate sectors, have all been badly hit by closures or their employees who get in medical leave. The quality of air is measured using the Air Pollutant Index (API) reading and status for a particular district. The corresponding status for the API reading is given in TABLE below: API Status 0-50 Good 51-100 Moderate 101-200 Unhealthy 201-300 Very unhealthy More than 300 Hazardous Mr Jamil Awang, the managing director of Sulaiman & Ahmad Co., a company located in Port Klang, Selangor, has directed you to update and provide him woth the maximum API reading and status. You are given the 24 hourly API readings of Port Klang for 24 hours in one day. Write a complete JAVA program to identify the maximum API reading and its corresponding status for one day.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter6: Updating Data

Section: Chapter Questions

Problem 4SCG

See similar textbooks

Similar questions

The following table shows the student grades for Q1 and Q2 assessment activities. Calculate the mean and mode for Q1 and Q2 grades Calculate the range and standard deviation for Q1 grades and Q2 grades Student Number Q1 Grade Q2 Grade Total student Grade 1 85 79 164 2 96 85 181 3 84 76 160 4 75 76 151 5 64 94 158 6 83 83 166 7 92 92 184 8 74 71 145 9 67 81 148 10 81 93 174 11 93 72 165
3. You are asked to calculate the weekly take home pay for a group of employees at your company. The employees in this group have a wage rate of 35USD per hour and 65USD per hour when they work overtime. The following table list the hours work by the employees. Employee ID Regular hours Overtime hours 87 40 3 43 40 8 99 32 0 5 40 15
An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel Н4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. i. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.
One hundred students were asked whether they had taken courses in any of the three subjects, Mathematics, Computer Science and Information Technology. The results were given below. 45 had taken Mathematics; 18 had taken Mathematics and Computer Science; 38 had taken Computer Science; 21 had taken Information Technology; 9 had taken Mathematics and Information Technology.; 4 had taken Computer Science and Information Technology and 23 had taken no courses in any of the subjects. Draw a Venn diagram that will show the results of the survey.
4) You are asked to calculate the weekly take home pay for a group of employees at your company (for each Employee ID). The employees in this group have a wage rate of 35 ÚSD per hour and 65 USD per hour when they work overtime. The following table list the hours work by the employees. Employee ID Regular hours Overtime hours 87 40 3 43 40 8. 99 32 40 15
An university has decided to grant loans for the students. For this the financial administrator has to check with the number of students apply for loan with "Manage Loan and Grants" view. Student can enroll themself and apply for loan. Financial administrator will check whether the students has cleared the tuition fees up to last year, if the student is applying loan for current year tuition fee and enrollment was done for courses like seminars, etc. Professor will be allotted for the course once students got enrolled for subject. The actors involved in the system are student, scheduler, financial administrator and professor. The packages that are linked in the system are manage loan and grants, manage fees, manage seminars, enrollment. Identify the dependencies between one element and the other by drawing a package diagram for
The following data give the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade-point average (GPA), and major (business or other) are provided. SALARY $29,500 $46,000 $39,800 $36,500 GPA 3.1 3.5 3.8 2.9 Major Other Business Business Other SALARY $42,000 $31,500 $36,200 GPA 3.4 2.1 2.5 Major Business Other Business Using a computer, develop a regression model that could be used to predict a starting salary based on GPA and major. Use this model to predict the starting salary for a business major with a GPA of 3.0. What does the model say about the starting salary for a business major compared to a non-business major? Do you believe this model is useful in predicting the starting salary? Justify your answer, using the information provided in the computer output.
For short listing of the candidates for a job in a company in different sections based on the cumulative percentage of the following fields. • I f cumulative percentage is more than 80% then hire in HR department. • If cumulative percentage is less than 80% and greater than 70% then hire in accounts department. • If cumulative percentage is less than 70% and greater than 60% then hire in sales department. • f cumulative percentage is less than 60% and greater than 50% then hire in helping staff. The cumulative percentage will be calculated as 60% of the marks obtained in test conducted by the company and 40% of obtained marks in interview. Total marks for the test and interview is 200 each. Write a computer program to construct a function with name "Selection to calculate the cumulative percentage and then display the message in which section the candidate is selected.
Use the 20 year Global Warming Potential (GWP) values in the first Table to calculate an equivalent CO2 emission rate for worldwide greenhouse gas emissions as given in the second table. Assume that total CFCs are divided equally among the three compounds listed. What is the percentage contribution of actual CO2 emissions to the total equivalent CO2? What is the next most important greenhouse gas emission based on this analysis? How do these results compare to those using the 100-year GWP.
Calculate BEP for the following information. Year o Year 1 Year 2 Year 3 Total benefit 0 49561 61635 70565 Total cost 80848 11671 12472 14009 Enter BEP (Round the value to 2 decimal point. Ex: 2.09, 3.50, 4.65 etc)
Determine where you want to reside if you want to live in an earthquake-prone area using the earthquake hazard map.
In 2020, alumni collectively donated $11.37 billion to their colleges and universities, according to an annual report from the nonprofit Council for Aid to Education. That is an increase of 14.5 percent from the prior year, which the report attributes, at least in part, to a strong stock market. Some colleges and universities have a particularly high percentage of former students who make financial contributions. In that period, the 10 institutions with the highest percentages of undergraduate alumni donors boasted an average giving rate of 51.5 percent. Alumni donor count is used to calculate alumni participation by dividing it by the number of living alumni on record. For example, if your institution has 100,000 alumni of record (i.e., living with a good address) and 20,000 of them made a gift last year, your alumni participation rate is 20%. The importance of alumni participation cannot be understated; for example, U.S. News & World Report’s Best Colleges, the most prominent…