Computer Science Homework Solutions
Problem
#184278

Draw an E-R diagram

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

Solution
What is this?
By OTA - Overall OTA Rating
Charlene Li, MIWP (IP) - 4.4/5
Purchase Cost Now
$2.19 CAD (was ~$19.95)
Included in Download
  • Plain text response
  • Attached file(s):
    • OrchardERD.gif
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse