Financial_Institutions

idNameFounding_YearFounding_DecadeTotal_AssetsTotal_LiabilitiesROI_Percentage
1Bank A180019th century2000000.01500000.00.25
2Bank B196320th century1000000.0700000.00.15
3Bank C198820th century800000.0500000.00.12
4Bank D200021st century600000.0400000.00.1
5Bank E201021st century400000.0300000.00.08

Customers

idFirstNameLastNameDateOfBirthAddressPhoneNumberEmailAddressAccountId
(→ Accounts.id)
1JohnDoe1980-01-01123 Main St555-1234john.doe@example.com1
2JaneSmith1975-02-01456 Elm St555-5678jane.smith@example.com2
3AliceJohnson1990-03-01789 Oak St555-9012alice.johnson@example.com3
4MichaelWilliams1985-04-01135 Pine St555-1357michael.williams@example.com4
5EmilyTaylor1995-05-01246 Maple Ave555-2468emily.taylor@example.com5

Accounts

idCustomerIdTypeBalanceInterestRateOpenDate
(→ Customers.id)
11Checking1000.00.012021-01-01
22Savings5000.00.022021-02-01
33Checking2000.00.012021-03-01
44Savings15000.00.022021-04-01
55Checking3000.00.012021-05-01

Transactions

idFromAccountIdToAccountIdAmountTransactionTypeDate
(→ Accounts.id)(→ Accounts.id)
112200.0Transfer2021-01-15
221250.0Transfer2021-01-15
334100.0Transfer2021-03-15
443150.0Transfer2021-03-15
551300.0Deposit2021-05-15

Loans

idBorrowerIdLenderIdPrincipalAmountInterestRateTermYearsMonthlyPaymentStartDateEndDate
(→ Customers.id)(→ Accounts.id)
11110000.00.055211.232021-06-012026-06-01
2225000.00.043156.252021-07-012024-07-01
3338000.00.064228.02021-08-012025-08-01
4447000.00.055190.422021-09-012026-09-01
5554000.00.0453140.02021-10-012024-10-01

Investments

idPurchaserIdSecurityIDSharesPricePerShareCurrentValueDatePurchased
(→ Customers.id)(→ Securities.id)
1111020.0200.02021-06-01
222530.0150.02021-07-01
333825.0200.02021-08-01
444735.0245.02021-09-01
555540.0200.02021-10-01

Securities

idSymbolCompanyNameSectorIndustry
1AAPLApple Inc.TechnologyConsumer Electronics
2GOOGGoogle LLCTechnologyInternet Services
3MSFTMicrosoft CorporationTechnologySoftware
4AMZNAmazon.com Inc.RetailE-commerce
5FBFacebook, Inc.TechnologySocial Media