{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

proflowers - From customer table order table product table...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
To : Mr. Sean Lancaster From : Madyson Halling, Ryan Hayes, Matt Mccormick, Aunna Matthiesen Date: Monday, February 08, 2010 Subject : BPM for Proflowers.com Online Process The purpose of this memo is to get a better understanding of Proflowers business, and to walk through thebusiness process for Proflowers.com ordering process. Proflowers Business Process for Online Ordering See attachment below. SQL for Proflowers Select count customer ID as “Hockey promotion orders”,
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: From customer table, order table, product table Where promotion code = “hockey” and customer.customerID = order.customerID and order.productID = product.productID Select fname, lname, shipping address, From customer table, order table Where ship date =#02/14/10# and customer.customerID = order.customerID Order by lname Proflowers Online Databases...
View Full Document

{[ snackBarMessage ]}