thanks a lot for all the help this far. i will definitely link the assessment entity to one of the entities and notify you and also include the username and password attributes for the staff and student entities.

My main point of concern now is the functionality of the system based on the tasks that the system sets out to achieve. last year i created a helpdesk with sql server 2000, dreamweaver,asp 3.0 and it was ok with little functionalities. the problem here is that i linked up the database to the user interface thru dreamweaver and IIS and most of the asp scripts were generated my dreamweaver so i never really did that much of the asp coding myself and even with the sql statements i got quite a lot of help from dreamweaver and its self generating scripts but i dont think it'll be a gud idea to do that for a final year project as i have to do the scripting myself.

Now id start off by getting familiar with the sql statements for adding values to the various functions i outline which will also be the system functionalities.Another problem is this, since id be using dreamweaver in creating the GUI, well im wondering where id write those statements....Id need some little help on how to view a students assessment and also assign them one.....

thanks a lot for all so far...