Free Essay

Week 2 Assignment

In:

Submitted By vishtu
Words 318
Pages 2
Week 2 Assignment
Grayson Wimmer

1. What is the simplest SQL retrieval?
SELECT
2. What is the purpose of the Where clause when using SELECT?
The WHERE clause is used to extract only those records that fulfill a specified criterion.

3. What are data types and why are they important?
A data type is a classification identifying one of various types of data, they are important because assigning data types gives meaning to collections of information
4. Provide an example of the GROUP by clause, when would you use this clause?

SELECT Salesperson, SUM(Revenue) AS ‘Total’, MIN(Revenue) AS ‘Smallest’, MAX(Revenue) AS ‘Largest’, AVG(Revenue) AS ‘Average’, COUNT(Revenue) AS ‘Number’ FROM Orders GROUP BY Salesperson
You use this clause when you need to see the information in a certain order
5. What is an aggregate function (provide 4)? How are they used?
An aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement
AVG() - Returns the average value (average)
COUNT() - Returns the number of rows (count)
FIRST() - Returns the first value
LAST() - Returns the last value
6. Provide example using the COUNT() function
SELECT COUNT(*)
FROM employees
WHERE salary > 25000;

7. How is a field name qualified? How is this used when using a JOIN command, why is it important?
A Field name is qualified by preceding the name of the filed with the name by the table followed by a period. This is used when using the JOIN command when there is potential doubt in listing the field names. This is important to make sure that you are joining the correct fields.

8. What are the three update commands in SQL?
UPDATE, INSERT, DELETE

9. What method allows you to re-order the presentation data?

10. How are SQL built-in functions used?

Similar Documents

Free Essay

Week 2 Assignment

...Week 2 Assignment Dianglio V. Baylor September 9, 2014 Week 2 Assignment The film that I selected for this week’s assignment is 2007 film “Knocked Up”. The film starred actors Seth Rogen, Katherine Heigi, Paul Rudd, Leslie Mann and Jason Segel. The genre of this film is considered to be a romantic comedy. Romantic comedies are considered to be the least flexible of all the genres of film. There are a number of reasons that have been identified as reasons that this genre is lacking. The plot of a romantic comedy involves romance that leads to comic situations. In recent years the film genre has been identified genericly with a female protagonist finding love against all odds with a course of unconventional comic situations along the way. There can also be a variation of the basic plotline, instead of the typical romance where the two lead characters end up falling in love there could be a mismatch in love affair with the primary character and a secondary character. In the romantic comedy genre one of the reasons cited is that the scope of what this genre seeks to accomplish is limited. According to the textbook the romantic comedy is limited in scope of what it attempts to accomplish – brining two people together. There are many ways for this to happen, and many comedic obstacles to be placed before them , but the goal remains the same (Goodykoontz, B. & Jacobs C. P. 2011). The struggle that is present within this genre is for a romantic...

Words: 872 - Pages: 4

Premium Essay

Week 2 Assignment

...I will use it when telling stories, planning activities, and picking books for the children. I will also use this new knowledge to help me educate my daughter at home. Which assignment challenged you the most, and in what ways? I found the Week 2 assignment to be the most challenging because I really thought I understood the assignment but I had to re-read and do it over again. I also, found the picturebook assignment challenging because in storybook you are only allowed the pictures that the give you after you pick one. I tried to have the people represent the duck in my story because I didn’t want to use that one “Duck” picture for the whole book. It was just frustrating! I feel like I’m not getting anything right in this course. I’m really depressed about this! Discuss the assignments you found the most interesting or engaging, and explain why you felt this way. I really enjoyed putting the picturebook together because I tried to make it child friendly and also have it rhyme. It was fun putting it together and also seeing that the children loved hearing the story over and over. Again, I didn’t get this assignment...

Words: 432 - Pages: 2

Premium Essay

Week 2 Assignment

...Jaleesa  Branch                                                                                                                                                                                                                                                                                              MGMT  597...

Words: 525 - Pages: 3

Premium Essay

Week 2 Assignment

...Week 2 Assignment Wednesday oct 8, 2014 1.What is professionalism? Professionalism describes the qualities, skills, competence and behaviors expected of individuals belonging to any given profession. Professionalism in the workplace is based on many factors, including how you dress; carry yourself, your attitude and how you interact with others. The definition of professionalism indicates that each person perform their tasks with genuine earnest and honesty. It refers to a person doing his / her job with sincerity, and maintaining professional etiquette and ethics in the workplace. 2.Why is goal setting important? Setting goals is a fundamental component to long-term success. The basic reason for this is that you can’t get where you are trying to go until you clearly define where that is. Goals help you focus and allocate your time and resources efficiently, and they can keep you motivated when you feel like giving up. Furthermore, setting and achieving goals translates to feelings of success for both individuals and companies, which in turn spurs greater productivity and confidence. 3.What are Ways of teamwork in the physician’s office? Developing an effective and highly functional staff that puts practice performance first, though, is easier said than done. To a large degree, that’s because medical practices are comprised of a small group of people who work together but perform very different roles. As practice administrator, you can encourage teamwork by modeling good...

Words: 392 - Pages: 2

Free Essay

Week 2 Assignment

...MAT 221 Ashford University Instructor: Professor January 27, 2011 In this paper I will be figuring out the intervals of people with my height for their BMI. I will be using my height and weight for the following intervals: 17<BMI<=22 23<BMI<=25 25<BMI<=30 BMI>30 First I will solve the following interval: 17<BMI<22. This is called an equivalent inequality. In order to plug in the proper information I will be using the following formula: 703W/H^2. 17<703W/H^2<22 17<703W/65^2<22 H^2 has been replaced with my height in inches. 17<703W/4225<22 My next step is to multiply all three terms by the denominator. 17(4225)<703(4225)W/4225<22(4225) 71825<703W<92950 Multiplication done 71825/703<703W/703<92950/703 Now I am going to divide by 703 in order to isolate w. 102.1<w<132.2 Division completed. According to the formula people with the height 65 inches and weight between 102.1 and 132.2 are more than likely not overweight. In the next interval, I am going to figure the weight for people who are not overweight and are 65 inches tall. 23<703W/4225<25 23(4225)<703(4225)W/4225<25(4225) My next step will be multiplying all three terms by the denominator. 97175<703W<105625 Multiplication complete 97175/703<703W/703<105625/703 Now I am going to divide all three terms by 703 in order to isolate w. 138.22<w<150.24 Division completed. People with the height of...

Words: 947 - Pages: 4

Premium Essay

Week 2 Assignment

...Strayer university | Assignment 1: The Business Environment | Business and the Economy | BUS100Demetrius Carolina | Malcolm Johnson | 2/4/2013 | | | The business environment has grown tremendously in the past century. It has become a vast outlet for many to start their own, in this essay I will explain the role, advantages and disadvantages of business in the economy The Role of Business in the economy is the main component because our economy is capitalistic. Business is in every sector of the market. Everything that is thought of that relates the economy is business. For example retail, services, agriculture, manufacturing, health care, even political campaigning all involves business. Without business, humans would have to completely fend for themselves for absolutely everything. This is why people create trade with each other. Instead of having to provide ourselves with everything, we can focus on producing one product or expertise. We can then specialize in that product or expertise to make it the best in the market and then sell it for a profit. In business the Factors of Production or natural Resources which includes all in puts that offer value in their natural state, such as land, fresh water, wind, and mineral deposits. Capital which includes machines, tools, buildings, information, and technology, the synthetic resources that a business needs to produce goods or services, Human Resources this factor encompasses the physical, intellectual, and creative...

Words: 808 - Pages: 4

Premium Essay

Week 2 Assignment

...Service Request SR-rm-022 Part 1 Janaya Hoskins BSA/375 June 29, 2015 Anjit Bose Table of Contents 1.1 Introduction 1.2 Stakeholders & Requirements 1.3 Information-gathering techniques & Systems analysis tools 1.4 Scope & Feasibility 1.5 Conclusion References Service Request SR-rm-022 Part 1 1.1 Introduction Hugh McCauley, COO of Riordan Manufacturing wants to combine existing variety of tolls that are used in a single integrated application. Riordan Manufacturing wants to take advantage of a more sophisticated state of the art information systems that already exist in the company’s human resource department. This paper will discuss what key stakeholders in Riordan Manufacturing would gather requirements from, describe the information-gathering techniques and systems analysis tools you would propose for the project, identify the key factors that help ensure the information required for the project is gathered successfully and explain what project scope is and why it is important. I will also describe the areas of project feasibility that are examined in the analysis phase of the SDLC. 1.2 Stakeholders & Requirements A stakeholder is any person, organization, social group, or society at large that has a stake in the business. Thus, stakeholders can be internal or external to the business. A stake is a vital interest in the business or its activities. It can include ownership and property interests, legal interests and obligations, and moral rights. A legal...

Words: 1491 - Pages: 6

Premium Essay

Week 2 Assignment

...Kelsey Malcom Chapter End Q & A Chapter 14 14.2- Real Property Issue ------------------------------------------------- Is the oral contract between Briggs and Sackett in violation and voidable under the Statute of Frauds? In Briggs v. Sackett, Briggs bought a home under mortgage but came upon unforeseeable financial instability. The Briggs then spoke with their in-laws, the Sacketts, about purchasing the home with the conditions that they pay the 3 months arrearages or the overdue balance on the loan and take over the expenses of the home (future payments, utilities, etc.). After hearing the offer, the Sacketts accepted the Briggs’ conditions for the purchase of the home and an oral contract was put in motion. The Sacketts moved in. Years later Mr. Briggs filed an action under the Statute of Frauds, that the oral contract they made with the Sacketts was voidable because it was in violation of the Statute of Frauds (Briggs v. Sackett, 1980). Per our book, under the Statute of Frauds, contracts that involve the sale of real estate are required to be in writing. Generally, if an oral contract was made but required to be in writing, under the Statute of Frauds the oral contract would be unenforceable (Cheeseman, 2010, p.220). In the case of Briggs v. Sackett, should Briggs’ action of filing with the court to void their oral contract and evict the Sackett family be enforceable? No, the Sackett family should be considered an exception to the rule, an equity...

Words: 1443 - Pages: 6

Free Essay

Week 2 - Assignment

...What is the result of your IAT? The results of my test were “Your data suggest little to no automatic preference between African American and European American.” Do you think the test produced valid results in your case? I honestly do agree that the test is correct. I grew up in a mixed neighborhood and just as everywhere else in society there are some good kids and some bad ones, neither leaning towards any particular race or skin tone. The associations the test provided were a great means of determining on a sub-conscious level what an individual’s thoughts are. Much like a Freudian Slip where you say one thing while meaning another. In your opinion, is it difficult to accurately measure prejudice? Why? I find that so long as the one measuring the prejudice is objective to all forms of prejudice, or they are not affected by it, than yes it is possible but very difficult. For the average person that seems to hold some form of prejudice or another it would be much more difficult. No one can know what they are doing wrong if no one tells them after-all. Describe other measurements sociologists utilize to calculate prejudice. I did not read anything specifically referring to measuring prejudice but the textbook did cover measuring discrimination, which I would assume is measured much the same way. Though in a normal environment where there is a timid bigot he may not openly discriminating he will be less likely or work harder to stop minorities...

Words: 332 - Pages: 2

Premium Essay

Week 2 Assignment

...Ethics in Strategic Plans Todd Balzer MGT/498 28 October 2013 Debra Grisamer Write a 700- to 900-word paper in which you do the following: Explain the role of ethics and social responsibility in developing a strategic plan while considering stakeholder needs and agendas. Ethics in Strategic Plans When developing a strategic plan with social responsibility in mind, organizations have two separate viewpoints. One view is of Milton Friedman’s with a laissez-faire approach. This approach was a popular viewpoint in from his first publication in the 1950’s and was an economic advisor to Ronald Reagan, and is one of the most influential economists of the 20th Century. Friedman’s theory is that corporations should only act in the best interests of their shareholders. To do otherwise is actually counter-productive to the organization and the overall economy. An example is corporations heavily investing in the neighborhoods in which they operate. Freedman would argue that investment takes money away from the shareholders, or reinvestment into the organization, and is counter-productive to the overall success of the organization. Freedman would also argue what is bad for the success of the organization is also negatively affects the overall economy both locally and the macro level. The money invested in the organization could go to shareholders who in turn would invest into the economy on a larger scale and ultimately help the same neighborhoods, people,...

Words: 757 - Pages: 4

Premium Essay

Week 2 Assignment

...Title: Outline Martin Luther King Jr. on NBC’s Meet the Press in 1965 Instructor: Eric Maass Course: PHI103: Informal Logic Author: Amanda Manley Date: 11/17/2014 I am doing my outline on Martin Luther King Jr. on NBC’s Meet the Press in 1965, Martin Luther King, Jr. is best known for his contribution to the African American civil rights movement in the United States. Born Michael King, Jr. on January 15, 1929, King was the son of a reverend and a former teacher. The future activist was skeptical about Christianity from an early age. Despite his doubts about his own faith, King went on to graduate from Crozer Theological Seminary and became a Baptist minister when he was twenty-five, practicing public speaking skills that would eventually make him one of America's greatest orators. By the same time, King was working as an executive committee member for the National Association for the Advancement of Colored People. Having grown up in a segregated environment, King was already aware of the disparity in civil rights for African Americans. He took a stand against segregation in 1955, by leading the first nonviolent Negro demonstration - a bus boycott that resulted in a law that prevented segregation on public transportation. The next year, King was elected president of the Southern Christian Leadership Conference and began to write and deliver speeches across the United States and the world. While he took the ideals for his organization and mission from...

Words: 368 - Pages: 2

Free Essay

Gm520 - Week 2 Assignment

...| Week  2:  Administrative Regulations - Assignments    |   | | |  Help | |   |   | | | Print Assignments | Reading: Chapter 5: Business and the Constitution Chapter 6: Administrative Law Chapter 7: International Law (pp. 221-238) Assignment:Pick an administrative agency of either the Federal or a State government. Find where the current and proposed regulation changes for that agency are located on the internet. (i.e. the Federal Register or the State Administrative Agency website.) Regulations.gov is a good place to begin your research. Pick one proposed regulation change currently under consideration (if you find one which has already closed out, but interests you, you can use that, instead) and write the following regarding it:1. State the administrative agency which controls the regulation. Explain why this agency and your proposed regulation interests you (briefly). Will this proposed regulation affect you or the business in which you are working? If so, how? Submit a copy of the proposed regulation along with your responses to these five questions. The proposed regulation can be submitted as either a separate Word document (.doc) or Adobe file (.pdf). This means you will submit two attachments to the Week 2 Dropbox: (1) a Word doc with the questions and your answers and (2) a copy of the proposed regulation you used for this assignment. (10 points)2. Describe the proposal/change. (10 points)3. Write the public comment which you would submit to this proposal...

Words: 1306 - Pages: 6

Premium Essay

Mgt404 Week 2 Assignment

...Anya M. Williams MGT404- Operations Management Professor Dr. Willie Brown Week 2 Assignment Analyzing Casino Money- Handling Processes 1. Drop Process How long should it take to empty 300 silver dollar slot machines? 15 min + 10 min (300 slot machines) + (300 slot machines/ 20 buckets per cart)(30 minutes delivery per cart)= 15 + 3000+450 = 3465 min / 60mins = 57 hrs and 45 mins 2. Hard Count Process How long should this process take to complete for 300 silver dollar slot machines? Assume that each slot machine has an average of 750 silver dollars when its emptied 10min weight scales + 7min per bucket(300 machines) +[ (750 per bucket * 300 machines)/25 per roll] / 10 rolls per min + (9000 rolls/40roll per can)(5min to fill and stack) + 5 min to record on report + (9000 rolls/40roll per can)(2 min per can verification) = 10+2100+900+1125+450+5 = 4590mins / 60 = 76.50 hours 3. Purchasing a second coin wrapping machine would enhance the hard count process. They would be able to complete twice as many rolls per minute and you can complete the process in half the time. With a new machine the process would have to be revised so you don’t have jams in the conveyer belt. I am not sure that purchasing this machine would be the most desirable because technology is advancing and developing and such a rapid rate that casino’s may want to look into upgrading the actual slot machines. 4. Electric slot machines that do not use cash would have a huge impact on the...

Words: 294 - Pages: 2

Premium Essay

Week 8 Assignment 2

...Week 8 Assignment 2 Clifton Bland Professor Hughes BUS 325 March 1, 2015 Introduction Human resource management refers to the exercise or function through which an organization will be able to maximize the productivity of its employees through set strategic objectives. Human resource management determines the motivation that employees of an organization have to work at the employing organization. This is because human resource management deals with all aspects that pertain to the workplace environment including salaries and wages. Therefore, it is important for an organization to perform quality human resource management right from the recruitment of an individual to the retirement of the individual. In the case that an organization mistreats its employees, the employees will not perform to their maximum potential thereby reducing the productivity of the organization and by extension, the organizations profit margins (Hurn, 2007). Human Resource Management as a Strategy Organizations use human resource management as a strategy to improve its productivity in terms of volumetric production as well as quality production. This is simply through the motivation of the employees to help improve the corporation’s productivity. In simple terms, happy employees contribute to the success of the company because of their motivation to work. Performance, productivity, quality, and specialization qualities will improve once they are happy. In addition, human resource management is...

Words: 2092 - Pages: 9

Free Essay

Nt1330 Week 2 Assignment

...ITT Technical Institute 3825 West Cheyenne Avenue, Suite 600 North Las Vegas, Nevada 89032 NT1330 Client-Server Networking II Name: ____________________________________________________ Date: _______________________ NT1330 Week 2, Assignment 2 Instructions: 1. Complete this assignment and submit it prior to the beginning of the next class meeting. 2. Completely fill in the bubble for the correct answer(s), any other mark such as an X or just a line through it will be marked as incorrect. 1. DHCP frees system administrators from manually configuring each host on the network. A True B False 2. The smaller the network, the greater the benefit of using a dynamic address assignment. A True B False 3. DHCP provides three key benefits to those managing and maintaining a TCP/IP network. A True B False 4. The key aspect of the DHCP process is that it is dynamic. A True B False 5. Once a DHCP scope is defined and exclusion ranges are applied, the remaining addresses form what is called an available address pool within the scope. A B True False 6. To conserve disk space, DNS servers store only the most recent updates. A True B False 7. The primary DNS server for a zone is not required to perform an incremental zone transfer. A True B False Steve Todd Page 1 of 8 8. For replication of Active Directory–integrated zones, DNS notification is needed. A True B False 9. Scavenging is enabled by default. A True B False 10. As long as the TTL for a cached resource record does not expire...

Words: 1735 - Pages: 7