Create an er diagram, Create an E-R diagram with all

Create an er diagram

Assignment Help Data Structure & Algorithms

Reference no: EM1380413

Question: Create an E-R diagram with all appropriate notation for the following condition. 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: EM1380413

Questions Cloud

Question about binomial tree : A binomial tree of height O, Bo is a one node tree. A binomial tree of height k, Bk is formed through attaching a binomial tree, Bk-1 to root of another binomial tree another binomial tree Bk-1.

Communication in organizations : Describe the role and importance of communication in the manager's job and

Explain the concept of dns : Assume your job is to support desktop computers in a small corporation of 32 workers. A consulting company is setting up a private Web server to be used internally by company workers.

Complete binary tree : Think about 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.

Create an er diagram : Create an E-R diagram with all appropriate notation for the following condition. In a particular fruit growing region there are a number of orchards.

Create a flowchart to determine the cause of problems : Assume you are the 1st level help desk technician at a average sized corporations. Your job is to handle the initial calls from corporation computer users with personal computer related problems.

Write a script that checks the day of the week : Write a script that checks the day of the week, and takes one of two actions depending on the day. If the day is Monday through Friday, print the name of the day.

Business professionals to avoid unethical behaviour : When we realise that the interaction of all three(the law, politics and ethics can influence our wallets our ability to purchase a home as well as our children's or grandchildren's ability to live like we do is it our job as business professionals..

Illustrate what amount of safety stock would provide a stock : Illustrate what amount of safety stock would provide a stock-out risk of 3 percent. Assume normality.

User Account

All Pages