For on-line leave application

Hi Is there anyone who can give me the idea reagrding on-line leave application system .

Please tell me the entire step for this that creation of table regarding emlployee , leave and the department .

My actual question

  1. How the Data should be fetched from that table and display

    on the form .

  2. How the entire data should be maintained in that table.

  3. How the data should be updated in the table ( Data updation can be done on Daily basis and Monthly basis.

  4. what extra care should be taken in the preparation of table

  5. table is prepared by me in that case very first how the data is enterd to that table , in that case i have a master table for employee in my database should i use that one or what ?

i am very confused , please help me out …

Thanks to all…!

Subject: Ignore