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

Preliminary project plan for an important internal project

You have been hired by the Client to provide a preliminary Project Plan for an important internal project. Client staff support the project and have secured Board approval for

How to adapt for large-scale transnational it projects

What aspects of your project communications planning would you adapt for large-scale transnational IT projects in that the project teams and other stakeholders are geographi

Give difference between testing and debugging

You have just been hired as the testing guru for the CatchAllBugs.com Company. Your first task is to write a set of test cases to debug a small VB program. Unfortunately, yo

List the primary key and functional dependencies

List the primary key and functional dependencies in the following table, subject to the specified conditions. Convert this table to an equivalent collection o

Analyze the critical success factors

The IT department could not remove the old computers because there was no place to store them - Analyze the critical success factors, and state their conclusion and the lesson

Write python code to generate three lists of random numbers

DS 710 Homework 6 - R assignment. Write Python code to generate three lists of random numbers which model potential revenue: one list with 12 months of revenue using the curr

What more efficient by slightly changing the data structure

If the purpose of this search is to insert another item into the list, how would you achieve this insertion? In other words, give a pseudocode algorithm that lists each step

How would go about preventing unwanted eyes

the Director of Human Resources has a file documenting the pay rates of all employees. How will you prevent users on the network from actually being able to see the file on

Reviews

Write a Review

 
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!

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