Course Hero Logo

assignment1.docx - 1. Which tables and fields would you...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 3 pages.

1. Which tables and fields would you access to determine which book titles have beenpurchased by a customer and when the order shipped?
2. How would you determine which orders have not yet been shipped to the customer?
3. If management needed to determine which book category generated the most sales in April2009, which tables and fields would they consult to derive this information?
4. Explain how you would determine how much profit was generated from orders placed inApril 2009.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Wang,T
Tags

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture