How to draw an e-r diagram

Assignment Help Computer Engineering

Reference no: EM1336272

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.

Reference no: EM1336272

Questions Cloud

Define an n-node complete binary tree t : define an n-node complete binary tree T, where n=2^d - 1 for some d. Each node v of T is labeled with a real number x_v. You may assume that the real numbers labeling the nodes are all distinct.

Illustrate what happens to the natural rate of unemployment : Illustrate what happens to the natural rate of unemployment and potential GDP if cyclical unemployment.

Decision of an organization : Global Human Resources - How are human resource systems such as staffing systems impacted by the decision of an organization to operate in multiple countries

Imprtant proposals : Why are proposals important? What do you think should be included in proposals?

How to draw an e-r diagram : desirn an E-R diagram with all appropriate notation for the following situation. In a particular fruit-growing region there are a number of orchards.

Explain examples of qualitative success indicators : Explain examples of qualitative success indicators that would to incorporate in a strategic plan for HP

Desktop pc and a computer suitable as a web server : This solution provides the learner with an understanding of two and 3 tierd architectures and explains the role of each architecture. Futher this solution explain the main differences between a desktop PC and a computer suitable as a web server.

Budgeting plans to track actual data on project progress : What are some of the ways that a project manager can use budgeting plans to track and compare actual data on project progress?

Human resource management plan : Prepare documentation for human resource professionals to manage deputy probation officers in the U.S. I need for these materials to assist HR professionals in choosing, training, and developing sucessful probation officers for a department.

User Account

All Pages