Banks
id | name | location |
1 | ABC Bank | New York |
2 | XYZ Bank | California |
3 | LMN Bank | Texas |
4 | PQR Bank | Florida |
5 | STU Bank | Illinois |
Employees
id | first_name | last_name | bank_id |
| | | (→ Banks.id) |
1 | John | Doe | 1 |
2 | Jane | Smith | 2 |
3 | Mike | Brown | 3 |
4 | Emma | White | 4 |
5 | Tom | Black | 5 |
TrainingSessions
session_id | date | trainer_id | topic_id |
| | (→ Employees.id) | (→ Topics.id) |
1 | 2021-10-01 09:00:00 | 1 | 1 |
2 | 2021-10-08 09:00:00 | 2 | 2 |
3 | 2021-10-15 09:00:00 | 3 | 1 |
4 | 2021-10-22 09:00:00 | 4 | 2 |
5 | 2021-10-29 09:00:00 | 5 | 1 |
Topics
id | value |
1 | Customer Service Skills |
2 | Fraud Prevention |
3 | Interest Rate Management |
4 | Loan Processing |
5 | Investment Strategies |
Bank_Training
training_id | bank_id | employee_id |
| (→ Banks.id) | (→ Employees.id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
Bank_Training_Topics
bank_training_id | topic_id |
(→ Bank_Training.training_id) | (→ Topics.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 2 |
3 | 1 |
4 | 1 |
5 | 1 |