Question: The database visualized in Figure 9-2 below is a partial representation of a relational database There are three tables/entities visible: Customer, Order and PaymentType. The

The database visualized in Figure 9-2 below is a partial representation

The database visualized in Figure 9-2 below is a partial representation of a relational database There are three tables/entities visible: Customer, Order and PaymentType. The primary key for the Customer table is the CustID column. The primary key for the Order table is the OrderNumber column. And the primary key for the PaymentType table is the PaymentType column. Notice the foreign key relationship between Order and Customer. Each row in the Order table has a value for the CustID column which corresponds to a CustID in the Customer table. The Order table has a foreign key column called PaymentType. For each row in the Order table there is a value in the PaymentType column that corresponds to a primary key in the PaymentType table in the PaymentType column. Tables rellated through Payment Type Order Payment Type First Prior Cust Name Name Customer Number Date ID Amount TaxTotalType 34 11/23/00 2242 $90.00 $5.85 $95.85 MC 235 11/23/00 9500 $12.00 $0.60 $12.60 VISA 236 11/23/00 1556 $ 50.00 $2.50 $52.50 VISA 237 11/23/00 2242 $75.00 $4.88 79.88 AMEX 238 11/23/00 2242$ 60.00 $3.90 $ 63.90MC 239 11/23/00 1035 $90.00 $450 $ 94.50 AMEX 240 11.23.00 9501 $50.00 $2.50 $52.50 VISA 241 11/200 1123 $120.00 $960 $129.60 242 11/24O0 9500 60.00 $3.00 S63.00 VISA 243 1124/00 4254 $ 90.00 $4.50 $94.50 VISA 244 11/24/00 9500 $24.00 $1.20 $25.20 VISA 245 11/24/00 2242 $ 12.00 50 78 $12.78 AMEX 246 11/24/00 4254 $ 20.00 $1.00$ 21.00 MC 247 11/24/00 2241 $50.00 $2.50 $52.50 ISA 48 11/24/00 4254 $12.00 $0.60 $12.60 AMEX 249 11/24/00 5927 $ 50.00 $250 $52.50 AME 250 11/24/00 2242 $12.00 $0.78 $12.78 M 251 11/24/00 9500 $ 15.00 $0.75 $15.75MC 252 11/24400 2242 $132.00 $858 $140.58 M 253 11/24/00 2242 $ 72.00$4.68$ 76.68 AMEX 2242 9500 Chin April 1556 Fracken Chrs MC MSA AMEX American Express Visa 9501 Black ChrisY 1123 WilliamsMary 2241 JonesChris Lee Diane Tables related through Cust ID FIGURE 9-2 Customer Order Database Using the visualized relational database information in Figure 9-2 below, answer the following questions 1. How many orders has April Chin made? 2. What is the value of April Chin's orders (not including taxes)? 3. Who is the most valuable customer in terms of the most dollars ordered (not including taxes)? Include the name, the number of orders and the sum of the order amounts (not including taxes) 4. Which payment type is the most popular in terms of number of orders? Include the payment description and the number of orders

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!

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Individual Case Analysis Four cases are available from Harvard (see first : Case pack of 4 cases available at: http://cb.hbsp.harvard.edu/cbmp/access/49960103 ). Answer each of these questions in...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

SEE problem 4.25 which is attached in pdf format. I need detailed and correct answer 148 PART TWO / Databases Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk...

1. Read the case study provided below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study,...

I. PROBLEMS: 1. (50 pts = 5 x 10 pts) Consider that the update operations below are applied to the COMPANY relational database schema (Figure 3.7 on p. 75 of the textbook "Fundamentals of Database...

a) What are the factors to be considered in the selection of location of a warehouse? (b) The warehouse is self-evidently a major company service department. Explain in detail, FIVE organisation...

If the perpetuity grows at 2% and there is a 9% annual return, what is the maximum amount you would pay for this investment?

All the following statements concerning nonrefundable tax credits are correct, except: a . Credit can only be used to offset tax liability b . Full amount is paid even if the tax liability is less...

- Insert a worksheet named PT1 as the last worksheet in the workbook. - Create pivot tables to produce the following analysis: - To Insert a pivot table using the Data Model, make the appropriate...

___ 24. I feel successful in life only if I have been able to balance my personal, family, and career requirements.

___ 25. I would rather leave my organization than accept a rotational assignment that would take me out of my area of expertise.

___ 23. I have been most fulfilled in my career when I have solved seemingly unsolvable problems or won out over seemingly impossible odds.