Explore BrainMass
Share

# Draw an E-R Diagram

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

https://brainmass.com/computer-science/trees/draw-an-e-r-diagram-184278

#### Solution Summary

This Solution contains an Orchard E-R Diagram graphic.

\$2.19

## Drawing an entity relationship diagram

1. Draw the entity relationship diagram for the relationship between EMPLOYEE and JOB.

Employee

EMP_CODE | EMP_LNAME | JOB_CODE

14 Rudell 2
16 Ruellardo 1
17 Smith 3
20 Smith 2

Benefit

EMP_CODE | PLAN_CODE
15 2
15 3
16 1
17 1
17 3
17 4
20 3

Job

JOB_CODE | JOB_DESCRIPTION
1 Clerical
2 Technical
3 Managerial

Benefit

Plan

PLAN_CODE | PLAN_DESCRIPTION
1 Term Life
2 Stock Purchase
3 Long-life disability
4 Dental

View Full Posting Details