Premium Essay

Assignment 2

In: Computers and Technology

Submitted By Greybourne
Words 349
Pages 2
2.20 Write an SQL statement to display unique WarehouseIDs.
SELECT DISTINCT WarehouseID
FROM INVENTORY;

2.29 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and
QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Do not use the BETWEEN keyword.

SELECT SKU, SKU_Description, WarehouseID,
QuantityOnHand
FROM INVENTORY
WHERE
QuantityOnHand > 1
AND
QuantityOnhand < 10;

2.31 Write an SQL statement to show a unique SKU and SKU_Description for all products having an SKU description starting with ‘Half-dome’.

SELECT DISTINCT SKU, SKU_Description
FROM INVENTORY
WHERE SKU_Description
LIKE
'Half-dome%';

2.33 Write an SQL statement to show a unique SKU and SKU_Description for all products having a ‘d’ in the third position from the left in SKU_Description.

SELECT DISTINCT SKU, SKU_Description
FROM INVENTORY
WHERE SKU_Description
LIKE
'__d%';

2.36 Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order of TotalItemsOnHand.

SELECT WarehouseID, SUM(QuantityOnHand) AS
TotalItemsOnHand
FROM INVENTORY
GROUP BY WarehouseID
ORDER BY SUM (QuantityOnHand) DESC;

2.42 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, Ware- houseCity, and WarehouseState of all items not stored in the Atlanta, Bangor, or
Chicago warehouse. Do not use the NOT IN keyword.

SELECT
SKU, SKU_Description, INVENTORY.WarehouseID
FROM
INVENTORY, WAREHOUSE
WHERE
INVENTORY.WarehouseID=WAREHOUSE.WarehouseID
AND
WarehouseCity Except ('Atlanta','Bangor','Chicago');

2.44 Write an SQL statement to produce a single column called ItemLocation that com- bines the SKU_Description, the phrase “is in a warehouse in”, and WarehouseCity. Do not be...

Similar Documents

Premium Essay

Student

...COMP101 – Problem Solving with Computing Homework - WEEK 2 [30 points] This is a review of some of the material from Chapter 2 and lectures from class. No credit for answers that are copies or near verbatim transcripts – please use your own words1 and document sources where appropriate. 1 This will apply to all assignments in this class. Answer the following questions: Chapter 2 1. Short Answers [1 point each, 2 points total] 1. What does a professional programmer usually do first to gain an understanding of a problem? The first thing that a professional programmer usually do first to gain an understanding of a program is to closely relate customer (Interview ) to inquire or gather information about the problem. 2. What two things must you normally specify in a variable declaration? The two things normally specified in a variable declaration are the variable type and identifier. 2. Algorithms / Pseudocode [1 point each, 5 points total] 1. Design an algorithm that prompts the user to enter his or her height and stores the user’s input in a variable named height. Declare height Display “Enter Your Height” Input Height Display “Height” 2. Write assignment statements that perform the following operations with the variables a and b. - Adds 2 to a and stores the result in b. - Subtracts 8 from b and stores the result in a Set b=2+a Set a=b-8 3. Write a pseudocode statement that declares the variable cost so it can hold real......

Words: 1823 - Pages: 8

Premium Essay

Week 2 Assigment

...Week 2 Assignment: Understanding Effective Money Management Assessment A, Part 1: Creating a Personal Financial Statement - Assets | 1 point | Car: Bluebook value $1250.00Cash: $378.00Savings Accounts: $826.00 | Assessment A, Part 2: Creating a Personal Financial Statement - Debts | 1 point | Rent: $750.00Electric/ Gas bill: $131.75Cable/ internet/ Phone bill: $80.42Credit Card: $31.00Cell phone bill: $72.37 | Assessment A, Part 3: Identify Money Management Tool | 1 point | Explain to Monica how the money management tools were identified. | Students should explain how they evaluated various cash management products and services. | Assessment A, Part 4: Creating a Personal Financial Statement – Steps | 1 point | Drag the steps listed on the right into their correct sequences on the left. When done click the Send button | Step 1: I got all my financial stuff together – bills, loans, bank statements, etc. | Step 2: I balance my checkbook. | Step 3: I decided what were my assets and what were my debts. | Step 4: I enter my assets in the program. | Step 5: I enter my debts in the program. | Step 6: The program gave me a Net worth figure at the end. | Assessment B: Creating a Monthly Cash Flow Statement ...

Words: 255 - Pages: 2

Premium Essay

Andy Owes Bill a Debt.

...Law Written Assignment 3 Case Study 1 Parks, a 7-foot, 265-pound center for the San Diego Slick, objected when his contract was assigned from the ABC Corporation to the XYZ Corporation, the team’s new owner. The change of owners did not cause a change in the composition of the team although a new coach was hired. Parks’s compensation and his responsibilities remained the same. Was this contract assignable? Facts of the Case: 1) Parks contract was assigned from the ABC Corporation to XYZ Corporation. 2) Parks compensation and his responsibilities remained the same. Issues: 1) The reason why we are in court today is to identify if Park’s contract was assignable. Rules of the Law: 1) Personal Service Contract – The parties agree that a personal service contract may be assigned. This allows the trade of an athlete from one team to another team. 2) Notice of Assignment – Assignee is under a duty to notify the obligor that the assignment has been made and performance must be rendered to the assignee. 3) Anti-Assignment Clause – Prohibits the assignment of rights under the contract. 4) Approval Clause – requires that the obligor approves any assignment of contract. Analysis & Conclusion: Since we do not have all the facts we can assume the following: 1) Parks contract did include the Personal service contract. 2) Notice of assignment was made by XYZ Corporation. 3) Parks contract did NOT include Anti-Assignment......

Words: 495 - Pages: 2

Free Essay

Study Habits

...STUDY HABITS OF SECOND YEAR BS-AVTECH STUDENTS OF PATTS COLLEGE OF AERONAUTICS S.Y 2013-2014 An Undergraduate Research Presented to The Languages Department of PATTS College of Aeronautics In Partial Fulfillment of the Requirements for the course ENGL 211 – Technical Report Writing By Guevarra, Giorgio Martin C Guevarra, Lorenzo Miguel Jang, Jose, Yosalina, Leo Xander March 2014 ACKNOWLEDGEMENT The researcher would like to express our thanks to the lord. Our God for his guidance towards everything we do In life, including this study that we had made, and for being an inspiration for us all to do our best in life. We give our thanks to Ms. Karen M. Millano, our adviser for ENGL 211, for carefully and patiently guiding us so that we may finish the thesis research, and for supporting us and believing in us, that we can accomplish our task finishing the thesis. To the respondents of this study, we express our gratitude because without them, this thesis research would not have been completed, we thank them for allowing us to conduct a survey during their spare time, and their patience and integrity in answering the survey. To our parents, for their support and everlasting patience and understanding for us. And lastly to our classmates, since they have been with us since the beginning of the semester and they had been our companions in everything we do for the subject ENGL 211. ABSTRACT STUDY HABITS OF...

Words: 413 - Pages: 2

Free Essay

Engeenering

...SCHOOL OF ENGINEERING YEAR 3 MECHATRONICS ASSIGNMENT LAB REPORT Reading an Analogue Voltage from a Potentiometer to turn a Motor on and off with reading of 40 Assignment 2 Owais Jahanzeb BENG Mechanical Engineering with buissness Lecturer: Dr. Tom Shenton Aim & Objectives The aim of this lab is to develop a functioning program for the PICDEM board to read an analogue signal from a potentiometer and turning a motor on or off if the signal exceeds a certain limit. The program should depict the function that it should turn the motor ON and OFF if the potentiometer reading is less than or equal to 40. The practical uses of such program can be seen in automotive , injection moulding machines, wood processing machines, modern temperature controlled plants, speed control torque operations. Developing Program 1 Figure 1. The schematic circuit & PICDEM board configuration for Program Figure 1. The schematic circuit & PICDEM board configuration for Program The objective of program is to read the correspondent voltage analogous to the potentiometer position and switch the motor on if the reading is over 40 and switch it off if the reading is less than or equal to 40, the value can be adjusted by twisting the screw clockwise and anticlockwise. The program works by implementing the following code. PIC program for Test of potentiometer with value less equal to 40 with comments: include <p16f917.inc> extern DisplayDigit1,......

Words: 427 - Pages: 2

Free Essay

Management Accounting

...Management Accounting Individual Assignment 1. Variable manufacturing cost per unit = (323,000,000-160,000,000-24,000,000-100,000,000) 850,000 = $45.88 per unit Fixed manufacturing cost per unit = $100,000,000 850,000units = $117.65 per unit Total manufacturing cost per unit= 45.88+117.65 = $163.53per unit 2. Fixed overhead rate= $100,000,000 800,000units =$125 per unit Production volume variance= (850,000 X 125)-(800,000 X 125) =$106,250,000-$100,000,000 = $6,250,000 Favourable 3. Absorption costing. | $ | $ | SalesLess: Cost of goods soldOpening inventoryProduction(850,000 X (255+125))(-)Ending inventory(30,000 X 405)Gross MarginAdjustments for production variance(850,000-800,000)x125Operating Income | 0323,000,000(11,400,000) | 450,000,000(311,600,000) | | | | | | 138,400,0006,250,000F | | | 144,650,000 | Income Statement for the year ended 31December 2012 4. Variable Costing Income Statement for the year ended 31 December 2012 | $ | $ | SalesOpening inventoryProduction(850,000 X 255)(-)Ending inventoryContribution MarginFixed factory overheadOperating income | 0216,750,000(7650,000) | 450,000,000(209,100,000) | | | 240,900,000(100,000,000) | | | 140,900, 000 | 5. Based on the calculations of absorption costing and variable costing for the year 2012,it would be better to calculate and measure using the absorption......

Words: 288 - Pages: 2

Premium Essay

Sfds

...ASSIGNMENT - 3 Answers 1 Answer 2 Answer 3 4. For what types of workloads does SJF deliver the same turnaround times as FIFO? ANSWER: - In the above case if the jobs are same in size or the jobs periodically applied (i.e. first shortest job then later second shortest job and continues) then the turnaround time of SJF is same as FIFO. 5. For what types of workloads and quantum lengths does SJF deliver the same response times as RR? ANSWER: - The response time delivered by SJF is equal to the response time of RR but this happens only when all the jobs arrived are at the point when the planning quantum of RR is bigger than the bigger occupation to be administrations in order of increasing size. 6. What happens to response time with SJF as job lengths increase? Can you use the simulator to demonstrate the trend? ANSWER: - If you suppose the length of the job increases then average response time varies (increases).If every job is sorted in increasing job order than the last job response time will be equal to the sum of current job and previous (n-1) jobs. In this way if the size of the job increases the response time will also increases for all larger jobs. 7. What happens to response time with RR as quantum lengths increase? Can you write an equation that gives the worst-case response time, given N jobs? ANSWER: - In the case of RR, the response time increases as the quantum lengths increases. This happens because the waiting time of a process for its turn......

Words: 286 - Pages: 2

Free Essay

Misconceptions of Algebra

...problems in the following way: 5 × 4 + 3 = ? 5 × 4 = 20 + 3 = 23 Students may also have difficulty understanding statements like 7 = 3 + 4 or 5 = 5, since these do not involve a problem on the left and an answer on the right. Falkner presented the following problem to 6th grade classes: 8 + 4 = [] + 5 All 145 students gave the answer of 12 or 17. It can be assumed that students got 12 since 8 + 4 = 12. The 17 may be from those who continued the problem: 12 + 5 = 17. Students with this misconception may also have difficulty with the idea that adding or subtracting the same amount from both sides of an equation maintains equality. Kieran gives this example: Solve for x: 2x + 3 = 5 + x 2x + 3 – 3 = 5 + x 2x = 5 + x – x – 3 2x – x = 5 – 3 x = 2 The answer is correct, but several steps of the solution contain incorrect equations. In summary, a student with this misconception will: Assume the solution to a problem is the number after the...

Words: 797 - Pages: 4

Free Essay

Prg/211 Calorie Count Tool

...Team B Calorie Count Tool PRG/211 May 5, 2014 Team B Calorie Count Tool PROBLEM STATEMENT Team B was asked to develop a program which would calculate the user’s daily intake of calories and measure those calories against the overall calories expended. The core purpose of this program will do two primary functions. First, it will record the user intake of calories as acquired through meals throughout the day. Second, the user will record caloric output associated with physical activity. This information will be calculated together to determine the caloric surplus or deficit for the user. In order for the program to execute accurately, and provide customized results, the user will be required to input personal data to include gender, age, weight, and height. This additional information is essential to determine the user’s default caloric burn rate, otherwise known as the basal metabolic rate (BMR). The BMR and the calories burned as a result of physical activity will be calculated against the intake of calories to determine the overall success for the user. As the program is executed it must: * Record user name, age, height, weight to enable more accurate calculations * Record the users specific caloric values entered for each meal * Record the user activity and caloric burn values for that activity * Calculate the basal metabolic rate (BMR) for the individual * Subtotal the total caloric values for the day * Combine the physical activity......

Words: 1524 - Pages: 7

Free Essay

Mobile Service Provider

...11108944 Name: ASHWINI KUMAR Roll No. : RE3R02B32 PART- A 1. Ans :- (a) unary and ternary operator Unary operator:- It pecedes an operand . The operand (the value on which the operator operates ) of the unary operator must have arithmetic or pointer type and the result is the value of the argument. Example:- If a=5 then +a means 5 If a=0 then +a means 0. If a=-4 then +a means -4. Ternary operator:- It precedes an operand. The operand of the unary operator must have arithmetic type and the result is the negation of the operand’s value. Example:- If a=5 then –a means -5 If a=0 then –a means 0 If a=-4 then –a means 4. (b) Assignment and equalto operator Assignment operator:- Equal to operator: An assignment operator assigns value In this we put the To a variable. value as it is. Example – Example- a*=5 means a=5*5. Int a; a=5 means a is initialized with 5 if(a==5) { return true; } return false; (c) Expression and statement Expression:- An expression is any valid combination of operators , constants , and......

Words: 399 - Pages: 2

Free Essay

Book Report

...Selection statements Selection is used to select which statements are to be performed next based on a condition being true or false. Relational expressions In the solution of many problems, different actions must be taken depending on the value of the data. The if statement in C I used to implement such s decision structure in its simplest form – that of selecting a statement to be executed only if a condition is satisfied. Syntax: if(condtion) statement executed if condition is true When an executing program encounters the if statement, the condition is evaluated to determine its numerical value, which is then interpreted as either true or false. If the condition evaluates to any non-0 value (positive or negative), the condition is considered as a “true” condition and the statement following the if is executed; otherwise this statement is not executed. Relational Operators In C Relational operator | Meaning | Example | < | Less than | age < 30 | > | Greater than | height > 6.2 | <= | Less than or equal to | taxable <= 200000 | >= | Greater than or equal to | temp >= 98.6 | == | Equal to | grade == 100 | != | Not equal to | number !=250 | In creating relational expressions, the relational operators must be typed exactly as given in the above table. Thus, although the following relational expressions are all valid: age > 40 length <= 50 temp >= 98.6 3 < 4 flag == done day != 5 The following are invalid: length =< 50 ...

Words: 1617 - Pages: 7

Free Essay

Pay for Eprformance

...Pre course assignment 2: Performance Related Pay The assignment is to write a paper about Performance Related Pay (2000 words) Performance Related Pay is receiving a great deal of attention. On the one hand (collective) labour agreements are increasingly including arrangements that relate to pay-forperformance, at the same time there is also strong resistance. Trade unions have never been enthusiastic proponents subject to certain conditions, but opinions are also divided in employers' circles. Pay-for-performance is even named as a root cause for the crisis of the financial sector and for the collapse of some companies. A number of companies have recently announced that they will abolish or change their pay- for-performance systems. When organizations have performance related pay systems in place, (front line) managers usually play an important role. They make pay decisions, or provide information for these decisions. The paper is also a preparation for a class debate about pay for performance in the fourth lecture. The debate will be about the statement: “The introduction of individual pay for performance contributes to an improvement in a company's (financial) performance” The paper will be written from one of three starting points: 1. You are against the statement: all arguments you discuss should underpin that the statement is false 2. You are in favour of the statement: all arguments you bring forward should underpin that the statements is true 3. You are undecided:......

Words: 453 - Pages: 2

Free Essay

Assignment of Income Doctrine

...ACC 616 Prof. Robert Simpson Student name: On the back Assignment 1: Explain Assignment of Income Doctrine The "assignment of income" doctrine states that income is taxed to the one who actually earns it. That means a taxpayer cannot avoid tax liability by assigning his income to another party or entity. Therefore, to be able to shift income to someone else, that one must actually earn the income. This doctrine aims to against the tax evasion when the taxpayer tries to deflect income to another party. First, starting from the term “earning”, earnings can occur either through the direct efforts of the taxpayer or the taxpayer’s ownership of an asset that generates income. Based on that understanding about earning, there are 2 ways to shifting income from one to another: the transferee must really work to earn that income or share the ownership of an asset that creates income. For example, if you are an owner of a business and you want to shift one part of your income to your family member such as your son, you need to hire your son to work for your company and give him the pay rate that is appropriate with his job. And the other way is to share your investment income with him, same meaning with sharing your ownership with him. The assignment of income applies the “tree and fruit” metaphor, in which the fruits cannot be attributed to a different tree from that on which they grew. If you want to avoid the tax liability on the fruit from the tree, you must prove that......

Words: 421 - Pages: 2

Free Essay

English

...Introduction to Programming with C# Variable Types & Initialising Variables Introduction to Variables A variable is a storage location that holds a value. You can think of a variable as a box in the computer’s memory holding temporary information. You must give each variable in a program an unambiguous name that uniquely identifies it in the context in which it is used. You use a variable’s name to refer to the value it holds. For example, if you want to store the value of the cost of an item in a store, you might create a variable simply called cost and store the item’s cost in this variable. Later on, if you refer to the cost variable, the value retrieved will be the item’s cost that you stored there earlier. Working with Primitive Data Types C# has a number of built-in types called primitive data types. The following table lists the most commonly used primitive data types in C# and the range of values that you can store in each. |Type |Description |Size (in bits) |Range | |int |Whole numbers |32 |-2147483648 to 2147483647 | |long |Whole numbers (larger range than int |64 |-9223372036854775808 to 9223372036854775807 | | |data type) | | | |float ...

Words: 714 - Pages: 3

Free Essay

Nothing

...Ariana Corney Aesa McComb Mina Haw Son Writing assignment #2 When g (0) it is zero because the slope is at zero When it is g (10) it is positive because of the area being colored on the graph. The area under the x-axis is negative, so when you add all of the areas it becomes positive. That brings us to the derivative of g (x), to help us find all of the x-values, which is equal to f(x). Same with the derivative of g (a), it equals f (a), but f (a) is equal to 0. The x values are 2,4,6,8, and 10 when f (0) is equal to f (2), f (4), f (6), f (8), f (10). We determined the increasing/decreasing intervals would be increasing at points where x equals (0,2), (4,6), (8,10) while that g would be decreasing on points where x equals (2,4) and (6,8). As far as finding the extreme values we found that the maximum occurs at when x equals 2, 6, and 10. The minimum occurs at when x equals 0, 4, and 8, while the absolute extreme values are where x equals 2. We determined that g was concaving up when x equals (0,1), (3,5), and (7,9) because the slope of those are increasing throughout the graph. We also determined that g is concaving down when x equals (1,3), (5,7), (9,10) because the slope of those are decreasing down throughout the graph. When the derivative of h is 9, h(x) =g (√x) is equal to f(3)=-2. H(x)= g(√x) so when we need to find the derivative of h(x), we also need to find the derivative of g(√x).The derivative of h(9) then equals the derivative of g(√9) which equals 3.......

Words: 352 - Pages: 2