Question: 1. Which tables and fields would you access to determine which ISBN numbers of the books have been purchased by a customer and what is

1. Which tables and fields would you access to determine which ISBN numbers of the books have been purchased by a customer and what is the cost to ship the order? 2. How would you find out which books do not have any discount? 3. Which tables and fields need to be accessed to determine the total sales of all Computer books ordered in March of 2009? 4. How much profit is generated from orders that were placed in October, November and December of 2009. Remember to take in consideration that some books are ordered in multiple copies and profit is determined by the difference in retail price of the book and its cost. Also, some books on orders have discount. 5. Customer wants to know about the book published in 2005 by author Robinson. What is the access path (all tables and columns) to follow to find the list?

FIGURE 1-5 JustLee Books's table structures after normalization

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Which tables and fields would you access to determine which ISBN numbers of the books have been purchased by a customer and what is the cost to ship the order? 2. How would you find out which...

1. Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? 2. How would you determine which orders have not yet been...

If possible use Microsoft Visio or anything BUT handwritten diagrams for questions 6-10, please. Thank you! This is for my Oracle class. 1. Which tables and fields would you access to determine which...

Scenario Overview In this course, you will follow along as an employee for an online bookseller named JustLee Books. The company that you are employed with sells books via the internet with a...

In your first small project, Michael introduces you to basic database terminology and the process of how JustLee Books is designed as a database. He interprets Figure 1 . 5 ( will be a file...

Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet...

Which of the following is used to join data contained in two or more tables? a . primary key b . unique identifier c . common field d . foreign key Hands - On Assignments To perform assignments 1 to...

Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? How would you determine which orders have not yet been shipped to...

Please reference the above E - R Modeling table structures in your textbook page 1 1 Figure 1 - 5 or the above Figure 1 - 5 to briefly answer below questions . 1 . Which tables and fields would you...

Information from Sheppard Picture Frames cash account as well as the November bank statement is presented next. Cheque #210 was written for $600 to pay salaries. Requirements 1. Prepare the bank...

Use a computer algebra system to find the exact volume of the solid obtained by rotating the region bounded by the given curves about the specified line. 39. y = sin'x, y = 0, 0

Determine the language of the NPDAs: ( b ) = { 0 , 1 } and I = { $ , x } .

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

2-14 What types of information systems and business processes were used by Income before migrating to the fully digital system? NTUC Income (Income), one of Singapores largest insurers, has over 2...

2-10 In this exercise, you will learn how to use spreadsheet software to improve management decisions about selecting suppliers. You will filter transactional data on suppliers based on several...

2-9 Quincaillerie is a small family hardware store in Paris, France. The owners must use every square foot of store space as profitably as possible. They have never kept detailed inventory or sales...