There are employees in an organisation.Each employee has one manager to report.Employees can request for a leave on particular date.Manager has to approve/reject the leave.
*Employee enters his EMPID and he can apply for a leave request (or) he can check the status of applies leave.(leave from,leave to,type of leave needs to enter while applying for a lave)
*Manager enters his ID and he can see the list of leave requests.The list should contain EMPNAME,PERIOD TYPE OF LEAVE and ACTION(Approv/Reject)
*Assumption:Two Master data table for Employees and Manager
How many tables can be created for the issue and their fields?
Which fields can be taken as Primary and foriegn key?
October 5, 2007 8:57 PM
October 5, 2007 9:01 PM