relationships for lms

1
Relationships for LMS 03 June 2015 Department_Table Employee_Master_Table Grade_No_Table Leave_Balance_Table Leave_Master_Table Leave_Transaction_Table Department_Code Department_Name Head_Of_Department No_Of_Employees Phone_No1 Phone_No2 Location Emp_Code Emp_Name Gender Address Date_Of_Birth Email Phone_No Dept_Code Grade_No Designation Qualification No_Of_Years_Experience Date_Of_Joining Grade_No Grade_Desc Effective_Date Serial_No Emp_Code Department_Code Leave_Code Leave_Balance Total_Leave_Balance Leave_Code Leave_Desc No_Of_Days Grade_No Trans_No Emp_Code Department_Code Leave_Code Start_Date End_Date No_Of_Days Reason_For_Leave Approval_Authorization

Upload: sayanna-hyd

Post on 14-Sep-2015

212 views

Category:

Documents


0 download

DESCRIPTION

rela

TRANSCRIPT

  • Relationships for LMS

    03 June 2015

    Department_Table

    Employee_Master_Table

    Grade_No_Table

    Leave_Balance_TableLeave_Master_Table

    Leave_Transaction_Table

    Department_Code

    Department_Name

    Head_Of_Department

    No_Of_Employees

    Phone_No1

    Phone_No2

    Location

    Emp_Code

    Emp_Name

    Gender

    Address

    Date_Of_Birth

    Email

    Phone_No

    Dept_Code

    Grade_No

    Designation

    Qualification

    No_Of_Years_Experience

    Date_Of_Joining

    Grade_No

    Grade_Desc

    Effective_Date

    Serial_No

    Emp_Code

    Department_Code

    Leave_Code

    Leave_Balance

    Total_Leave_Balance

    Leave_Code

    Leave_Desc

    No_Of_Days

    Grade_No

    Trans_No

    Emp_Code

    Department_Code

    Leave_Code

    Start_Date

    End_Date

    No_Of_Days

    Reason_For_Leave

    Approval_Authorization