Purchase Solution

Database Management: Draw an E-R Diagram

Not what you're looking for?

Ask Custom Question

Draw an E-R Diagram showing each entity, its attributes, and it relationships to the other entities. State any assumptions you make. Also Describe your usage of the mailing list, including the dates and subjects of the postings.

Bob's Bookworld is a wholesale supplier of textbooks to college bookstores. The company would like to develop a database to track customers orders. Textbooks are uniquely identified by an ISBN printed on their back cover and are also characterized by title, author name(s), subject and price. College bookstores are each assigned a unique Customer ID and are also characterized by their store name, address, and phone number. Each store is uniquely identified by an order number and also records the date the order was placed, subtotal, sales tax amount and order total. Orders can include multiple copies of a single textbook and/or different textbooks. For each textbook ordered, the quantity ordered should be recorded.

Purchase this Solution

Solution Summary

Help with drawing an E-R Diagram is given in the attached Word document.

Purchase this Solution

Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.