Your Problems Essay

Submitted By Nick-sem
Words: 2290
Pages: 10
Open Document
Respond here if you have gotten the invite. This is where you will do put your problems or if you have questions or problems for the coding.

Plan going forward from today, Wed. 11/19: ● Work on remaining SQLs: #24 … checked against
NONAPPLIANCE
Table at #22.
Queries for numbers 23­28 are created but still need to be incorporated into the
NONAPPLIANCE
Table at #22, then checked for accuracy by running the VIEW command at #28..
● Work on Part I ­ Look below Part II, for postings for Part I. See if any commonalities in two posted models. We need to agree on a 1NF mapping. This will probably be most difficult part since we are unable to discuss in person. Happy Thanksgiving! IMPORTANT DATES:
Friday 6pm, 11/28 ­ Online meeting, HERE, to discuss remainder of project; what’s left to do, issues… USE CHAT (or SKYPE?) TO COMMUNICATE. Sunday 6pm, 11 /30 ­ Target Date for completion Part I and Part II. Wednesday, Dec. 3rd by 11:00pm
Deliverables due in Dropbox, Part I ­ ERD diagram and script to create our MS­Patient­Data­Worksheet Database. (Note: we do not need to submit our (PPT) presentation to dropbox.) Part II ­ All SQL queries.
Group Project Part I and II Submitted Wednesday 12/3 Chat meeting here 6pm, Sunday 12/7 Sunday 12/7 ­ Chat meeting here 6pm

Wednesday, Dec. 10th ­ In class Presentation Final Exam End of semester ­ WaaHoo!!! Bill

Friday Nov. 28th As of 3:30pm, Friday Nov. 28th, all queries/statements in Part II have been checked and verified at least once. Bill

POST A QUESTION or ANSWER ONE, BELOW HERE

Thanks Jake!

**Prob 1 – List all rows and columns for the complete ORDERS table SELECT *
FROM Orders **Prob 2 – List the order number for each order placed by customer number 148 on
10/20/2007

SELECT order_num
FROM Orders
WHERE orders.order_date = (select DATE('2007­10­20')) and customer_num = 148 **Prob 3 – List the part number and part description of each part that is not in item class SG SELECT part_num, description
FROM part p
WHERE p.class not in('SG') **Prob 4 – List the part number, part description, and on­hand value (units on hand * unit price) of each part in item class AP. Assign the Name on_hand_value to the computation SELECT part_num, description, (p.on_hand * price) as on_hand_value

FROM Part p
WHERE p.class in ('AP') **Prob 5 – Use the IN operator to list the part number and part description of each part in item class AP or SG. SELECT part_num, description
FROM Part p
WHERE p.class in ('AP', 'SG') **Prob 6 – List all details about all parts. Order the output by part description. SELECT *
FROM Part
ORDER BY description **Prob 7 – How many customers balances that are more than their credit limits? SELECT COUNT( customer_num) as Number_Customers
FROM Customer
WHERE balance > credit_limit **Prob 8 – List the part number, part description, and on­hand quantity of each part whose number of units on hand is more than average number of units on hand for all parts. select part_num, description, sum(on_hand) on_hand from part where on_hand > (select avg(on_hand) from part) group by part_num; **Prob 9 What is the part number, description, and price of the most expensive part in the database? select part_num, description, max(price) price from part 10. List the sum of the balances of all customers for each sales rep, but restrict the output to those sales reps for which the sum is more than $10,000.

select rep_num, sum(balance) total_customer_balance from customer c group by rep_num having Total_Customer_Balance > 10000

11. List the part number of any part with an unknown description. select part_num from part where description is null 12. For each order placed on October 21, 2007, list the order number along with the number and name of the customer that placed the
Show More

Related Documents: Your Problems Essay

China’s Renminbi: “Our Currency, Your Problem” Essay

China’s Renminbi: “Our Currency, Your Problem” Our Currency, Your Problem is a case involving the issue of exchange rate regimes and the impact currency manipulation has on economies and trade. The United States and Europe argued that the Renminbi (RMB) was undervalued and claimed that the People’s Bank of China (PBoC) deliberately manipulated the exchange rate to lower the prices of exports, which caused the US and Europe to run huge trade deficits with China. The US and…

Words 887 - Pages 4

Summary Hows To Motivate Your Problem P Essay examples

Article Summary: “How to Motivate Your Problem People” Lisa Marvel EDD 7200 – Supervisory Behavior Wilmington University October 11, 2010 Article Summary: “How to Motivate Your Problem People” In his article, “How to Motivate Your Problem People” (2003), Nigel Nicholson offers readers strategies to energize employees who don’t appear to be motivated. Nicholson starts by saying that, “good managers motivate with the power of their vision, the passion of their delivery, and the compelling…

Words 446 - Pages 2

What Would Be Your Solution to This Social Problem If You Had the Chance to Do Something Essay

human being has the great need that is very essential to obtain these fundamental basic needs of their parents and thus to achieve a healthy maturation in the area of development. If an discrepancy in certain stages of growth, the person affected your process will look at certain levels of behavior, manifesting itself in the course of his life for the lack of affection from their parents. The affective role of the family assumes a great importance on emotional development in the early stages…

Words 1544 - Pages 7

Essay about Do You Think That Resistance from Employees Is Likely to Be the Biggest Problem for a Business That Wants to Reinvent Itself? Justify Your Answer with Reference to Samsung Electronics and or/Other Organisations That You Know.

products will become obsolete within ten years.” This corporate strategy of reinvention would inevitably involve significant change for employees. Do you think that resistance from employees is likely to be the biggest problem for a business that wants to reinvent itself? Justify your answer with reference to Samsung Electronics and or/other organisations that you know. A corporate strategy is a plan based on the corporate aims and objectives which defines the overall scope and direction of the…

Words 896 - Pages 4

Essay on Group Advocacy Presentation

you know you have in common with your group members is that you are all college students at UC Irvine. With your group members, identify a problem that you have encountered at UCI—or, if you are not familiar enough with problems specific to this campus, some more general problem that college students face today. The problem can be something “small,” like a service or facility on campus, the core/required curriculum, the 39 series, or it can be general problems with K-12 education (do you feel that…

Words 335 - Pages 2

Nt1310 Unit 5 Exercise 1

Problem 1. First, check if your power is on in the house. Second, check if your wires are plugged in and are in the right spots. Lastly, go on google and try to see if anyone has your problem. Problem 2. First, check if your power is on. Second, check if your Wi-Fi box is working and is plugged in the right place. Third, check if your device Wi-Fi is turned on or off (In setting). Problem 3. First, check if your phone has power by charging the phone and waiting. Second, check if your phone loading…

Words 424 - Pages 2

Overcrowding Essay

UNSW Future Problem Solving Program Team Answer Booklet Topic MEGACITIES______________ Team Name A+ Plus___________________ Tutorial Group ___BA1___________________ Date _15 /_06_ /_2014 Declaration: This work submitted for evaluation complies with UNSW Foundation Year Program Rules of Assessment. We acknowledge that this task requires evidence of effective team work and accordingly agree to accept the team mark for this task as a component of our individual assessment mark…

Words 1238 - Pages 5

Research: Study Design and Literature Review Essays

to iLearn your ideas for your Research Topic, Question, Relevant Disciplines, Methodology (initial ideas for conducting your study—review Walliman, Ch 6-8 for ideas), Tangible Outcome (what will you do with your information—Master’s Thesis, workshop, presentation, program, lesson plan, exhibit, film, mural, book. . . ) March 14: Class work on refining topics, research problems, questions, study designs/methodologies, tangible outcomes. Read Walliman Chs 3-8, and bring your revised research…

Words 646 - Pages 3

outline for case study 2 Essay example

concise for your own understanding as well as for the understanding of the other students and the instructor.) II. Major Problem (State here the major problem as you see it. Emphasize the present major problem. You may wish to phrase your statement in the form of a question. In a few cases, there may be more than one major problem. A good problem statement will be concise, usually only one sentence.) III. Possible Solutions A. (List here the possible solutions to the major problem. Let your…

Words 967 - Pages 4

Duke Ellington Case Study

¨A problem is a chance to do your best.¨ Life is full of many challenges that have to be faced, and whether small or large, each and every one of them influences your life for better or for worse. In a sense, everything that people do is in order to solve a problem. For example humans eat in order to solve the problem of hunger, they work in order to buy food, and they go to school in order to be educated enough to work. In each of these cases, the cause of the action is to solve a problem. A problem…

Words 563 - Pages 3