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
Attorney is retained by one or more clients for each case, a client may have more than one attorney for each case. Determine its model.
Describe the difference between locally hosted infrastructure (ie. in an enterprise data centre) and infrastructure provided using an IaaS provider. What are the critical po
Translating detailed requirements into a design is the next very important step. An integrated set of computer-aided software engineering (CASE) tools can be very useful in
Describe each section of the dialogue box. Imagine, you are developing a web-based system for an airline. Sketch the dialog diagram for some sample screens that users will
A consultant is not necessarily a project leader, but they can only be project leader for one project. Draw an entity relationship model for the project management System.
Define how each software development methodology's history is affected by technology -  Describe the application and how it would meet its goals. What methodology is best sui
As a software engineer, what are the means of tracking you would use to track and monitor the reuse history of a component? Provide a rationale for the elements you list
Analyze the fundamental impact of IT architecture or enterprise architecture on information management for your chosen company or industry. Determine if IT architecture impa