Thanks for the reply, I upload two images that describe the question. This is question 6.21 of the book "Database system concepts, 7th edition".

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

Thanks for the reply,

I upload two images that describe the question.

This is question 6.21 of the book "Database system concepts, 7th edition".

Thanks :0

 

6.21
Consider the E-R diagram in Figure 6.30, which models an online bookstore.
a. Suppose the bookstore adds Blu-ray discs and downloadable video to its
collection. The same item may be present in one or both formats, with dif-
fering prices. Draw the part of the E-R diagram that models this addition,
showing just the parts related to video.
b.
Now extend the full E-R diagram to model the case where a shopping bas-
ket may contain any combination of books, Blu-ray discs, or downloadable
video.
Transcribed Image Text:6.21 Consider the E-R diagram in Figure 6.30, which models an online bookstore. a. Suppose the bookstore adds Blu-ray discs and downloadable video to its collection. The same item may be present in one or both formats, with dif- fering prices. Draw the part of the E-R diagram that models this addition, showing just the parts related to video. b. Now extend the full E-R diagram to model the case where a shopping bas- ket may contain any combination of books, Blu-ray discs, or downloadable video.
author
publisher
name
патe
address
address
URL
phone
URL
customer
етail
written_by
пате
published_by
address
phone
book
|питber
ISBN
title
shopping_basket
basket_of
уear
сontains
basket_id
price
пиmber
warehouse
code
stocks
address
phone
Figure 6.30 E-R diagram for modeling an online bookstore.
Transcribed Image Text:author publisher name патe address address URL phone URL customer етail written_by пате published_by address phone book |питber ISBN title shopping_basket basket_of уear сontains basket_id price пиmber warehouse code stocks address phone Figure 6.30 E-R diagram for modeling an online bookstore.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY