I really need help & i wish someone could help me
I am required to design an Advisory System which models the academic advisor and advisee system used in any university. An advisor lecturer may have one or more advisees (students). An advisee can have only one advisor. The advisory system must be able to perform the following functions:
1.List all advisors and advisees
2.Search advisor or advisee by name or ID
3.List the details of a selected advisee or advisor
4.For a selected advisee, his/her advisor must be shown
5. For a selected advisor, all his/her advisees must be shown
5.Create, modify, and remove advisor or advisees particulars
6**Note that changing advisor should change the advisee at the same time, and vice versa.
7**Removing advisor from the system should set all relevant advisees advisor to blank/null.
i hope anyone could help me plzZz ....