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 |