Scenario:
i have a table name children, fields are (PK,IDnumber,nameOfChild) - idnumber there is a foreign key.
for example idnumber = 222, which has 3 children. named lets say a,b,c so this is the table look like
children
PK IDnumber nameOfChild
1 222 a
2 222 b
3 222 c
in
java i make a class Children with fields pk,idnumber,name
when i fetch it to the database, it looks like this
List<Chidlren> children = <e.g. the database will return the Children classes of IDnumber = 222>
now we have 3 classes, the children size is 3;
the problem is, when i edit the children making the children of 222 to 2? (e.g. a & b only because c is mistakenly inputted).
(remember that it is now in the database the a,b,c)
> will i delete the idnumber = 222 in the database, table name children?(e.g a,b,c) and add back the 2? is this correct or is there any better idea in doing
this.
> how will i tell the table named children that i want to delete the child c? (not the sql on deleting) i mean the approach to tell the database.