Task to do: i. Identify Entities with atleast 10 attributes per Entities. ii. Identify all relationship from the given Scenario iii. Generate Entity Relationship Diagram
Scenario – 1
In Farm Management System there are multiples farms having different sizes depending of land
allocated to each farm. Multiple vegetable and fruits can be grown to each farms. Multiple
seeds are allocated to farms depending on nature of farm houses (Fruits or Vegetable). Each
Seed is liable to produce different yield depending on number of seeds sowed in the farms.
Each Farm has different water requirement, depending on the type of crop different availability
of water is ensured to the farm. Each Farm have fixed plantation time frame depending on
nature of seed. Each Farm is having Farm Manager and different employees are allocated to
different farms. Record of Water given to particular Farm is recorded and progress of crop is
monitored on daily basis. Water is given at different interviews to crop as per requirement to
ensure optimal growth of crop. When crop is reap then it tracked that which farm has yielded
how many fruits / vegetables per acre, his is tracked through manual Form which is maintained
by employees allocated to Farm which store number of fruits / vegetables plucked from each
form per day.
Task to do:
i. Identify Entities with atleast 10 attributes per Entities.
ii. Identify all relationship from the given Scenario
iii. Generate Entity Relationship Diagram
Step by step
Solved in 2 steps with 1 images
