Explore BrainMass

Explore BrainMass

    Database Management: Draw an E-R Diagram

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com March 6, 2023, 1:09 pm ad1c9bdddf

    Solution Summary

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