Draw e-r diagram which models online bookstore

Assignment Help Software Engineering

Reference no: EM1349773

Q1) Draw the E-R diagram which models an online bookstore.

a. List the entity sets and their primary keys.

b. Suppose the bookstore adds music cassettes and compact disks to its collection. The same music item may be present in cassette or compact disk format, with differing prices. Extend the E-R diagram to model this addition, ignoring the effect on shopping baskets.

c. Now extend the E-R diagram, using generalization, to model the case where a shopping basket may contain any combination of books, music cassettes, or compact disks.

Reference no: EM1349773

Questions Cloud

Determining the traditional costing-activity based costing : K's Cornerspot, a popular university eatery in a competitive market, has seating & staff capacity to serve about 600 lunch customers every day. For the past 2 months, demand has fallen from its previous near-capacity level. Concerned about his dec..

Determine sales volume in units : Excalibur company has created a model to predict sales revenues for its line of beach towels and swimwear based on long-range weather forecasts.

Team group conflict : Is conflict something to avoid or embrace and use examples from either your personal experience or from the literature that would support your position.

Explain advertising plans to follow the general marketing : Explain Advertising plans have to follow the general marketing plan which often tries to predict how markets will change

Draw e-r diagram which models online bookstore : Draw the E-R diagram which models an online bookstore. List entity sets and their primary keys. Assume the bookstore adds music cassettes and compact disks to its collection.

Explain what are the implicattions of conflicts of interest : Conflict - Explain what are the implicattions of conflicts of interest, and how do they impact corporations?

Write down an expression for the displacement as a function : Standing on ground 3.5 from the wall of a building, you want to throw a package from your 1.6 shoulder level to someone in a second-floor window 4.5 above the ground.

Explain how do economists the absolute and relative sizes : Explain how do economists distinguish between the absolute and relative sizes of the public debt. Why is the distinction important.

Cost scheduling : A restaurant operates with two full-time employees who work eight hours per day. The rest of the employees are part-time employees who are scheduled for four hours shifts.

User Account

All Pages