onLineShoppingMiniQuiz

onLineShoppingMiniQuiz - c) An assertion expressing the...

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

View Full Document Right Arrow Icon
Using the Eclectic Online Shopping Example, create solutions for the following: a) A view showing the loginName, firstName, lastName, orderCartId, and totalPrice of each order. b) A view showing the loginName, firstName, lastName, and total of all orders placed by each customer.
Background image of page 1

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

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

Unformatted text preview: c) An assertion expressing the fact that even though a customer can be related to many instances of orderCartInfo , a customer can have at most one shopping cart. d) A DDL statement to delete all inventoryItem s that have never appeared in an order....
View Full Document

This note was uploaded on 02/27/2011 for the course CSE 412 taught by Professor Davulcu,h during the Spring '08 term at ASU.

Page1 / 2

onLineShoppingMiniQuiz - c) An assertion expressing the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online