Week 2 Assignment

In: Miscellaneous

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…...

Similar Documents

Week 8 Assignment 2

...Week 8 Assignment 2 Dr.Chinwe E. Nweke ECO100089VA016-1128-001 Principles of Economics December 2, 2012 1. Analyze the current economic situation in the U.S. as compared to five (5) years ago. Include interest rates, inflation, and unemployment in your analysis. The news informs everyone on a daily basis that the United States has the largest economy and that it is looking to be in great shape since four years ago. To some Americans it seems otherwise. The unemployment rate in 2007 was 4.6% compared to unemployment rate in 2012 at 7.5%. The U.S inflation rate ended in October 2012 after twelve months was 2.16% which is 0.11% higher than the one in September. The U.S inflation forecast consists of apparel, education and communication, energy, food and beverages, housing, medical care, recreation, and transportation. The U.S Government’s inflation economics policy tries to control inflation. High inflation and negative inflation (deflation) can have damaging effects on the economy. 2. Propose two (2) strategies that the federal government could implement that would encourage people to spend more money in order to create employment opportunities. Two strategies that the federal government could implement that would encourage people to spend more money in order to create employment opportunities is to give free college training to low income and unemployed. This would allow them to get paid for going to school or training. It would also provide an automatic job after...

Words: 796 - Pages: 4

Is589 Week 2 Assignment

...IS589 Week 2 AssignmentWeek 2: Physical Layer and LANs - You Decide | | Print This Page | | Scenario | | Scenario Summary | Leonard Cooper Charter School is a K-12 school with approximately 1,000 students. The school wants to develop a local area network that meets the needs of the school now and is scalable for the future. There have been numerous complaints about the speed and reliability of the network, especially since a new addition to the building was added a few years back. Your Role and Assignment | You are the systems administrator contracted by Leonard Cooper to upgrade the local area network to meet the ever-increasing needs of the building's students and faculty members. Your first task is to interview key stakeholders to determine what the key areas of concern are. Activity | The charter school's CEO has requested your help in updating the network to meet the demands of the building's faculty members and students. Your job is to interview the key stakeholders and to take action to remedy the issues that they have. * Write a two to three page proposal addressing each of the stakeholder concerns. Use the technologies below for the areas of concern. All of the technologies listed below will not be used, so be careful with your choices. You must use one of the solutions below to address each area of concern. Be specific in your responses, and justify the use of each technology based upon the concern. Category 2 UTP 10Base - T Ethernet......

Words: 1203 - Pages: 5

Week 2 Film Assignment

...Week 2 Assignment Movie - Zoolander (2001) In this paper , I will discuss the elements of design. I will talk about and give a full break down of the process of envisioning and designing a film, which includes the key players of what it takes to design a film. My film of choice I will talk about and give examples for is Zoolander (2001). Film Production Director- Ben Stiller Production Designer- Robin Standefer Art Director- Stephen Alesch A film director is the person who directs the making of a film. In some cases the film director can control the artistic and dramatic aspects of the film . They also visualize the script while depending on the cast and crew to help bring his/her vision to life. The director plays a major part in choosing the cast and crew. Once the director comes up with the vision of the film they make the necessary movements to get things started and begin shooting, once shooting starts they have deadlines to meet. In the movie Zoolander (2001) Ben Stiller was the film director. A production designer (PD) is the person responsible for the overall look of a filmed event. They are the major head of the the entire art department. They control things such as films, tv programs, video games, music videos, and or advertisements. The production designer will collaborate with the director and director of photography to get a visual feel of the specific needs for the project. The production designer for the Zoolander (2001) film was......

Words: 592 - Pages: 3

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......

Words: 872 - Pages: 4

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......

Words: 294 - Pages: 2

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

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......

Words: 1306 - Pages: 6

Week 2 Assignment

...indicated below. | The Health Insurance Portability and Accountability Act (HIPAA) is a national law that protects a patient’s rights to privacy. As a Medical Administrative Assistant, it is important for you to understand and uphold this law to protect your patients’ health information. In this assignment, you will practice applying HIPAA regulations. Click here to download the Personal Health Record (PHR) to answer the first three questions. | Tips for answering questions: * Read the question more than twice, if necessary, to make sure you understand what you are asked to do. * Find the key words in the question and construct your answer to address those key words or phrases of the question. * Your answer should be organized and to the point. * Keep your sentences short and simple. Pay attention to the answer length requirements (if stated). * If necessary, go the extra mile and give examples to illustrate your point. | Before you continue: * Did you save this document to your computer? * No: Please save this document to your computer now. * Yes: Great! Let’s get to work! | (See next page for part 1) Question 1: Dr. Moodey saw John last week for his annual physical. Dr. Moodey sent John for some lab work as he was concerned that John may have developed diabetes mellitus. John asked the Medical Assistant, Sally, to contact him on his cell phone to discuss the results of the lab tests. When the results came in, Sally called John’s......

Words: 886 - Pages: 4

Nur508 Week 2 Assignment

...NUR508 Week 2 Assignment Click Link Below To Buy: http://hwcampus.com/shop/nur508-week-2-assignment/ The IOM Future of Nursing report calls for an increase in leadership from nurses at all levels. One way nurses demonstrate their role as a leader, is through public policy change. A leader does not always carry an official title or position, but demonstrates leadership through the work and the stance he/she takes to make a change for the good of others. Nurses have been noted by the Gallop poll year after year as the most trusted professionals. This assignment requires thought about a public policy that is needed or needs to be changed that relates to nursing, healthcare, and/or the public. Policy changes can occur by working with members of your legislature, and state or national nurses associations, to introduce a new bill and/or change to a current law in your state or federal government. Examples of public policy includes any component of the current legislation governing health care, Medicare part D, Medicaid, nursing regulation, medication technicians, etc. In 750-1000 words, propose a health policy change (that is currently a bill, a law, or may not exist at all) at the state or federal level that you believe needs to change and why. 1. The policy must NOT be a clinical care policy for individual care. The policy involved may include public or community health, legislative or regulatory, professional organization (nursing-oriented), advanced nursing practice...

Words: 446 - Pages: 2

Psc495 Week 2 Assignment

...PSC495 Week 2 Assignment Click Link Below To Buy: http://hwcampus.com/shop/psc495-week-2-assignment/ The purpose of this assignment is to conduct internal and external research to determine previously attempted solutions and potential solutions that could be implemented to solve identified problem. For this assignment, you will need to create an Excel spreadsheet that summarizes the data collection you have completed. The spreadsheet should indicate the date on which particular data were collected, the source of the data collected, the type of data (qualitative or quantitative), and a one or two sentence summary of the data findings. Name the Excel spreadsheet as follows: lastname.firstname.datacollection.xlsx Please note that as part of the research process, taking the initiative to speak with management and then requesting and reviewing business metrics and operations reports will allow you to find the data you need for the project while also showing your employer that you can be proactive and use critical thinking to solve problems within the organization. Part 1: The first step in data collection is to conduct research. You are looking for specific, measurable data (statistics and numbers) related how the problem is affecting the organization. This information should be recorded in the form of a chart or graph that presents the data so key decision makers can see the "cost" of failing to address the problem. Use the Topic Materials for assistance with......

Words: 664 - Pages: 3

Nur508 Week 2 Assignment

...NUR508 Week 2 Assignment Click Link Below To Buy: http://hwcampus.com/shop/nur508-week-2-assignment/ The IOM Future of Nursing report calls for an increase in leadership from nurses at all levels. One way nurses demonstrate their role as a leader, is through public policy change. A leader does not always carry an official title or position, but demonstrates leadership through the work and the stance he/she takes to make a change for the good of others. Nurses have been noted by the Gallop poll year after year as the most trusted professionals. This assignment requires thought about a public policy that is needed or needs to be changed that relates to nursing, healthcare, and/or the public. Policy changes can occur by working with members of your legislature, and state or national nurses associations, to introduce a new bill and/or change to a current law in your state or federal government. Examples of public policy includes any component of the current legislation governing health care, Medicare part D, Medicaid, nursing regulation, medication technicians, etc. In 750-1000 words, propose a health policy change (that is currently a bill, a law, or may not exist at all) at the state or federal level that you believe needs to change and why. 1. The policy must NOT be a clinical care policy for individual care. The policy involved may include public or community health, legislative or regulatory, professional organization (nursing-oriented), advanced nursing practice...

Words: 446 - Pages: 2

Psc495 Week 2 Assignment

...PSC495 Week 2 Assignment Click Link Below To Buy: http://hwcampus.com/shop/psc495-week-2-assignment/ The purpose of this assignment is to conduct internal and external research to determine previously attempted solutions and potential solutions that could be implemented to solve identified problem. For this assignment, you will need to create an Excel spreadsheet that summarizes the data collection you have completed. The spreadsheet should indicate the date on which particular data were collected, the source of the data collected, the type of data (qualitative or quantitative), and a one or two sentence summary of the data findings. Name the Excel spreadsheet as follows: lastname.firstname.datacollection.xlsx Please note that as part of the research process, taking the initiative to speak with management and then requesting and reviewing business metrics and operations reports will allow you to find the data you need for the project while also showing your employer that you can be proactive and use critical thinking to solve problems within the organization. Part 1: The first step in data collection is to conduct research. You are looking for specific, measurable data (statistics and numbers) related how the problem is affecting the organization. This information should be recorded in the form of a chart or graph that presents the data so key decision makers can see the "cost" of failing to address the problem. Use the Topic Materials for assistance with......

Words: 664 - Pages: 3

Acct346 Week 2 Assignment

...ACCT346 Week 2 Assignment Click Link Below To Buy: http://hwaid.com/shop/acct346-week-2-assignment/ Directions: Complete the three questions below and please be sure to show all of your calculation work along with the final answers in the box provided for each question. Also note that Question #3 has TWO parts, Part A and Part B. To give yourself more room to insert your calculations and answers, you may need to add more rows or columns to the boxes below. 1. Biltz Company uses a predetermined manufacturing overhead rate based on direct labor hours to allocate (apply) manufacturing overhead costs to jobs. During the year, the company actually incurred total manufacturing overhead costs of $582,000 and 135,000 direct labor hours were worked. The company originally estimated that it would incur $525,000 of manufacturing overhead during the year and that 150,000 direct labor hours would be worked. How much was manufacturing overhead over¬allocated (over¬applied) or under¬allocated (under¬applied) for the year? 2. The following account balances at the beginning of January were selected from the general ledger of Ocean City Manufacturing Company: Work¬in¬process (WIP) inventory Raw materials inventory Finished goods inventory $0 $28,000 $40,000 Additional data: 1) Actual manufacturing overhead for January amounted to $62,000. 2) Total direct labor cost for January was $63,000. 3) The predetermined manufacturing overhead rate is based on direct labor......

Words: 490 - Pages: 2

Nur508 Week 2 Assignment

...NUR508 Week 2 Assignment Click Link Below To Buy: http://hwcampus.com/shop/nur508-week-2-assignment/ The IOM Future of Nursing report calls for an increase in leadership from nurses at all levels. One way nurses demonstrate their role as a leader, is through public policy change. A leader does not always carry an official title or position, but demonstrates leadership through the work and the stance he/she takes to make a change for the good of others. Nurses have been noted by the Gallop poll year after year as the most trusted professionals. This assignment requires thought about a public policy that is needed or needs to be changed that relates to nursing, healthcare, and/or the public. Policy changes can occur by working with members of your legislature, and state or national nurses associations, to introduce a new bill and/or change to a current law in your state or federal government. Examples of public policy includes any component of the current legislation governing health care, Medicare part D, Medicaid, nursing regulation, medication technicians, etc. In 750-1000 words, propose a health policy change (that is currently a bill, a law, or may not exist at all) at the state or federal level that you believe needs to change and why. 1. The policy must NOT be a clinical care policy for individual care. The policy involved may include public or community health, legislative or regulatory, professional organization (nursing-oriented), advanced nursing practice...

Words: 446 - Pages: 2

Psc495 Week 2 Assignment

...PSC495 Week 2 Assignment Click Link Below To Buy: http://hwcampus.com/shop/psc495-week-2-assignment/ The purpose of this assignment is to conduct internal and external research to determine previously attempted solutions and potential solutions that could be implemented to solve identified problem. For this assignment, you will need to create an Excel spreadsheet that summarizes the data collection you have completed. The spreadsheet should indicate the date on which particular data were collected, the source of the data collected, the type of data (qualitative or quantitative), and a one or two sentence summary of the data findings. Name the Excel spreadsheet as follows: lastname.firstname.datacollection.xlsx Please note that as part of the research process, taking the initiative to speak with management and then requesting and reviewing business metrics and operations reports will allow you to find the data you need for the project while also showing your employer that you can be proactive and use critical thinking to solve problems within the organization. Part 1: The first step in data collection is to conduct research. You are looking for specific, measurable data (statistics and numbers) related how the problem is affecting the organization. This information should be recorded in the form of a chart or graph that presents the data so key decision makers can see the "cost" of failing to address the problem. Use the Topic Materials for assistance with......

Words: 664 - Pages: 3