as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
design a database to keep track of an employees leave and holidays
user
the database should have three tables: 
1. employees - to store each employee's personal information such as name, address, department, etc. 
2. leaves - to store details such as leave type, duration and start/end dates of leave.
3. holidays - to store details such as holiday name, date and description. 

the database should also have relationships between the three tables, to keep track of each employee's leave and holiday transactions.
assistant