I need the answer as soon as possible 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 bepresent in one or both formats, with differing prices. Extend the E-R diagram to model this addition, ignoringthe 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 anycombination of books, Blu-ray discs, or downloadable video.authorpublishermameaddressnameaddressURLphoneURLcustomerwritten_byemailpublished_bynameaddressphonebooknumberISBNtitleyearpriceshopping basketbasket_idbasket_ofcontainsnonberwarehousecodeaddressphonestocks

Answered: Image /qna-images/answer/f429317e-863e-4df7-b5d0-ab5b62e9c8b4.jpg

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

See similar textbooks

Similar questions

In your own words, explain In what way INTERPOL works? Write in 200 words.
Linear vs. differential cryptanalysis: what's the difference?
They are a small, close-knit family of his. Do you think you could give a brief explanation of each?
shortly,step by step and without notes please
The following is a message encrypted using multiplicative cipher but you do not know the key. Decrypt the message and show all your work. VNY LYQ EHH VNY TSD DYL YRO YSR VNY KWL HTJ YVK YYR NEF SRI QWM YVN SRI VWQ EUE RTN EFS RIV WQE UQW MYV NSR I
Which keys are there? explains everything?
The roughly 8 billion people in the world want to each randomly choose two N-digit primes to use for RSA communication. How big should N be to make this (likely) secure against a gcd attack, so that none share a prime? Explain. Cryptography Thank you!