Database Managment

1) Please label the ER Diagram below. This ER diagram describes a soft drink company's plants, employees, and customers. You will find the necessary labels in the word blank below. You just need to put them in the proper place.

Here are some details about the soft drink company:

a) As with all businesses, customers are needed for the products that the company produces. The soft drink company has several soft drink products, e.g. colorless drinks like Fresca or Sprite, colas, and specialty soft drinks similar to Mountain Dew.

b) Each product is produced in one or more plants, and each plant can produce any of the products that the company sells.

c) The plants, of course, are staffed by many employees, and you can assume that the company has, perhaps, more than one plant in the same general location, so that employees may work in different plants.

Label the following ER diagram using the keywords below:

Customer, Has, Produces, Employee, Capacity, Address, ID, Product, Plant, WorksOn, Needs, Coordinates, Quantity