1- What gift will a customer who orders the book Shortest Poems receive? Use the actual book retail value to determine the gift. the author name. 2- Identify the authors of the books Becca Nelson ordered. Perform the search using the customer name

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
icon
Related questions
icon
Concept explainers
Question

1- What gift will a customer who orders the book Shortest Poems receive? Use the actual book
retail value to determine the gift.
the author name.

2- Identify the authors of the books Becca Nelson ordered. Perform the search using the customer name

 

The diagram illustrates an Entity-Relationship (ER) model of a database system that could be used for a bookstore. This ER model consists of several entities, each represented by a rectangle, and the relationships among them. Here is a detailed breakdown of each component:

1. **CUSTOMERS**
   - Attributes:
     - Customer#
     - Lastname
     - Firstname
     - Email
     - Address
     - City
     - State
     - Zip
     - Referred
     - Region

2. **ORDERS**
   - Attributes:
     - Order#
     - Customer#
     - Orderdate
     - Shipdate
     - Shipstreet
     - Shipcity
     - Shipstate
     - Shipzip
     - Shipcost

3. **ORDERITEMS**
   - Attributes:
     - Order#
     - Item#
     - ISBN
     - Quantity
     - Paideach

4. **BOOKS**
   - Attributes:
     - ISBN
     - Title
     - Pubdate
     - PubID
     - Cost
     - Retail
     - Discount
     - Category

5. **BOOKAUTHOR**
   - Attributes:
     - ISBN
     - AuthorID

6. **AUTHOR**
   - Attributes:
     - AuthorID
     - Lname
     - Fname

7. **PUBLISHER**
   - Attributes:
     - PubID
     - Name
     - Contact
     - Phone

8. **PROMOTION**
   - Attributes:
     - Gift
     - Minretail
     - Maxretail

**Relationships:**

- The **CUSTOMERS** entity is linked to **ORDERS** through the Customer# attribute, indicating that a customer can place multiple orders.
- **ORDERS** is related to **ORDERITEMS** by the Order# attribute, showing that an order can contain multiple items.
- **ORDERITEMS** is connected to **BOOKS** through the ISBN attribute, suggesting that each order item is a book.
- The **BOOKS** entity is associated with **BOOKAUTHOR** via the ISBN, linking books to their authors.
- **BOOKAUTHOR** connects to **AUTHOR** through the AuthorID, detailing which author wrote which book.
- **BOOKS** also relates to **PUBLISHER** through the PubID, indicating the publisher of each book.
- The **PROMOTION** entity seems to
Transcribed Image Text:The diagram illustrates an Entity-Relationship (ER) model of a database system that could be used for a bookstore. This ER model consists of several entities, each represented by a rectangle, and the relationships among them. Here is a detailed breakdown of each component: 1. **CUSTOMERS** - Attributes: - Customer# - Lastname - Firstname - Email - Address - City - State - Zip - Referred - Region 2. **ORDERS** - Attributes: - Order# - Customer# - Orderdate - Shipdate - Shipstreet - Shipcity - Shipstate - Shipzip - Shipcost 3. **ORDERITEMS** - Attributes: - Order# - Item# - ISBN - Quantity - Paideach 4. **BOOKS** - Attributes: - ISBN - Title - Pubdate - PubID - Cost - Retail - Discount - Category 5. **BOOKAUTHOR** - Attributes: - ISBN - AuthorID 6. **AUTHOR** - Attributes: - AuthorID - Lname - Fname 7. **PUBLISHER** - Attributes: - PubID - Name - Contact - Phone 8. **PROMOTION** - Attributes: - Gift - Minretail - Maxretail **Relationships:** - The **CUSTOMERS** entity is linked to **ORDERS** through the Customer# attribute, indicating that a customer can place multiple orders. - **ORDERS** is related to **ORDERITEMS** by the Order# attribute, showing that an order can contain multiple items. - **ORDERITEMS** is connected to **BOOKS** through the ISBN attribute, suggesting that each order item is a book. - The **BOOKS** entity is associated with **BOOKAUTHOR** via the ISBN, linking books to their authors. - **BOOKAUTHOR** connects to **AUTHOR** through the AuthorID, detailing which author wrote which book. - **BOOKS** also relates to **PUBLISHER** through the PubID, indicating the publisher of each book. - The **PROMOTION** entity seems to
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Query Syntax
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
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