sql statements 3 2

Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete, copy and paste the SQL statements in a Microsoft Word document:

Write SQL statements:

  • To update the publisher name from READ WITH US to READ FOR US
  • To verify the updated name field for the publisher with ID 6
  • To make the following updates to the Publisher table (be careful with WHERE):
    • Make Contact=”John Travolta” for publisher with ID number 4
    • Make Phone=888-999-7777 for TEXT AND MORE
  • To list the customer numbers and names of all individuals who have purchased books in the information systems category
  • To identify the book written by an author with the last name Cain. Perform the search by using the author name
  • To produce a list of all the customers who live in the state of Indiana and have ordered books on information systems
  • To display a list of all the books in the Books table. If a customer has ordered a book, list the corresponding order number and the state in which the customer resides
  • To identify the authors of the books ordered by Sheila Smith. Perform the search by using the customer name
  • To list the customer numbers and names of all the individuals who have purchased books in the children category
  • To add the following items to the Books table:
ISBN Title Author PubDate Cost Retail Category PubID
1234567890 A Good Book John Jeffries 10/11/2005 13.5 15.00 Non-Fiction 7
2314569874 Trains for Everyone Corey Berkey 12/15/2011 10.25 25.25 Children 8
1598745682 Eating In Susan Smythe 09/09/2012 20.00 30.50 Cooking 6
99954123654 Another Vampire Story Ann Oats 09/05/2010 11.23 13.52 Fiction 4
1025874159 Databases are Fun! Tony Stevens 01/01/2013 4.12 5.23 Information Systems 9
  • To delete the last record added
  • To update the name Susan Smythe to Susan Smythe-Brown
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

what is your client population makeup

Please read the attached document and provide a detailed brief response to each comments. I’ve added some references.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

write a report in apa format 3

Provide with detail explanations of the links between the current spot rate and contracts to buy or sell foreign exchange in the future. Use real-life examples to support your statements/arguments and tell how about the effectiveness of these transactions to the financial situation of the company?

Use your textbook (chapter 20 on pg. 484-514), LIRN-based research,
a general reference list in international Economics, such as:

Specialized Journals (p.12);

General Journals (p.13);

Sources of International Data (p.13);

General Current information p.14) and

the Internet Sources (p. 14)

Document your citations throughout the text of your paper; APA is the accepted format.Your paper must be 3-4 pages must include:

– an introduction and a clear thesis,

– several body paragraphs, and

– a conclusion.

Please use 6 peer reviewed sources.

Text book : Appleyard & Field, (2014). International Economics, 8th Ed. New York: McGraw-Hill. ISBN: 978-0078021671

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

250 350 words 26

A recommendation of either a best of breed or monolithic systems integration strategy. Justify your recommendation. Evaluate the issues involved in each. Describe how private payers play into your thinking about clinical and financial information systems strategies. Describe the role of vendor/client site relationships in these types of decisions. Support your rationale with references.

Rubric

EXCELLENT GOOD FAIR POOR
Discussion Posting Content

16 (53.33%) – 18 (60%)

Discussion posting demonstrates an excellentunderstanding of all of the concepts and key points presented in the text/s and Learning Resources. Posting provides significant detail including multiple relevant examples, evidence from the readings and other scholarly sources, triangulation and discerning ideas.

14 (46.67%) – 15 (50%)

Discussion posting demonstrates a goodunderstanding of most of the concepts and key points presented in the text/s and Learning Resources. Posting provides moderate detail (including at least one pertinent example), evidence from the readings and other scholarly sources, attempt at triangulation and discerning ideas.

12 (40%) – 13 (43.33%)

Discussion posting demonstrates a fairunderstanding of the concepts and key points as presented in the text/s and Learning Resources. Posting may be lacking or incorrect in some area, or in detail and specificity, and/or may not include sufficient pertinent examples or provide sufficient evidence from the readings or triangulation.

0 (0%) – 11 (36.67%)

Discussion posting demonstrates poor or no understanding of the concepts and key points of the text/s and Learning Resources. Posting is incorrect and/or shallow and/or does not include any pertinent examples or provide sufficient evidence from the readings. No attempt at triangulation was shown.

Peer Feedback and Interaction

6 (20%) – 6 (20%)

The feedback postings and responses to questions are excellent and fully contribute to the quality of interaction by offering constructive critique, suggestions, in-depth questions, additional resources, and stimulating thoughts and/or probes.

5 (16.67%) – 5 (16.67%)

The feedback postings and responses to questions are good but may not fully contribute to the quality of interaction by offering constructive critique, suggestions, in-depth questions, additional resources, and stimulating thoughts and/or probes.

4 (13.33%) – 4 (13.33%)

The feedback postings and responses to questions only partially contribute to the quality of interaction by offering insufficient constructive critique or suggestions, shallow questions, or providing poor quality additional resources.

0 (0%) – 3 (10%)

Student does not interact with peers (0 points) or the feedback postings and responses to questions do not contribute to the quality of interaction by offering any constructive critique, suggestions, questions, or additional resources.

Writing

6 (20%) – 6 (20%)

Postings are well organized, use scholarly tone, contain original writing and proper paraphrasing, follow APA style, contain very few or no writing and/or spelling errors, and are fully consistent with graduate level writing style.

5 (16.67%) – 5 (16.67%)

Postings are mostly consistent with graduate level writing style. Postings may have some small organization, scholarly tone, writing, or APA style issues, and/or may contain a few writing and spelling errors.

4 (13.33%) – 4 (13.33%)

Postings are somewhat below graduate level writing style. Postings may be lacking in organization, scholarly tone, APA style, and/or contain many writing and/or spelling errors, or show moderate reliance on quoting vs. original writing and paraphrasing.

0 (0%) – 3 (10%)

Postings are well below graduate level writing style expectations for organization, scholarly tone, APA style, and writing, or show heavy reliance on quoting.

Total Points: 30
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

pre algebra part 1 james madison 6

Question 1 (5 points)

Find the selling price if a store pays $2.00 for a gallon of milk and the markup is 40%.

Question 1 options:

Question 2 (5 points)

Find the selling price if a store pays $38 for a baseball glove and the markup is 30%.

Question 2 options:

Question 3 (5 points)

Find the total amount.

$3600 at 6.5% compounded annually for 2 years.

Question 3 options:

Question 4 (5 points)

How long will it take to earn $1800 in interest if $6000 is invested at a 6% annual interest rate?

Question 4 options:

Question 5 (5 points)

Out of 284 high school students surveyed, how many favored football?

Question 5 options:

Question 6 (5 points)

Before her birthday, Lynette had $230 in her savings account. She received a total of $75 as gifts. What was the percent of change in her account balance? Round your answer to the nearest tenth, if necessary.

Question 6 options:

Question 7 (5 points)

In 1990, the population of Boston, Massachusetts was 574,283. In 2000, the population was 589,141. What is the percent of change in population? Round your answer to the nearest tenth, if necessary.

Question 7 options:

Question 8 (5 points)

Solve each problem using the percent equation.

An mp3 player costs $60. If a 6.75% sales tax is added, what is the total cost?

Question 8 options:

Question 9 (5 points)

Eric had a 25% discount on baseball equipment. The selling price was $172.50. What was the original price?

Question 9 options:

Question 10 (5 points)

Use the percent proportion to solve each problem. Round to the nearest tenth.

24 is what percent of 120?

Question 10 options:

Question 11 (5 points)

An office supply store is having a clearance sale. A computer desk has an original price of $150. It is on sale for 65% off the original price. Find the sale price of the computer desk.

Question 11 options:

Question 12 (5 points)

When the new computer lab opened, there were 18 computers. By the end of first week, there were 25 computers. Find the percent of change in the number of computers? Round your answer to the nearest tenth, if necessary.

Question 12 options:

Question 13 (5 points)

Solve each problem using the percent equation.

What is 32.5% of 40?

Question 13 options:

Question 14 (5 points)

The table shows the results of a survey on people’s favorite fruit. What percent of the people chose strawberry as their favorite fruit? Round to the nearest tenth percent.

Favorite Fruit

Number of People

Apple

17

Orange

10

Banana

17

Pear

3

Strawberry

15

Question 14 options:

Question 15 (5 points)

Suppose 42 stamps are added to a stamp collection that has 30 stamps. What is the percent of change? Round your answer to the nearest tenth, if necessary.

Question 15 options:

Question 16 (5 points)

Solve each problem using the percent equation.

92.4 is 150% of what number?

Question 16 options:

Question 17 (5 points)

Find the simple interest.

$3600 at 2.75% for 6 years.

Question 17 options:

Question 18 (5 points)

A board is cut so that its length is changed from 8 feet to 6.5 feet. What is the percent of change in length? Round your answer to the nearest tenth, if necessary.

Question 18 options:

Question 19 (5 points)

Use the percent proportion to solve each problem. Round to the nearest tenth.

25 is 80% of what number.

Question 19 options:

Question 20 (5 points)

A used car is priced at $5250. If the price is dropped to $4500, what is the percent of change in the price of the car? Round your answer to the nearest tenth, if necessary.

Question 20 options:


 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

one accounting computation

attatched are the photos. i have attatched the photos of the chapter along with the problem it is one easy problem

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

answer the question correctly 1

Posting

Using the required Posting Template, post your response(s) to the selected question(s), remembering to use and follow the guidelines and requirements listed in the course syllabus.

Post your initial response by Wednesday 11:59PM.

Discussion

Using the required Discussion Template, respond to at least 5other students’ postings by Saturday 11:59PM.

Ch. 16

Contrast 5 typical foods of Thailand with those of Polynesia. State why, give examples, support and explain your answers.

Ch. 17

Research and select two examples of cultural contributions China has given to the world, and describe representative works. State why, give examples, support and explain your answers..

Ch. 18

The food, beverages and culture of Korea are very much alive in every aspect of their everyday lives. Explore the Korean culture and select an aspect that you find very interesting and want to know more about. Report on your selection and research. State why, give examples, support and explain your answers.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

discussion 250 words arts 110

Terminology is important when discussing drama. One of the basic elements of a script is the plot. There is also the important element of theme. Tell us the difference between plot and theme. Make sure to use examples to illustrate your points. Feel free to use examples from novels, other plays, or even films or television.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

read the cases study and answer the questions

there are two case study in the following attachments,

first has 3 questions , second has 4 questions.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

discussion multiple regression 3

This Discussion assists in solidifying your understanding of statistical testing by engaging in some
data analysis. This week you will work with a real, secondary dataset to construct a research question, estimate a multiple regression model, and interpret the results.

Whether in a scholarly or practitioner setting, good research and data analysis should have the benefit of peer feedback. For this Discussion, you will post your response to the hypothesis test, along with the results. Be sure and remember that the goal is to obtain constructive feedback to improve the research and its interpretation, so please view this as an opportunity to learn from one another.

To prepare for this Discussion:

  • Review this week’s Learning Resources and media program related to multiple regression.
  • Create a research question using the General Social Survey that can be answered by multiple regression.

By Day 3

Use SPSS to answer the research question. Post your response to the following:

  1. What is your research question?
  2. What is the null hypothesis for your question?
  3. What research design would align with this question?
  4. What dependent variable was used and how is it measured?
  5. What independent variable is used and how is it measured?
  6. What other variables were added to the multiple regression models as controls?
  7. What is the justification for adding the variables?
  8. If you found significance, what is the strength of the effect?
  9. Explain your results for a lay audience, explain what the answer to your research question.

Be sure to support your Main Post and Response Post with reference to the week’s Learning Resources and other scholarly evidence in APA Style.zero plagirizing, Quote work, no.com’s

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.