Draw e-r diagram which models online bookstore
Course:- Software Engineering
Reference No.:- EM1349773

Assignment Help
Assignment Help >> Software Engineering

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.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Software Engineering) Materials
Analyze the most commonly overlooked software development risks within an organization you work for, or with which you are familiar. In your analysis, explain what these ris
Consider a different SDLC Model (4 step or 12 step). Describe the events/tasks that would occur in each step if your company were to use this SDLC model instead. - 3 pages.
Provide a defence, on ethical grounds, for the decision to bid for the contract with a the estimated costs and identify the potential consequences to the project client of acc
Determine whether or not each expression will always evaluate to 1 (true). If not, briefly explain why (writing 1-2 sentences at most... keep it short!). Keep in mind that v
Design a screen layout using a CASE TOOL for the form(s) that will meet the user requirements. You may, if you feel necessary, produce a state transition diagram and/or an e
Describe each law and define the terms in each law and explain the law clearly and thoroughly. Illustrate your explanation with practical examples - with at least one examp
Define the term ‘use case' and explain the various types of actors in a Use Case. Explain the difference between the > and > relationships in use case diagrams
Create a package diagram of the problem domain layer using the communication diagrams and the CRUDE matrix through the use of graphical tools in Microsoft Word or Visio, or