Thankyou for replying futurity
Basically seed bank maintains seeds of different crops and SEED is an entity, not SEED BANK.Seeds of a particular are crops are saved and given a unique accession ID and location(row no.,column no. ,rack).These seeds are tested through germination after a certain time period to make a record that how much seeds are alive and how much are dead.Percentage of live seeds is reffered as germination percentage.When this percentage is less than 80% then these seeds are sent for multiplication.Organizations records the germination percentage of seeds,date of germination,employee who has performed germination,temperature maintained,light condition,no. of alive and dead seeds and in case of multiplication records the quantity before multiplication,quantity after multiplication of seeds,employee who multiplied the seeds ,date of sending seeds for multiplication and date when seeds were returned.
GERMINATION and MULTIPLICATION are performed for seeds.Now as far i know i have made the following entities:
>SEED(ACC ID,location,Crop ID)
>CROP(Crop ID,Crop local name,Crop Scientific name)
My problem is with GERMINATION and MULTIPLICATION.By gerund I mean associative entity.When i say that
>SEED are Tested by GERMINATION and
>SEED are Sent for MULTIPLICATION
Here Tested by and Sent for are associative entities or gerunds.
I have made it as follows:
>GERMINATION(G_ID,Temperature,light condition,no. of dead seeds,no. alive seeds,germ %age,need multiplication(y/n))
>MULTIPLICATION(M_ID,Acc_ID,E_ID,quantity received,quantity returned,date)
I dont know that it is right or not and can not understand that what will be attributes of Tested by and what will be attributes of GERMINATION ?Similarly what will be the attributes of Sent for and what will be attributes of MULTIPLICATION.I know that gerund will store date ,quantity and employee ID and this is all the data i gathered from organization.