Consider the diagram below that models an online bookstore. Hint: again consider specializations/generalizations and also include cardinality limits in your E-R portion.Ĥ. Note, you may exclude from your drawing the sets author, writtenby, publisher, and publishedby. 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. Hint: Your answer should consider specializations/generalizations.ī. Draw the part of the E-R diagram that models this addition, showing just the parts related to video.
The same item may be present in one or both formats, with differing prices.Ī. Suppose the bookstore adds Blu-ray discs and downloadable video to its collection.
