| ClientID | FirstName | LastName | EmailAddress | PhoneNumber |
|---|---|---|---|---|
| 1 | John | Doe | john@example.com | 1234567890 |
| 2 | Jane | Smith | jane@example.com | 0987654321 |
| 3 | Alice | Brown | alice@example.com | 1122334455 |
| 4 | Bob | White | bob@example.com | 6543211234 |
| 5 | Charlie | Black | charlie@example.com | 5566778899 |
| AccountID | ClientID | Balance |
|---|---|---|
| (→ Clients.ClientID) | ||
| 1 | 1 | 1000.0 |
| 2 | 2 | 2000.0 |
| 3 | 3 | 3000.0 |
| 4 | 4 | 4000.0 |
| 5 | 5 | 5000.0 |
| SolutionID | Name |
|---|---|
| 1 | Mobile Banking App |
| 2 | Internet Banking Platform |
| OptionID | OptionName |
|---|---|
| 1 | Biometric Authentication |
| 2 | Password Authentication |
| ConnectionID | AccountID | SolutionID | OptionID |
|---|---|---|---|
| (→ Accounts.AccountID) | (→ Digital_Solutions.SolutionID) | (→ Sign_in_Options.OptionID) | |
| 1 | 1 | 1 | 1 |
| 2 | 1 | 1 | 2 |
| 3 | 2 | 2 | 1 |
| 4 | 2 | 2 | 2 |
| 5 | 3 | 1 | 1 |
| TransactionID | AccountID | Amount | Date |
|---|---|---|---|
| (→ Accounts.AccountID) | |||
| 1 | 1 | 100.0 | 2024-03-13 16:00:36 |
| 2 | 1 | -50.0 | 2024-03-13 16:00:36 |
| 3 | 2 | 200.0 | 2024-03-13 16:00:36 |
| 4 | 2 | -100.0 | 2024-03-13 16:00:36 |
| 5 | 3 | 300.0 | 2024-03-13 16:00:36 |