Computer Programming and Analysis DBS301 Lecture Notes - Lecture 8: Savepoint

175 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

Add two rows to table my_employee as following by using. Insert statement without column names (dunn will have no salary for now). Add third and fourth row as following, where both scott and rita will lcheng ddunn opopov. Into my_employee values (126, "popov", "olga", "opopov", 8500) Into my_employee values (127, "chen", "ling", "lcheng", 14500) Into my_employee values (128, "dunn", "david", "ddunn", "") Populate your table my_employee by inserting rows from table. Employees under condition that only programmers are inserted i. e people who have prog in their job title. It is up to you to determine which syntax option will achieve this task. Assume that column userid may be populated with the same generic value called generic" (for all employees who do not have user_id assigned yet). Verify what is stored in your table my_employee and undo your transaction. You will change last name and salary for employee gomez (who. 3. was without pay) to become jones with earning of .

Related Questions

I. [10 marks For each row in the table below, determine what would happen if you opened DrScheme and tried to evaluate the given code. If there is an error, brielly explain what is wrong (be more specific than saying "invalid Scheme expression"). If there is no error, give the value produced by DrScheme. The first two rows have been completed for you as examples. Answer Scheme Code (+ 12) (+ 1 2)) (7 + 12) Error. There is an extra) (+ 4 (* 1 (+ 4 2))) ( 1 ((reraircer 27 9) (sqr 5))) (/ 10 (-3 (-14))) (= 'apple 'banana) (and (< 3 4) 19 10)) (- 12 (string-length. "iya")) (reso rest (rest (rest (cors'a (cons 3 (cons 5 empty))))))) (cond [(> 3 8) "happy! [(-34) 'sad) [(even? 9) 'oops] ) (posn-X (first (rest (coris (make-posn 3 4) (cons (make-posr. 56) empty)))))

Question 8. [6 MARKS] Consider this code: def sort_guesses (guess_list, answer): (list of float, float) -> dict of (str: list of float) Return a new dictionary where each item in guess_list appears as an item in one of the dictionary's values lists: - each item less than answer is in a list associated with key 'low', - each item equal to answer is in a list associated with key 'correct', and - each item greater than answer is in a list associated with key 'high'. If there are no items associated with one of 'low', 'correct', or 'high', then that string should not appear as a key in the new dictionary. In the table below, we have outlined two test cases for sort_guesses. Add six more test cases chosen to test the function thoroughly. R eturn Value Test Case Description no guesses one low guess guess_list answer [ 5.5 [4.7] 6.0 {'low': [4.7]}

5. Consider the following class: import java.util.Scanner; public class Money private int dollars; private int cents; public Money (int d, int c) { dollars = d; cents = c; /* Point 1 */ public String toString() { String result; if (cents > 100) int totalCents = dollars * 100 + cents; dollars = totalCents / 100; cents = total Cents % 100; /* Point 2 */ /* Point 3 */ result = "$" + dollars + ", " + cents + "C"; return result; public static void main(String[] yourGrandfather) Scanner keyboard - new Scanner (System.in); Money amount; int C; /* Point 4 */ System.out.print("Enter an amount in cents: "); C = keyboard.nextInt (); amount = new Money (c/ 100, CX 100); System.out.println("You have: " + amount.toString()); The above program compiles and runs without error. Which variables are in scope at each of the points marked by comments in the above class? In other words, if each of these comments were replaced by an actual Java statement, which variables could be used in this statement without a prefix (that is, without having to write the name of a class or other variable in front of the variable name) and without the compiler reporting an unknown variable error? List each variable that is in scope at each of the points marked by comments in the above class, and indicate whether it is an instance variable, a formal parameter, or a local variable. Note that you will be penalized for every variable that is out of scope at a given point but that you list as being in scope at that point.

Computer Programming and Analysis DBS301 Lecture Notes - Lecture 8: Savepoint

Document Summary

Get access

Related Documents

SMS221 Lecture Notes - Lecture 5: Pivot Table, Summary Statistics, Dialog Box

COMP 228 Lecture Notes - Lecture 8: Dialog Box, Tab Key, Table Table

MIS 325 Lecture Notes - Lecture 13: Result Set

Related Questions