Your Problems Essay

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

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.

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…

Related Documents: Your Problems Essay

Question: Does your race form your identity?
Race does form the identity of a person. It really does matter whether you are Negro, white or any other race. During the late 1900s the race that really matter were the Negros. If you were a Negro (not necessarily looking like one) you were automatically considered bad. Being a Negro did not just mean that you had colored skin, and a slang accent when you talk, on the contrary you could look completely white and have no slang accent in the way you…

The Wheel is Yours to Turn
Andrew Monroe
"No." - Rosa Parks.
A simple quote, a single word, spoken by a single woman, helped spark a revolution that caught ablaze throughout an entire country and revolutionized how an entire people group is viewed and treated to this very day. This one act of defiance radically changed an entire country's perspective and allowed individuality, a new ability for the African-American population to express and live like never before. And I believe that…

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…

Color Test - Results
Your Existing Situation
Desires to be respected by others in order to gain their trust and support for her own personal gain.
Your Stress Sources
"Demands to be noticed by others as an important individual, needs attention and recognition. her current situation is leaving her dissatisfied. she feels she needs to make friends with those who hold the same high standards she does. Wants to stand out as someone at the top of her class and be admired by others. she needs to feel…

Problems Solved are Problems Caused.
Every night before dinner, my mother or grandmother would begin a conversation with me with the question "nong che gu la va?" Which rough translate as “have you eaten?" What you would observe if you were a fly on the wall, was the beginning of a ritual to pass to another generation the dialect known as Shanghainese. All conversation within the house was spoken in Shanghainese. For comparison, in Mandarin the question would be asked "ni fan chi guo le ma?"…

Change Your Business By Changing Your Words
By John Gerstner
Complex, verbose, self-obsessed, jargon-rich language is an insidious pandemic in the world of corporate communications. But should we accept it as a given, or wage a silent war?
Cisco Systems chose the latter, and shared their battles and victories in the Communitelligence webinar, Change Your Business By Changing Your Words by Mark Buchanan, program lead for brand language at Cisco. In this Q & A, Mark talks about the why and how…

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 business by identifying its choice of business, markets and activities. For an organisation facing such problems where reinvention may have to occur, deep consideration…

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…

Words 887 - Pages 4

* Test names and other trademarks are the property of the respective trademark holders. None of the trademark holders are affiliated with this website.