Design a database to record employee salaries.
Here is a suggested design for a database to record employee salaries:

1. **Employee Table**: This table will store all the relevant information about an employee. Some of the fields in this table could include:

- Employee ID: An unique identifier for each employee.
- First Name: The employee's first name.
- Last Name: The employee's last name.
- Email: The employee's email address.
- Hire Date: The date the employee was hired.
- Department: The department the employee works in.

2. **Salary Table**: This table will store all the relevant information about an employee's salary. Some of the fields in this table could include:

- Salary ID: An unique identifier for each salary record
- Employee ID: The employee this salary record is for; this field should be a foreign key that references the Employee table.
- Salary Amount: The amount of the employee's salary.
- Start Date: The date this salary amount became effective.
- End Date: The date this salary amount stopped being effective (if there is no end date, then this salary amount is still in effect).
- Currency: The currency in which the salary is paid
- Payment Frequency: Whether the salary is paid weekly, bi-weekly or monthly.

With this design, you can record each employee's salary history, including changes in salary amount, currency and payment frequency, by adding a new record to the Salary table for each change. This way you can keep track of an employee's current salary as well as their salary history.
Below is an instruction that describes a task, write a response that appropriately completes the request.

### Instruction:
Design a database to record employee salaries.

### Response:
Here is a suggested design for a database to record employee salaries:

1. **Employee Table**: This table will store all the relevant information about an employee. Some of the fields in this table could include:

- Employee ID: An unique identifier for each employee.
- First Name: The employee's first name.
- Last Name: The employee's last name.
- Email: The employee's email address.
- Hire Date: The date the employee was hired.
- Department: The department the employee works in.

2. **Salary Table**: This table will store all the relevant information about an employee's salary. Some of the fields in this table could include:

- Salary ID: An unique identifier for each salary record
- Employee ID: The employee this salary record is for; this field should be a foreign key that references the Employee table.
- Salary Amount: The amount of the employee's salary.
- Start Date: The date this salary amount became effective.
- End Date: The date this salary amount stopped being effective (if there is no end date, then this salary amount is still in effect).
- Currency: The currency in which the salary is paid
- Payment Frequency: Whether the salary is paid weekly, bi-weekly or monthly.

With this design, you can record each employee's salary history, including changes in salary amount, currency and payment frequency, by adding a new record to the Salary table for each change. This way you can keep track of an employee's current salary as well as their salary history.