Purchase Solution

E-R Diagram

Not what you're looking for?

Ask Custom Question

Assume that at XYZ company each product (described by Product No., Description, and Cost) is comprised of at least three components (described by Component No., Description, and Unit of Measure) and components are used to make one or many products (that is, must be used in at least one product). In addition, assume that components are used to make other components and that raw materials are also considered to be components. In both cases of components being used to make products and components being used to make other components, we need to keep track of how many components go into making something else. Draw an E-R diagram for this situation and place minimum and maximum cardinalities on the diagram.

Purchase this Solution
Solution Summary

The expert examines an E-R diagram for XYZ Company.

Purchase this Solution
Free BrainMass Quizzes
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.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • This post addresses advanced information system issues.

    468348 Entity-Relationship Model: Entities, Attributes, Identifiers, and Relationships, and three types of binary relationships other than 1:1, 1:n, or N:M, traditional E-R diagram and IE Crow's foot E-R diagram. Question 1.

  • E-R Diagram for Airline Reservation Tables

    Student, Your E-R diagram with helpful text annotations is attached as a high-quality TIFF image and a more commonly used JPEG Solution is an E-R diagram with helpful text annotations as both a high-quality TIFF image and a more commonly used JPEG

  • Important Information About Hasse Diagram

    If (a,b,c)R(d,e,f), there is a directed path from (a,b,c) to (d,e,f).

  • 3NF database design based on functional dependencies

    Represent these attributes using an E-R diagram. Provide meaningful entity names.

  • The Process of Conceptual Data Modeling

    Sincerely, Your OTA An E-R diagram or Entity-Relationship diagram (ERD) has been considered as the primary model of conceptual database design due to the fact that it is a good demonstration of a conceptual data model.

  • 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.

  • 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 Management: Draw an E-R Diagram

    4735 Database Management: Draw an E-R Diagram Draw an E-R Diagram showing each entity, its attributes, and it relationships to the other entities. State any assumptions you make.

  • 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.

View More Related Solutions