Question

Create an Entity relationship diagram (ERD) conceptual model for this case.

VINEYARD HOLDINGS AND GRAPE VARIETIES VVI’s vineyard sources its wine from ten plots of land in separate locations from two acres to twenty acres. Each vineyard has its own unique name, such as Rattlesnake Canyon, Red Fox, Theresa’s, etc. and is either owned by VVI or by an independent third party. Each is managed by a single employee. No employee manages more than one vineyard. The location and size, measured in acres, of each vineyard is recorded. Each vineyard is dedicated to the growing of a single grape variety per vintage year. However, over time a particular vineyard may be replanted to a different grape variety, depending on market demand for particular types of wine. The winery maintains a record of these plantings. VVI currently grows six different grape varieties: Cabernet Sauvignon, Merlot, Zinfandel, Pinot Noir, Chardonnay, and Sauvignon Blanc. Information that is specific for each grape variety and must be recorded includes the juice conversion ratio, a measure of how much juice, on average, can be extracted from a given weight of a grape variety. The wine storage requirement, which is the type of storage container (typically either stainless steel tank or oak barrel) used to hold the juice while it ferments into wine, is also recorded for each grape variety, as is the wine aging requirement, which is the measure of how long the wine produced from the juice should be stored before bottling. Certain measures related to the grapes that vary with the specific vintage year harvest are also recorded including the vineyard the grapes come from, the total amount (weight) of grapes harvested, and the ripeness of the grapes (expressed in % sugar).

Answer 1

Below is the ER diagram of vineyard holding based on given description. It consist of 5 entities connected via 4 relationship. Each entity has certain set of attributes and primary key is mentioned as underlined attribute.

Cardinality of the ERD is shown in crow's foot notation.