problem in analysis phase for building shcool portal

i'm building a school portal and im stucked at analysis phase, the issue is :

in school portal there's a 开发者_如何转开发student profile and a parent profile, now the problem is how can i achieve a relationship between this two.Actually the scenario is "one dad can have multiple childrens studying in different school", now suppose "dad wants to look out the Result/Remarks of his all childrens" on what basis he can achieve that, this is my Question.

---

Child belongs to parent and school Parent has children School has children

To get the results he will have to be assigned children. He can claim 'ownership' of a child. An administrator in a school should be responsible for confirming or denying this, otherwise you have serious head aches.

---

The child should have a representation for who their father is.

Then retrieve based on that.

---

Parent --------------
            |       |
            |       |
          CHILD   CHILD has Parentid (foreign key) AND schoolid so u can bind child to parent and school
            |       |
            |       |
           EXAM    EXAM has id of Child (foreign key) so u can bind exam on child/student
            |       | 
            |       |  
          RESULTS RESULTS has id of Exam (foreign key) so u can bind results to exam1...*

Try solving it like this. Every parent can have multiple childs. Childs can do exams, exams have results. You can now acces data by asking the childs of a parent.

Select C.name From Child C, Parent P Where C.parentid = 1

You'd know the id of the parent, so u can then just query the Childs on that id. Like this a Child record will know who the parent is.

When you want to add up the option to put a Child on a school, and parent can have 1...* childs on different schools:

Table: Child has schoolid (fk).

• Parent registers to your system. Parent has in ID now.
• Parent can register multiple children with different id's aswell.
• Children can be registered for a school.
• Children can take different exams with results.