User Account

All Pages

E-commerce transaction

Assignment Help Computer Engineering
Reference no: EM13841644

Question 1: Suspicious e-commerce transaction includes orders placed by a customer in one country that are shipped to another country. In fact there are no such orders in the Northwind db,  so create a few by modifying some of the "Germany" shipcountry entries in the order table to "Tahiti". Then write a query which finds orders shipped to a different country from the customer. Hint: in order to do this, you will need a join the customer and order table. You don't want to be hardcoding the country names in your query, but are actually looking for situation where the country of order and the country of shipping are not the same.

Question 2: Suppose a user wants to know how much freight each customer paid for all his order - ie sum of the total dollar amount a customer spent. Write a query to do this.

Question 3: Pick the special operators that can be used with the LIKE operator.

  • %
  • _
  • *
  • []
  • [^]
  • {}

Attachment:- Northwind Queries.docx

Reference no: EM13841644

Questions Cloud

Phenomena on the world market for loanable funds : Illustrate the effect of these phenomena on the world market for loanable funds. Which way does this argument predict the interest rate to adjust?
Produce a project plan for building a house : Produce a project plan for building a house. Follow the phases and tasks shown on the web page. You can click on each to see background information on that phase or task, so you can better understand it
Data management-erd diagram definition : The entity relationship diagram is crucial to the  creation of a successfully implemented application and database. A good understanding of how to identify the components that define the Entity Relationship Diagram is needed. Select one of the fol..
The fed raise the federal funds rate : What were the immediate consequences of this decision on the financial markets on Thursday and Friday. Was this anticipated to be the reaction. If the Fed was convinced that the economy was developing moderately, why not raise rates and why should..
E-commerce transaction : Question 1: Suspicious e-commerce transaction includes orders placed by a customer in one country that are shipped to another country. In fact there are no such orders in the Northwind db,  so create a few by modifying some of the "Germany
Calculate the rate of growth of real gdp : Show nominal GDP, the GDP price index for the data above for any 10 years; make sure that one of the years is the base year. Put both real and nominal GDP I the same graph.
Does descartes believe in god? : Does Descartes believe in God?
Draw the different components of gdp : What are the two accounts of an economic system and List all the components on both sides as they appear in the text - Compute the total GDP
Assess financial performance and condition of organization : Assess the financial performance and condition of the organization

Reviews

Write a Review

Computer Engineering Questions & Answers

  Illustrate the differences between standard peripheral

what are the differences between standard peripheral component interconnect pci and pci express? how might increasing

  Program to compute the area and circumference of circle

Algorithm which will prompt for and receive the measurement of the diameter of a circle and compute and show the area and circumference of the circle.

  Security policy document project

Analyze security requirements and develop a security policy

  Determining the smallest values in dictionary

Explain an efficient method for determining the k smallest values in the dictionary which are greater than low. Your method must take much less than O (n) time whenever k is much less than n. Analyze the time for your method.

  The application must have at least one class

A salesperson can also receive a commission as a sales incentive. Commission is a percentage of the salesperson's annual sales. The current commission is 5 percentof total sales.

  Discuss software testing as a career path in brief

discuss software testing as a career path in brief. The techniques for solving linear equations and linear inequalities are similar, yet different. Explain and give an example of both a linear equation and a linear inequality that demonstrates this..

  Make application that will read and process customer history

making a file that Develop an application that would read and process customer history order information from a file.

  Patients taking benefit of social networks

Patients are able to take the benefit of the social networks to do more than just the share pictures and tweets. Analyze the benefit and de-merits of utilizing the mobile computing technology in order to monitor the patients.

  Back-propagation neural network

Company hires your team in order to develop the back-propagation neural network(s) for predicting next-week trend of five stocks (that is, go up, go down, or remain same).

  Trade off the use of single link complete link wards method

question 1 using the documentdocument relationship matrix for similarity values andthe starting point of the following

  Analyze the technologies for analog-to-digital

Write a 3- to 5-page paper that provides a detailed technical analysis comparing the advantages and disadvantages of analog and digital technology. With this understanding, do the following: Analyze the technologies for analog-to-digital and digita..

  Preparing the list of tables

In the last board meeting, your supervisor has asked someone to build a list of tables for the Fernandos Skate Shop customer orders.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd