Purchase Solution

Draw an E-R Diagram

Not what you're looking for?

Ask Custom Question

Draw an E-R diagram with all appropriate notation for the following situation. In a particular fruit-growing region there are a number of orchards. Each ORCHARD is identified by its LOCATION. In general, each orchard contains a large number of trees (assume that an orchard must contain at least one tree). A TREE entity has the attributes NUMBER (which is a serial number) and YEAR PLANTED. Each tree is a member of a single SPECIES (for example, apple, peach, and plum are species). A species is identified by a SPECIES NAME. Each species bears one or more varieties. For example, with grafted branches, an apple tree might bear two varieties: Yellow Delicious, and Jonathon. Each VARIETY is identified by a VARIETY NAME. Each variety is borne by exactly one species (thus for example, a Yellow Delicious apple can only be borne by an apple tree.). From the previous discussion, we can infer that each tree has one or more varieties. At a given time, a particular species may not have any trees as members, or have one or more trees. Similarly, a given variety may or may not be represented by trees at a given time.

Purchase this Solution
Solution Summary

This Solution contains an Orchard E-R Diagram graphic.

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.

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.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Networking Questions

This quiz consists of some basic networking questions.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

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

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

  • Important Information About Hasse Diagram

    ( a, b, c ) R ( d, e, f ) <-> a ≤ d, b ≤ e, c ≤ f, where ≤ denotes the usual "less than or equal to" relation for real numbers. Please demonstrate how to draw a Hasse diagram for this. I don't know how. Thanks.

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

  • E-R Diagram

    Draw an E-R diagram for this situation and place minimum and maximum cardinalities on the diagram. Please see the attached file.

  • Draw scatter diagram and find correlation coefficient

    A, B and C are in the sheet 1 and D, E are in sheet 2. The solution provides detailed explanation how to draw the scatter diagram and find correlation coefficient.

  • Analysis of AM circuit

    Draw a block diagram to aid your explanation. c. Draw the double-sided magnitude spectra of the signal at the output of the circuit (pin 6). d.

  • A car travels around a curve of radius R=100m at a constant speed of 30m/s

    Draw the free body diagram for the car (show the coordinate system you choose). e) At what angle must the road be banked to prevent the car from slipping? Please refer to the attached file for the complete and formatted solution.

View More Related Solutions