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
Design Context diagram, level0 and level1 (if need) for the following: The user submit her/his name to the system, the system will tell the user if he is a boy or a girl or
ITEC150 - System Development and Data Management - The client organisation has conducted an evaluation study of the existing system to list all the existing system capabiliti
You are designing module which handles login and security for application. Create state diagram which explains the above actions. Make sure that you name each state and inclu
Prepare a table of entities and activities. - Draw a context diagram. - Prepare an annotated table of entities and activities. Indicate on this table the groupings, bubble nu
Which of the following items should not be included in the software project management plan? (a) The techniques and case tools to be used (b) Detailed schedules, budgets and
Using your knowledge of ATM operation, write Z schemas defining the state of the system, card validation (where the user's identifier is checked) and cash withdrawal.
Produce an E-R diagram, which documents the entities and relationships involved in the Retail outlet of a Stationary Shop which includes sales, purchases and inventory of
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