Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321

Accounts

AccountIDCustomerIDAccountTypeBalance
(→ Customers.CustomerID)
11Checking500.0
22Savings1000.0

Loans

LoanIDCustomerIDAmountInterestRateTermYears
(→ Customers.CustomerID)
1115000.06.05
2210000.05.53

Deposits

DepositIDAccountIDAmountDate
(→ Accounts.AccountID)
11500.02024-02-19 14:31:33
221000.02024-02-19 14:31:33

Transactions

TransactionIDAccountIDTypeAmountDate
(→ Accounts.AccountID)
11Deposit500.02024-02-19 14:31:33
22Withdrawal200.02024-02-19 14:31:33

Bank

BankNameHeadquarterLocationFoundedYearTotalAssetsNumberOfBranchesWebsiteURL
Example BankNew York20001000000.050https://www.examplebank.com/

Branch

BranchIDBankNameBranchNameAddressCityStateZipCode
(→ Bank.BankName)
1Example BankMain Branch123 Main StNew YorkNY10001
2Example BankEast Side Branch456 East AveNew YorkNY10010

BankingProducts

ProductIDBankNameProductNameDescriptionAnnualInterestRateMinimumDepositAmountMaximumDepositAmountBranchName
(→ Bank.BankName)(→ Branch.BranchID)
1Example BankHigh-Yield SavingsA high interest rate savings account with no monthly fees.1.01000.0None1
2Example BankCD SpecialCertificate of deposit offering a fixed annual percentage yield.2.51000.01000000.02