Results 1 to 4 of 4
  1. #1
    satkk is offline Member
    Join Date
    Apr 2009
    Posts
    8
    Rep Power
    0

    Default problem in doing leave management

    Hi everybody
    Im doing an online leave mangement in JSP, as a demonstration, im calculating the leave only for a predefined month say march. But how can i proceed if some one wants leave on March 31, April 1.

    The scenario so far is.
    An employee can login and view his profile, in his profile he will be able to see his current leave status. say 5 official leave and 2 other.When he takes 1 official leave it will be decreased by 1. But im stuck when it comes to multiple months. How can design a database suiting my need.

    So far my db design is as follows
    AdminTable
    ----------
    admin_user====PK
    admin_passwor

    Employee register
    -----------------
    Employee_ID PK (Will be entered manually, since it will be given @ the time of joining).
    name
    username
    password
    contact_details
    -------------------

    Employee leave table
    --------------------

    employee_id FK
    official_leave
    other_leave-------------When he/she takes a leave it will be decreased by 1 or by the no of days. if it approaches zero it will show a message and let the user to contact admin for further assistance.Also if official_leave not equal to zero and other_leave equal to zero, the user can opt a leave under official_leave(dont know whether the whole thing is a blunder, but im a newbie pls help or suggest any ideas).

    But the system is only for a predefined month, my problem is when i deal with multiple months, how will be my database or how to change the database


    Thanks in advance.

  2. #2
    satkk is offline Member
    Join Date
    Apr 2009
    Posts
    8
    Rep Power
    0

    Default

    Finally i made it myself, anyway found this forum useful,
    Thanks

  3. #3
    gr8regis is offline Member
    Join Date
    Aug 2009
    Posts
    1
    Rep Power
    0

    Default Please forward me your SRS

    Hey,
    I am currently working in a project for which i will need your SRS and problem description on leave management system.
    I would appreciate if you would help me out.

    Thank you,
    Nikunj

  4. #4
    Join Date
    Aug 2009
    Posts
    21
    Rep Power
    0

    Default

    u have separate table called leavebank
    in which u add total leave for year
    and u allow a user to take a limited leave(5) for a month
    u can detect from the leave bank
    :) javadeveloper

Similar Threads

  1. Leave management System
    By anji4u_19 in forum Suggestions & Feedback
    Replies: 24
    Last Post: 04-05-2010, 07:03 PM
  2. problem in doing leave management
    By satkk in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 04-01-2009, 05:50 PM
  3. library management
    By jyothi.priyanka in forum New To Java
    Replies: 25
    Last Post: 03-11-2009, 06:11 PM
  4. database design for leave management system
    By anji4u_19 in forum JDBC
    Replies: 0
    Last Post: 08-26-2008, 12:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •