{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

onLineShoppingMiniQuiz

onLineShoppingMiniQuiz - c An assertion expressing the fact...

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 Document Right 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

{[ snackBarMessage ]}

Page1 / 2

onLineShoppingMiniQuiz - c An assertion expressing the fact...

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

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