TypeID | TypeName | Services_Offered | InterestRate | MaxDepositAmount |
---|---|---|---|---|
1 | Branch | Balance | 2.0 | 100000.0 |
2 | Branch | ATM Access | 3.0 | 80000.0 |
3 | Online Bank | Balance | 2.5 | 75000.0 |
4 | Online Bank | Mobile App | 3.5 | 60000.0 |
5 | Credit Union | Loans | 1.5 | 90000.0 |
CustomerID | FirstName | LastName | PhoneNumber | BranchID | |
---|---|---|---|---|---|
(→ Branches.BranchID) | |||||
1 | John | Doe | john.doe@example.com | +1-555-123-4567 | 1 |
2 | Jane | Smith | jane.smith@example.com | +1-555-987-6543 | 2 |
3 | Alice | Brown | alice.brown@example.com | +1-555-765-4321 | None |
4 | Bob | White | bob.white@example.com | +1-555-456-7890 | None |
5 | Charlie | Black | charlie.black@example.com | +1-555-111-2222 | None |
AccountID | CustomerID | Balance | DateCreated | TYPEID |
---|---|---|---|---|
(→ Customers.CustomerID) | (→ Types.TypeID) | |||
1 | 1 | 5000.0 | 2021-01-01 | 1 |
2 | 2 | 10000.0 | 2021-02-01 | 1 |
3 | 3 | 20000.0 | 2021-03-01 | 3 |
4 | 4 | 30000.0 | 2021-04-01 | 3 |
5 | 5 | 40000.0 | 2021-05-01 | 5 |
TransactionID | AccountID | Amount | Date |
---|---|---|---|
(→ Accounts.AccountID) | |||
1 | 1 | 100.0 | 2021-01-15 |
2 | 1 | -50.0 | 2021-01-16 |
3 | 2 | 200.0 | 2021-02-15 |
4 | 2 | -100.0 | 2021-02-16 |
5 | 3 | 300.0 | 2021-03-15 |