Agriculture Nursery ER Diagram depicts that the important entities of this particular company are Employee, Worker, Green House, Planting Cycle, Plant, Tool, and more. As depicted in the entity-relationship diagram below, Green House has relationships like Green_House_Name, Manager_Serial_Number, Area, etc. Plants will have relationships like Name, Type, Cost, Duration, Reproduction_Method, and Selling_Price. Employees will have First_Name, Last_Name, Birth_Date, Serial_Number, and more. The ER diagram of the Agriculture Nursery shows that there can be two types of Employees, Salaried and Hourly_Paid Employees. Such ER diagrams help understand how the organization performs and who all are responsible for any particular activity.
