Branch

idnameaddressphoneNumber
1Main Branch123 Main St1234567890
2West Branch456 West St0987654321
3East Branch789 East St1357924680
4North Branch012 North St2468017539
5South Branch345 South St3546801279

Online_Bank

idbankNamewebsiteemail
1ABC Bankwww.abcbank.cominfo@abcbank.com
2XYZ Bankwww.xyzbank.comcontact@xyzbank.com

Services_Offered

idserviceName
1Checking
2Savings
3Loan
4Investment
5Insurance

Accounts

idaccountNumberbalancebranchIdonlineBankId
(→ Branch.id)(→ Online_Bank.id)
11234567891000.01None
22345678902000.021
33456789013000.032
44567890124000.041
55678901235000.052

Transactions

idtransactionDateamountdescriptionaccountIdserviceId
(→ Accounts.id)(→ Services_Offered.id)
12021-01-01 10:00:00100.0Monthly fee11
22021-01-02 10:00:00500.0Deposit22
32021-01-03 10:00:00-200.0Withdrawal33
42021-01-04 10:00:00300.0Transfer44
52021-01-05 10:00:00400.0Payment55

Customers

idfirstNamelastNamedateOfBirthaccountId
(→ Accounts.id)
1JohnDoe1980-01-011
2JaneSmith1990-02-022
3MichaelJackson1970-03-033
4EmmaWatson1995-04-044
5LeonardoDiCaprio1974-05-115