Consider the following UML diagram which models an online bookstore. a. Convert the UML model to ER design. b. List the entity sets and their primary keys. c. 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 differing prices. Extend the E-R diagram to model this addition, ignoring the effect on shopping baskets. n, to madel Now extend the E-R diágram, using generalization, to model the case where a shopping basket may contain an combination of books, Blu-ray discs, or downloadable video. author publisher mae address URL name address phone URL customer written_by email published_by nam address phone book number ISBN title shopping basket basket_id basket of year contains price number warehouse code address phone stocks
Consider the following UML diagram which models an online bookstore. a. Convert the UML model to ER design. b. List the entity sets and their primary keys. c. 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 differing prices. Extend the E-R diagram to model this addition, ignoring the effect on shopping baskets. n, to madel Now extend the E-R diágram, using generalization, to model the case where a shopping basket may contain an combination of books, Blu-ray discs, or downloadable video. author publisher mae address URL name address phone URL customer written_by email published_by nam address phone book number ISBN title shopping basket basket_id basket of year contains price number warehouse code address phone stocks
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
Related questions
Question
I need the answer as soon as possible

Transcribed Image Text:Consider the following UML diagram which models an online bookstore.
a. Convert the UML model to ER design.
b. List the entity sets and their primary keys.
c. 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 differing prices. Extend the E-R diagram to model this addition, ignoring
the effect on shopping baskets.
rion, to madal d. Now extend the E-R diagram, using generalization, to model the case where a shopping basket may contain any
combination of books, Blu-ray discs, or downloadable video.
author
publisher
mame
address
name
address
URL
phone
URL
customer
written_by
email
published_by
name
address
phone
book
number
ISBN
title
year
price
shopping basket
basket_id
basket_of
contains
nonber
warehouse
code
address
phone
stocks
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 5 images

Knowledge Booster
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.Recommended textbooks for you

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education