"The database should have three tables: \n1. Employees - to store each employees personal information such as name, address, department, etc. \n2. Leaves - to store details such as leave type, duration and start/end dates of leave.\n3. Holidays - to store details such as holiday name, date and description. \n\nThe database should also have relationships between the three tables, to keep track of each employees leave and holiday transactions."
Design a database to keep track of an employee’s leave and holidays?