Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please reference the above E - R Modeling table structures in your textbook page 1 1 Figure 1 - 5 or the above Figure 1

Please reference the above E-R Modeling table structures in your textbook page 11 Figure1-5 or the above Figure1-5 to briefly answer below questions.1. Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? (20 points)
2. How would you determine which orders have not yet been shipped to the customer? (20 points)
3. If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information? (20 points)
4. Explain how you would determine how much profit was generated from orders placed in April 2009.(20 points)
5. If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the customer's request? (20 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Structured Search For Big Data From Keywords To Key-objects

Authors: Mikhail Gilula

1st Edition

012804652X, 9780128046524

More Books

Students also viewed these Databases questions

Question

What is electric dipole explain with example

Answered: 1 week ago

Question

What is polarization? Describe it with examples.

Answered: 1 week ago

Question

=+j Understand different types of regions in the world.

Answered: 1 week ago