Computer Programming and Analysis DBS301 Lecture 6: DBS301 - Lab6

319 views4 pages

crimsonshark113

17 Nov 2015

School

Seneca College

Department

Computer Programming and Analysis

Course

Computer Programming and Analysis DBS301

Professor

Tanvir Alam

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Lab 6: display last name and job title for all employees who perform the same job as. 3 where last_name != "davies" and job_id = (select job_id. St_clerk: display last name, job title and hire date for all employees hired after grant. Sort the output by the most recent hire date. Mourgos: display city, province name and postal code for all departments located in countries that start with letter i (meaning italy, israel and india). If the province is blank, show message unknown and the heading should be province. 1 select city, nvl(state_province, "unknown") as province, postal_code. Province postal_code: display last name, job title and salary for all employees who earn less than the. Sort the output by top salaries first and then by job title. 2 where salary < (select avg(salary) from employees. 2500: display last name, job title and salary for all employees whose salary matches any of the salaries from the it department.

Related Questions

36. (2 points) Write a method that takes three integer parameters, startX, y, boxSize, and draws a row of adjacent squares, boxSize pixels on each side, with the upper left corner of the first square at startX, y. The row should extend all the way to the right edge of the display. The method needs to work for any values of the parameters. As an example the image to the right is the result of this sketch, assuming the sketch also includes your method definition. For different values, the last square could extend off of the display but there should be no space between the last square and the right edge. void setup() { partialRow (30, 50, 10);

You have been contracted by a popular fitness club to create a Java Program that
will help in the input, calculation, display of calories burnt and pounds lost during a week of
workout for members of the club.
The program will also base on the amount of weight lost update the weight of the user and
calculate and display the users BMI – body mass index using any researched method. See an
example here- http://www.whathealth.com/bmi/formula.html
The club takes part in 5 major types of activities, namely walking, running, swimming, hiking,
and bicycling.
The program is to prompt for the Name of the member, gender, weight in pounds, height and
the time spend on each activity during the week in minutes.
The program will then calculate the calories burnt per activity, the total calorie burnt for the
week and the amount of weight lost during the week.
The amount of weight loss will be used to update the weight that was stored in the array and
calculate the person BMI . http://www.whathealth.com/bmi/formula.html
Activity Calorie Burnt Per pound per minute for
men (women are 1/6 less)
Walking .036
Running .095
Swimming .058
Hiking .058
Bicycling .044
 Calories burned per pound per minute (Bicycling – .044) x (times) your exact weight
(140 pounds) = (equals) total calories burned per minute (6.16 calories burned per
minute) x(times)minutes of activity (30 minutes) = (equals) 184.80 total calories
burned per activity.
 Women burn 1/6 less calories than Men.
 3500 calories = 1 pound of weight loss.
Author: Dexter Chin-Yan
Write a program that would do the following:
 Print a suitable heading and prompt for the required information
 Calculate the necessary required information and store in an Array(s)
o After members names, gender, weight in pounds and time spent in each
activity has been entered (10 Members) The program should calculate the
total calories burnt Total Calorie Burnt for the week and the amount of
weight loss (depending on whether it is a man or a woman.
o Calculate and display BMI and weight status based on the table above.
General Guidelines:
 Make use of appropriate messages to make you program as informative and user
friendly as possible, without being unnecessarily complex.
 Keep user interactions simple and instructions clear
 Use adequate documentation and proper indentation to clarify your program code
where necessary and improve layout
 Pay attention to good structure and use of programming constructs.
Evaluation
 Documentation and layout (spacing, indentation and commenting) 10 marks
 Proper layout of interface for input, output of information 10 marks
 Use of method to calculate, BMI, calories burnt per activity, and weight loss.
20 marks
 Creation and use of arrays to hold and processed information 20 marks
 Working program (Correctness, efficiency, user interaction)

dove

Write a program called Lab 5 that has 3 methods and a main method:
1) Method isUserNameValid has 1 parameter of type string and the method returns a value of type
boolean. If the parameter has less than 8 characters then the method returns false, otherwise it
returns true.
2) Method compare has 3 parameters all of type int and has a String return type. This method will
return
a. “All Same” if all 3 parameters are equal,
b. “All Different” if all 3 parameters are different.
c. “Mix number(s)” two of the numbers are the same and the 3rd is different.
3) Method isValid has 1 parameter of type int and returns a boolean value; the method returns true if
the parameter is in the range 0,…,100 inclusive, otherwise the method returns false.
4) Main method. I want you to test methods isValid & isUsernameValid one time with a valid data
and another time with an invalid data. As for method compare test it 3 times so you can get the 3
different possible outcomes.
Example to test the isUserNameValid method

skyrat848

Computer Programming and Analysis DBS301 Lecture 6: DBS301 - Lab6

Document Summary

Get access

Related Documents

Computer Programming and Analysis DBS301 Lecture Notes - Seneca College

Computer Programming and Analysis DBS301 Lecture 1: DBS301 - Lab1

Computer Programming and Analysis APC100 Lecture Notes - Lecture 3: Oracle Database, Sql*Plus

Related Questions