Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Make a list of customers with the list of orders and the amount of dollars that they paid for each of their orders.   Make a list of customers with the total amount of dollars that they paid for all their orders combined (for each customer).

Make a list of customers with the list of orders and the amount of dollars that they paid for each of their orders.   Make a list of customers with the total amount of dollars that they paid for all their orders combined (for each customer).

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
  • Make a list of customers with the list of orders and the amount of dollars that they paid for each of their orders.

 

  • Make a list of customers with the total amount of dollars that they paid for all their orders combined (for each customer).

 

The image displays an Entity-Relationship (ER) diagram illustrating a database schema for a book ordering system. Below is a transcription of the tables and their attributes: ### CUSTOMERS Table - **Customer#**: Unique identifier for each customer - **Lastname**: Customer's last name - **Firstname**: Customer's first name - **Email**: Customer's email address - **Address**: Customer's physical address - **City**: City of the customer - **State**: State of the customer - **Zip**: Zip code of the customer - **Referred**: Indicates if customer was referred - **Region**: Region of the customer ### ORDERS Table - **Order#**: Unique order identifier - **Customer#**: Links to the CUSTOMERS table - **Orderdate**: Date the order was placed - **Shipdate**: Date the order was shipped - **Shipstreet**: Shipping street address - **Shipcity**: Shipping city - **Shipstate**: Shipping state - **Shipzip**: Shipping zip code - **Shipcost**: Cost of shipping ### ORDERITEMS Table - **Order#**: Links to the ORDERS table - **Item#**: Identifier for items in the order - **ISBN**: Links to the BOOKS table - **Quantity**: Number of items ordered - **Paideach**: Amount paid per item ### BOOKS Table - **ISBN**: Unique book identifier - **Title**: Title of the book - **Pubdate**: Publication date - **PubID**: Links to the PUBLISHER table - **Cost**: Cost price of the book - **Retail**: Retail price of the book - **Discount**: Discount on the book - **Category**: Category of the book ### BOOKAUTHOR Table - **ISBN**: Links to the BOOKS table - **AuthorID**: Links to the AUTHOR table ### AUTHOR Table - **AuthorID**: Unique author identifier - **Lname**: Author's last name - **Fname**: Author's first name ### PUBLISHER Table - **PubID**: Unique publisher identifier - **Name**: Name of the publisher - **Contact**: Contact person at the publisher -
Transcribed Image Text:The image displays an Entity-Relationship (ER) diagram illustrating a database schema for a book ordering system. Below is a transcription of the tables and their attributes: ### CUSTOMERS Table - **Customer#**: Unique identifier for each customer - **Lastname**: Customer's last name - **Firstname**: Customer's first name - **Email**: Customer's email address - **Address**: Customer's physical address - **City**: City of the customer - **State**: State of the customer - **Zip**: Zip code of the customer - **Referred**: Indicates if customer was referred - **Region**: Region of the customer ### ORDERS Table - **Order#**: Unique order identifier - **Customer#**: Links to the CUSTOMERS table - **Orderdate**: Date the order was placed - **Shipdate**: Date the order was shipped - **Shipstreet**: Shipping street address - **Shipcity**: Shipping city - **Shipstate**: Shipping state - **Shipzip**: Shipping zip code - **Shipcost**: Cost of shipping ### ORDERITEMS Table - **Order#**: Links to the ORDERS table - **Item#**: Identifier for items in the order - **ISBN**: Links to the BOOKS table - **Quantity**: Number of items ordered - **Paideach**: Amount paid per item ### BOOKS Table - **ISBN**: Unique book identifier - **Title**: Title of the book - **Pubdate**: Publication date - **PubID**: Links to the PUBLISHER table - **Cost**: Cost price of the book - **Retail**: Retail price of the book - **Discount**: Discount on the book - **Category**: Category of the book ### BOOKAUTHOR Table - **ISBN**: Links to the BOOKS table - **AuthorID**: Links to the AUTHOR table ### AUTHOR Table - **AuthorID**: Unique author identifier - **Lname**: Author's last name - **Fname**: Author's first name ### PUBLISHER Table - **PubID**: Unique publisher identifier - **Name**: Name of the publisher - **Contact**: Contact person at the publisher -
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS