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?