Customers

CustomerIDFirstNameLastNameDateOfBirth
1JohnDoe2000-01-01
2JaneSmith1995-06-30

Addresses

AddressIDStreetAddressCityStatePostalCodeCountryCustomerID
(→ Customers.CustomerID)
1123 Main StAnytownCA12345USA1
2456 Elm StAnothertownNY67890USA2

Products

ProductIDNameInterest_RateMinimumBalanceMaximumBalanceType
1Savings Account1%0100000Savings
2Savings Account2%0100000Savings
3Checking Account1%05000Checking
4Checking Account2%05000Checking

Accounts

AccountIDNumberOpenDateCurrentBalanceCustomerIDProductID
(→ Customers.CustomerID)(→ Products.ProductID)
112345678902021-01-01100011
298765432102021-02-01200022