Free Essay

Business World

In:

Submitted By 4Cused82
Words 1090
Pages 5
1. List part #, description, and Price for all Parts SELECT Part_num, Description, Price FROM Part; Output: Part_num Description Price AT94 Iron 24.95 BV06 Home Gym 794.95 CD52 Microwave Oven 165.00 DL71 Cordless Drill 129.95 DR93 Gas Range 495.00 DW11 Washer 399.99 FD21 Stand Mixer 159.95 KL62 Dryer 349.95 KV29 Treadmill 1390.00 2. List all rows & columns for the Orders table SELECT * FROM Orders; Output: ORDER_NUM ORDER_DATE CUSTOMER_NUM 21608 2007-10-20 148
21610 2007-10-20 356
21613 2007-10-21 408
21614 2007-10-21 282
21617 2007-10-23 608
21619 2007-10-23 148
21623 2007-10-23 608 3. List the name of clusters with credit limit =< $7500 SELECT Customer_name FROM Customer WHERE Credit_limit <=7500; Output: Customer_name Al's Appliance and Sport Ferguson's The Everything Shop Lee's Sport and Appliance Deerfield's Four Seasons All Season 4. List order number for each order by customer number 148 on 10/20/07. SELECT Order_num FROM Orders WHERE Customer_num =148 AND 2007 -10 -20; Output: Order_num 21608 5. List the number and customer name represented by rep 35 or 65 SELECT Customer_name, Customer_num FROM Customer WHERE Rep_num = '35' OR Rep_num = '65'; Output: Customer_name Customer_num Brooking's Direct 282 Ferguson's 356 The Everything Shop 408 Bargain's Galore 462 Johnson's Dept. Store 608 Lee's Sport and Appliance 687 Deerfield's Four Seasons 725 6. List part number and description of each part that is not in class SG. SELECT Part_num, Description FROM Part WHERE class <> 'SG'; Output: Part_num Description AT94 Iron CD52 Microwave Oven DL71 Cordless Drill DR93 Gas Range DW11 Washer FD21 Stand Mixer KL62 Dryer 7. List part number, description, and # of units on hand for each part that has between 10-25 units, include both 10 and 25. Do this two ways. SELECT Part_num, Description, On_hand FROM Part WHERE ( On_hand >=10) AND ( On_hand <=25); Output: Part_num Description On_hand DL71 Cordless Drill 21 DW11 Washer 12 FD21 Stand Mixer 22 KL62 Dryer 12

8. List part number, description, and on-hand value (units on hand*price) of each part in item class AP. (On-hand value is really units on hand times cost, but there is no cost.) Assign the name On_Hand_Value in computation. SELECT Part_num, Description, ( On_hand * Price ) AS On_hand_value FROM Part WHERE class = 'AP'; Output: Part_num Description On_hand_value CD52 Microwave Oven 5280.00
DR93 Gas Range 3960.00
DW11 Washer 4799.88
KL62 Dryer 4199.40
KT03 Dishwasher 4760.00 9. List part number, description, and on-hand value for each part at least $7500. Assign the name On_Hand_Value to that column. SELECT PART_NUM, DESCRIPTION, (ON_HAND * PRICE) AS
ON_HAND_VALUE
FROM PART WHERE (ON_HAND * PRICE) >= 7500; Output: Part_num Description On_hand_value BV06 Home Gym 35772.75
KV29 Treadmill 12510.00 10. Use the In operator to list the Part number and description of each part in item class AP or SG. SELECT Part_num, Description FROM Part WHERE Class IN ( 'AP', 'SG' ); Output: Part_num Description BV06 Home Gym CD52 Microwave Oven DR93 Gas Range DW11 Washer KL62 Dryer KV29 Treadmill 11. Find the number and name of each customer whose name begins with the letter 'K'. SELECT Customer_name FROM Customer WHERE Customer_name LIKE 'K%'; Output: Customer_name Kline's 12. List all details about all parts. Order the output by part description. SELECT * FROM Part ORDER BY Description; Output: PART_NUM DESCRIPTION ON_HAND CLASS WAREHOUSE PRICE DL71 Cordless Drill 21 HW 3 129.95 KL62 Dryer 12 AP 1 349.95 DR93 Gas Range 8 AP 2 495.00 BV06 Home Gym 45 SG Z 794.95 AT94 Iron 50 HW 3 24.95 CD52 Microwave Oven 32 AP 1 165.00 FD21 Stand Mixer 22 HW 3 159.95 KV29 Treadmill 9 SG 2 1390.00 DW11 Washer 12 AP 3 399.99 13. List all details about all parts. Order the output by part # within item class. (That is, order the output by item class and then by part number.) SELECT * FROM Part ORDER BY Class, Part_num; Output: PART_NUM DESCRIPTION ON_HAND CLASS WAREHOUSE PRICE CD52 Microwave Oven 32 AP 1 165.00 DR93 Gas Range 8 AP 2 495.00 DW11 Washer 12 AP 3 399.99 KL62 Dryer 12 AP 1 349.95 AT94 Iron 50 HW 3 24.95 DL71 Cordless Drill 21 HW 3 129.95 FD21 Stand Mixer 22 HW 3 159.95 BV06 Home Gym 45 SG Z 794.95 KV29 Treadmill 9 SG 2 1390.00 14. How many customer have balances that are more than their credit limits? SELECT count (*) FROM Customer WHERE Balance > Credit_limit; Output: Count (*) 2 15. Find the total of the balance for all customers represented by sales rep 65 with balance that are less than their credit limits. SELECT count (*), sum (Balance) FROM Customer WHERE Balance < Credit_limit AND Rep_num = '65'; Output: Count (*) sum (Balance) 3 11303.00 16. List the part #, part description, and on-hand value of each part whose number of units on hand is more than the average number of units on hand for all parts. (Hint: Use a subquery.) SELECT PART_NUM, DESCRIPTION,(ON_HAND * PRICE) AS
ON_HAND_VALUE
FROM PART WHERE ON_HAND > (SELECT AVG (ON_HAND)
FROM PART); Output: PART_NUM Description ON_HAND_VALUE AT94 Iron 1247.50
BV06 Home Gym 35772.75
CD52 Microwave Oven 5280.00
FD21 Stand Mixer 3518.90 17. What is the price of the most expensive part in the database? SELECT max (Price) FROM Part; Output: Max (Price) 1390.00 18. What is the part number, description, and price of the most expensive part in the database? (Hint: Use a subquery.) SELECT Part_num, Description FROM Part WHERE Price = ( SELECT max (Price) FROM Part ); Output: Part_num Description KV29 Treadmill 19. List the sum of the balance of all customers for each sales rep. Order and group the results by sales rep number. SELECT Rep_num, sum (Balance) FROM Customer GROUP BY Rep_num ORDER BY Rep_num; Output: Rep_num sum (Balance) 20 27533.00 35 8815.50 65 11303.00 20. List the sum of the balance of all customers for each sales rep but restrict the output those sales reps for which the sum is > $10k. SELECT REP_NUM, SUM(BALANCE)
FROM CUSTOMER
GROUP BY REP_NUM
HAVING SUM(BALANCE) > 10000
ORDER BY REP_NUM; Output: Rep_num SUM(Balance) 20 27533.00 65 11303.00 21. List the part number of any part with an unknown description. MySQL returned an empty result set (I.e. zero rows). (Query took 0.0004 sec) SELECT Part_num FROM Part WHERE Description IS NULL;

Similar Documents

Premium Essay

Business It World

...Date: 04-19-2015 The New Frontier: Data Analytics (Course title: Info System Decision Making) Professor: Clifton Howell Student: Deep Ajabani Data analysis is the process of finding the right data to answer your question, understanding the processes underlying the data, discovering the important patterns in the data, and then communicating your results to have the biggest possible impact. Analytics have been used in business since the management exercises were put into place by Frederick Winslow Taylor in the late 19th century. Henry Ford measured the time of each component in his newly established assembly line. But analytics began to command more attention in the late 1960s when computers were used in decision support systems. Since then, analytics have changed and formed with the development of enterprise resource planning (ERP) systems, data warehouses, and a large number of other software tools and processes. In later years the business analytics have exploded with the introduction to computers. This change has brought analytics to a whole new level and has made the possibilities endless. As far as analytics has come in history, and what the current field of analytics is today many people would never think that analytics started in the early 1900s with Mr. Ford. We are going to have a look on Big Data Analytics. Let’s have a look on advantages of big data analytics. It helps marketing companies build models based on historical data to predict...

Words: 1537 - Pages: 7

Premium Essay

Vinny Parascandola's Role In The Business World

...In the world of business, it takes a special type of person to negotiate business deals and become successful. Moreover, the business world remains an extremely competitive environment. To expound further, 75% of businesses fail within the first five years of being open. Aside from the statistic being staggering, it also remains the sad reality for today's business professionals. Moreover, most business professionals lack the drive and ambition of Vinny Parascandola. For those unaware, Vinny Parascandola remains a prominent figure in the world of business. To expound further, Vinny Parascandola remains the Senior Executive Vice President of AXA Advisors, LLC. With that being said, Viny Parascandola possesses numerous responsibilities within...

Words: 356 - Pages: 2

Premium Essay

Business Ethics Across the World

...Business Ethics across the World Have you ever measured that how different countries become closer to one another and it has produced alike views for countries that do business together due to globalization? Through the growth of globalization several ethical issues are getting exposure according to management teams. You can imagine if ethic is dilemma within the country then how about the issues that occur due to foreign language, diverse cultures and number of people involved grows to a global scale. This paper will identify ethical perspectives of two countries, India and China, and how these two articles contribute to understanding global ethics. It will also explain how china’s and India’s business ethics compare to the United States. In journal of business ethics (2009), article “A Chinese perspective: Business Ethics in China Now and in the Future”, describes that China has been at the forefront of growing concern, not only about its products and enterprises, but also about its business ethics. This article analyzes the state of ethics in business in China. China now manufactures or assembles over 50% of the world’s products. However, the world has been reeling from daily accounts of defective “Made in China” products. China has been at the forefront of growing concern, not only about its products and enterprises, but also about its business ethics. This article analyzes recent events connected with the Made in China label from the perspective of evolving Chinese business...

Words: 1122 - Pages: 5

Premium Essay

Getting Tough For The World Of Business Essay

...Tough for the World of Business Undoubtedly, the world of business is highly competitive, and with countless of careers within the field, it may be difficult for some individuals to stand out. Though one is certainly capable of advancing with a normal curriculum or program, the advantage one would receive through an opportunity like the UIC Business Scholars program would make transitioning into the vast business path a lot smoother. Knowing how rigorous business, especially international business, can be, I would love to have the opportunity to learn the ways around the field. The ability to receive close guidance from professionals and knowledgeable faculty is a great aid in familiarizing one’s self with the many obstacles waiting in the real world. In view of the support an undergraduate would obtain by being a part of this development program, one could say the student is likely to progress faster than others taking the same career path, but that are not in the program. Believing the UIC Business Scholars program would be the best way for me to start my journey to prevail in business, I...

Words: 500 - Pages: 2

Free Essay

Exposing My Small Business to the World

...Abstract In this paper I will cover the various elements, policies and procedures to taking a business online. Inside this paper I will conduct a SWOT analysis, show how I plan to overcome any cultural barrier that may be presented and how I maintain compliance with our stringent federal trade laws. Exposing My Small Business to the World The possibilities for expanding and increasing your business in today’s times are endless. The World Wide Web allows us small business owners opportunities that we have never had before with these increased opportunities, there are also increased problems. I will outline how I took my business online and combatted these underlying issues. Identify the advantages and disadvantages of taking your small business online by performing a SWOT analysis. Include 2-4 items in each category. The New Jersey shore boardwalk is a tourist haven. A small business owner can make a considerable profit if they have a product that the consumers want at a price they love. My clothing store NEW Images opened last year. In this failing economy it was often discouraging to sit in the store for days at a time with only a few sales and many “window shoppers”. I decided quickly that if I want to survive I must take this business online. The thought of exposing my business to millions of new customers was euphoric. I could literally taste the profits. I put my plan into effect by first taking note of the advantages. The first advantage was the cost...

Words: 1146 - Pages: 5

Free Essay

World Bank Report - Business Transparency

...2012 Doing business in a more transparent world C O M PA R I N G R E G U L AT I O N F O R D O M E S T I C F I R M S I N 1 8 3 E C O N O M I E S © 2012 The International Bank for Reconstruction and Development / The World Bank 1818 H Street NW Washington, DC 20433 Telephone 202-473-1000 Internet www.worldbank.org All rights reserved. 1 2 3 4 08 07 06 05 A copublication of The World Bank and the International Finance Corporation. This volume is a product of the staff of the World Bank Group. The findings, interpretations and conclusions expressed in this volume do not necessarily reflect the views of the Executive Directors of The World Bank or the governments they represent. The World Bank does not guarantee the accuracy of the data included in this work. Rights and Permissions The material in this publication is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law. The World Bank encourages dissemination of its work and will normally grant permission to reproduce portions of the work promptly. For permission to photocopy or reprint any part of this work, please send a request with complete information to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, USA; telephone: 978-750-8400; fax: 978-750-4470; Internet: www.copyright.com. All other queries on rights and licenses, including subsidiary rights, should be addressed to the Office of the Publisher, The World Bank, 1818 H...

Words: 173471 - Pages: 694

Premium Essay

Privacy and Security at the Digital Age: the Innovation of Business in the Online World

...innovation of Business in the online world Over the past decade the world has solely relied upon technology and its transformation throughout the years allowing for the revolution of social media to completely change how everyone communicates especially for businesses, allowing them to extend out and provide large opportunities for themselves. According to ISACA (2010), through the use of social media, it allows businesses to gain serious advantages through research and evaluation of their competition, their consumers, and the market. This enables them to not only help develop them to be on top of their issues, but using it as a tool for enhancing a better relational experience with employees and customers. For businesses to be successful with their organisations or products, social media is the key to their communication with their stakeholders through privacy and security, where it strongly impacts business to improve, but can be considered also to be a big risk where that barrier can be invaded, which can cause legal and ethical issues. Privacy and security are known to be the most important issues surrounding social media and the innovation of businesses today. Although it may be argued that users voluntarily sign away their privacy by using these social media when creating accounts and putting their personal data online, it is not clear how consent actually works in these situations (Custers et al. 2014). But overall privacy is a serious issue in the online world, businesses...

Words: 1757 - Pages: 8

Premium Essay

How International Business Has Afftected the Busines World

...How International Expansion has affected the Business world today International Business Abstract The business world as we know it today has changed from the business world that existed when our parents were growing up. Many business leaders and companies are beginning to expand their business internationally or globally. The advances in technology, and with the use of internet, television shows and politics we see the mention of globalization everywhere. What in fact is globalization, and how has it affected the business world today? When it comes to doing business internationally or globally, there are many different factors that one must take into consideration such as language and culture barriers, negotiation of contracts and various laws concerning issues such as intellectual property rights. With all of these various factors why are companies still looking to expand internationally? How do business and companies survive with all the laws and other forces they have to contend with? This paper will discuss globalization, what it is, and what effect it has had on the business world today. It will also discuss how to overcome language and culture barriers, the various laws business owners and managers need to be aware of and how to negotiate a legal contract. Finally this paper will discuss my own ideas of marketing a professional organization business internationally, and how it would benefit the international market, along with my personal view of international expansion...

Words: 2124 - Pages: 9

Premium Essay

Business World

...Indesit, founded in 1975, is an Italian multinational company that produces domestic product to export all over the world. Unfortunately, between 2012 and 2013 it faced a significant downfall related, initially, to one of it’s products, the Indesit washing machine WIXL143 and later on the more expensive W1X E167 model. Several costumers complained about the malfunctioning and the unexpected explosion of the models. One customer explained: “During the spin cycle it appeared that the drum had split open and moved the concrete balancing block inside the machine up pushing it’s top upwards”. Looking at this situation from a lawyer’s perspective the consumer is protected, under the 1979 Soga Act, or in other words the Sale Of Goods act that establishes the rights and duties of the seller and buyer and their remedies in the event of a breach. The Act is defined as “a contract by which the seller transfers or agrees to transfer the property in goods to the buyer for a money consideration called the price”. It is also important to take into consideration that land and money are not included in the definition of goods. Even in the case that no physical contract for the sale of goods has been written, this Act automatically includes a number of conditions and warranties that in law are called ‘implied terms’. There are four main implied conditions, or major terms which are vital to the main purpose of the contract: -Title (s 12) involving the seller and its right to sell the goods...

Words: 1088 - Pages: 5

Free Essay

World Risks That Could Impact Business

...threat to the world. (Risks include: Retreat from globalization, WMD proliferation, Instability in the MiddleEast, Oil supply uncertainty) Of all the political risks covered, the Iraq/Middle East threat has the greatest likelihood of triggering the other major threats. Thus, the worsening of the Iraq/Middle East situation poses the gravest threat to the growth and stability of the world economy. If the situation in Iraq further deteriorates, the threat of sectarian violence spreading in the region increases and instability results. By this threat alone, this is a serious risk. However, the chain of events it could trigger is more significant. *Increasing incentives to join terrorism The conflict in Iraq and the Middle East, where civilian lives were lost and impoverished makes it easier for terrorist groups to attract new recruits. Destruction of lives and property, as well as the resulting chaos could popularize anti-US/Western sentiment. Also, joining terrorist groups could also be an escape from the difficulty of surviving in the ongoing chaos. The threat of this new wave of terrorist activities could result in a more unsecure world, where asymmetric warfare could break out in different regions. *Worsening oil supply uncertainty As the Middle East region accounts for more than half of the world’s oil reserves, with Saudi Arabia alone accounting for 25%, the effect of an unstable Middle East directly leads to a more uncertain oil supply for the world. Over the...

Words: 1324 - Pages: 6

Premium Essay

World for Business

...Factors affecting on stock price 1. Introduction The stock market has become an essential market playing a vital role in economic prosperity that fostering capital formation and sustaining economic growth. Stock markets are more than a place to trade securities; they operate as a facilitator between savers and users of capital by means of pooling of funds, sharing risk, and transferring wealth. Stock markets are essential for economic growth as they insure the flow of resources to the most productive investment opportunities. In essence, a large number of economic variables like gross domestic product, interest rates, current account, monthly supply, employment, their information etc. have an impact on daily stock prices (Kurihara, 2006). This paper reflects how stock price is determined by considering the effect of different factors and outlines whether the internal, external and economic factors have impact on stock pricing. This study is about to know whether Dividends, paid up capital, market capital, corporate social responsibility, lawsuits, Retained Earnings, AGM, EGM, Earning Per Share, Rumors, Margin Loan, Net Income, Face Value, Return on Investment, Goodwill of the firm, Company News, Analysts Report, Sentiment, Rumors, etc. depends on stock price or merely some special factors like stock dividend, P/E ratio, government policy, macroeconomics fundamental, investors sentiment...

Words: 4571 - Pages: 19

Free Essay

The Business World

...WASHINGTON — The need for revenue to partly cover the extension of the payroll tax cut and long-term unemployment benefits has pushed Congress to embrace a generational shift in the country’s media landscape: the auction of public airwaves now used for television broadcasts to create more wireless Internet systems. If a compromise bill completed Thursday by Congress is approved as expected by this weekend, the result will eventually be faster connections for smartphones, iPads and other data-hungry mobile devices. Their explosive popularity has overwhelmed the ability, particularly in big cities, for systems to quickly download maps, video games and movies. The measure would be a rare instance of the government compensating private companies with the proceeds from an auction of public property — broadcast licenses — once given free. The auctions, which are projected to raise more than $25 billion, would also further the Obama administration’s broadband expansion plans and create a nationwide communications network for emergency workers that would allow police, fire and other responders from different departments and jurisdictions to talk to each other directly. Public safety officials have wanted such a seamless communications system ever since the 9/11 terrorist attacks. The sweeping changes are even more remarkable because they resulted not from an effort to address communications policy, but from a hard-fought bipartisan compromise to extend a payroll tax holiday...

Words: 726 - Pages: 3

Free Essay

Business World

...Answer: Stony corals are a remarkable group of animals that inhabit tropical marine waters around the world and form vast colonies known as coral reefs. Coral reefs often resemble rock formations or even plants but such resemblances are only superficial. Coral reefs are in fact made up of many tiny animals known as coral polyps. Each coral polyp is an individual animal and the individual polyps coexist as part of a larger colony of polyps. Coral reefs provide habitat for an immense diversity of other organisms including fishes, marine mammals, marine turtles, and invertebrates. Stony corals inhabit marine habitats where the water is quite clear, the temperature remains within the range of 18°C-29°C, and the salinity of the water is in the range of 32ppt-42ppt. A stony coral colony begins as a single free-swimming founder coral polyp that attaches itself to a hard substrate such as submerged rocks. The founder polyp replicates itself repeatedly through asexual reproduction, producing a colony. The colony consists of a base which is attached to the reef substrate, a growing edge zone (where new coral polyps are produced), and an upper surface that is exposed to light that filters down through the water. Stony corals are so named because of the stone-like skeleton that forms within their bodies. This hard skeleton is made up of calcium carbonate (CaCO3) and is the substance that gives a coral reef much of its structure. Over time, stony coral polyps lift up from their base...

Words: 280 - Pages: 2

Premium Essay

Business World

...Materials 2014, 7, 5746-5760; doi:10.3390/ma7085746 OPEN ACCESS materials ISSN 1996-1944 www.mdpi.com/journal/materials Article A Corrosion Sensor for Monitoring the Early-Stage Environmental Corrosion of A36 Carbon Steel Dong Chen 1,*, Max Yen 1, Paul Lin 1, Steve Groff 1, Richard Lampo 2, Michael McInerney 2 and Jeffrey Ryan 2 1 2 College of Engineering, Technology, and Computer Science, Indiana University-Purdue University, 2101 E Coliseum Blvd, Fort Wayne, IN 46805, USA; E-Mails: yens@ipfw.edu (M.Y.); lin@ipfw.edu (P.L.); groff.steve@gmail.com (S.G.) U.S. Army Engineer Research & Development Center, Construction Engineering Research Laboratory, P.O. Box 9005, Champaign, IL 61826, USA; E-Mails: Richard.G.Lampo@usace.army.mil (R.L.); Michael.K.McInerney@usace.army.mil (M.M.); Jeffrey.P.Ryan@usace.army.mil (J.R.) * Author to whom correspondence should be addressed; E-Mail: chend@ipfw.edu; Tel.: +1-260-481-6356; Fax: +1-260-481-6281. Received: 18 December 2013; in revised form: 1 August 2014 / Accepted: 4 August 2014 / Published: 8 August 2014 Abstract: An innovative prototype sensor containing A36 carbon steel as a capacitor was explored to monitor early-stage corrosion. The sensor detected the changes of the surface- rather than the bulk- property and morphology of A36 during corrosion. Thus it was more sensitive than the conventional electrical resistance corrosion sensors. After being soaked in an aerated 0.2 M NaCl solution, the sensor’s normalized electrical resistance...

Words: 6878 - Pages: 28

Premium Essay

Business World

...Marketing Mix Crystal Watson MKT/421 February 6, 2013 Brandon Miller University of Phoenix Marketing Mix Marketing is a commonly misrepresented term in today’s business environments. Some organizations and most individuals believe marketing is just about sales and advertising. Often times having such a vague understanding of marketing can determine the success or failure of an organization. In fact, marketing is a much more complex subject and area of business. Known as the four P’s, the marketing mix is a set of four decisions that an organization must make before launching a new product or service. The marketing mix consists of four elements: Product, Place, Price, and Promotion (University of Phoenix, 2011).These four elements work together to assist in making the strategic decisions necessary to ensure a smooth introduction of a product or service. An organization must have a thorough understanding of these four elements as each play a key role when developing an organization marketing strategies and tactics. The pet industry is a steadily rising niche business sector. Climbing up to $50.82 billion in 2011 from $23 billion in 2000, makes the pet industry a hot topic for entrepreneurs and pet lovers alike. Although the pet industry continue to see an increase in revenue, according to the American Veterinary Medical Association (AVMA) American households owned 2 million fewer dogs at the end of 2011 than at the end of 2006 (U.S Pet Ownership & Demographics Sourcebook)...

Words: 1378 - Pages: 6