6.21
Consider the E-R diagram in Figure 6.30, which models an online bookstore.
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. Draw the part of the E-R diagram that models this addition, show just the parts related to video.
Now extend the full E-R diagram to model the case where a shopping basket may contain any combination of books, Blu-ray discs, or downloadable video.
Note that Blu_ray_discs
and downloadable_videos
are weak entities while video_in_bluray
and video_on_net
are the identifying relationships sets. video
is the identifying entity set and owns both of the weak entities.