Purchase Solution

Entities and Relationship Diagrams: Example Problem

Not what you're looking for?

Ask Custom Question

For each following statement, please give the corresponding E-R diagram (entities and relationship), and the structural constraints (Cardinality and Participation).

a) A supplier supplies certain number parts for a project, a project uses the parts from the different suppliers, and the same kind parts from different suppliers are used by different projects.

b) Some employees may be a supervisor of some other employees.

Purchase this Solution
Solution Summary

Provides a solution to the questions.

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

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.

C# variables and classes

This quiz contains questions about C# classes and variables.

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

  • Database Concept

    Entity-relationship diagrams don't show single entities or single instances of relations. Rather, they show entity sets and relationship sets (displayed as rectangles and diamonds respectively). Example: a particular song is an entity.

  • Entity-Relationship Diagrams

    Entity-Relationship Diagrams (ERD's) are a graphical representation between different entities (things, or objects that have properties, or attributes) and are the starting point for developing and implementing the actual database in whatever software

  • Data Modeling Tools in Microsoft Access Database

    An example of a data-modeling tool is with the Entity-Relationship model, which had one of the most common and useful components of a data modeling methodology - the Entity-Relationship diagram.

  • This post addresses advanced information system issues.

    Discuss the following elements as they relate to the Entity-Relationship Model: Entities, Attributes, Identifiers, and Relationships. Question 2.

  • Database Design Crow Diagram.

    Hi there, ** Please see the attached file for the IE crow's foot entity relationship diagram for the given scenarios ** Problem definition Database design crow diagram Draw an IE Crow's Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE

  • Entity Relationship

    OTA, 104038 Relationship between entities, 1NF and Data model of ER is discussed.

  • The Process of Conceptual Data Modeling

    Database designers find E-R diagrams useful tools in demonstrating the relationships between an organization's entities.

  • Dependency Diagrams

    Rename attributes to meet the naming conventions, and create new entities and attributes as necessary. 6- Using the results of Problem 5, draw the Crow's Foot ERD.

  • Mangement Analysis: Entity Relationship Diagram

    ER-diagrams have three basic elements including entities, attributes and relationships. Entities are the things for which, information is stored. Thus, an entity can be a person, place or event.

View More Related Solutions