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.

View More Free Quizzes
Related BrainMass Solutions

  • Attachment from text

    Draw an E-R Diagram 2. State any assumptions that you made. Thank you. This E-R diagram says that each customer has a specific number, all of the orders have same promised date and ordered by the same customer.

  • Database Design Crow Diagram.

    498976 Database Design Crow Diagram. Draw an IE Crow's Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE and the 1:N relationship between them.

  • Dependency Diagrams

    ConceptDraw software has been used to draw the E-R diagrams that have been pasted into the word document. This solution answers a set of questions based on the dependency diagram. These questions include: 1.

  • Database Analysis: Data Modeling and E-R Diagrams

    235566 Database Analysis: Data Modeling and E-R Diagrams After completing a course in database management, you have been asked to develop a preliminary ERD for a symphony orchestra.

  • Data modeling tools

    The E-R diagram can also help us to identify inconsistencies. The process of constructing an E-R diagram also helps us to identify inconsistencies and uncover them.

  • Project Management Questions.

    Duration A 1 2 2 B 2 3 2 C 2 4 3 D 2 5 4 E 3 6 2 F 4 6 3 G 5 7 6 H 6 8 2 I 6 7 5 J 7 8 1 K 8 9 2 a. Draw a AOA network diagram representing the project.

  • ERD using MySQL modeling tool

    Use MS Visio to draw an entity-relationship diagram (ERD) for the JustLee Book database (reference the structure of the database in Figure in the Ppt presentation attached).

  • The Process of Conceptual Data Modeling

    Entity-Relationship (E-R) Diagram can become a primary model of conceptual database design.

  • This post addresses advanced information system issues.

    List and give an example of the three types of binary relationships other than the, (1:1), (1:N), or (N:M) Draw both a traditional E-R diagram and an IE Crow's Foot E- R diagram for each. Solution in attached Word document.

View More Related Solutions