Ceo

ceoIDfirstNamelastName
1JohnDoe
2JaneSmith
3MichaelJohnson
4EmilyWilliams
5DavidBrown

Board_of_directors

boardIDdirectorFirstNamedirectorLastNameceoID
(→ Ceo.ceoID)
1AliceWright1
2RobertMartinez2
3LindaTaylor3
4ThomasHarris4
5LauraGarcia5

Banks

bankIDbankNamebranchNumberceoIDboardID
(→ Ceo.ceoID)(→ Board_of_directors.boardID)
1Bank A10011
2Bank B20022
3Bank C30033
4Bank D40044
5Bank E50055

Customers

customerIDcustomerNameaccountNumberbankID
(→ Banks.bankID)
1Customer A9876543211
2Customer B1234567892
3Customer C9999999993
4Customer D8888888884
5Customer E7777777775

Accounts

accountIDaccountTypebalancecustomerID
(→ Customers.customerID)
1Checking1000.01
2Savings500.02
3Money Market2000.03
4CD10000.04
5IRA5000.05

Transactions

transactionIDamounttypedateaccountID
(→ Accounts.accountID)
1500.0Deposit2024-02-19 14:16:121
2-200.0Withdrawal2024-02-19 14:16:122
3300.0Transfer2024-02-19 14:16:123
4-400.0Withdrawal2024-02-19 14:16:124
5500.0Deposit2024-02-19 14:16:125