Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddressPhoneNumber
1JohnDoe2000-01-01john.doe@example.com+1234567890
2JaneSmith1990-02-02jane.smith@example.com+0987654321

Accounts

AccountIDCustomerIDAccountTypeBalanceOpenDate
(→ Customers.CustomerID)
11Checking1000.02021-01-01
22Savings500.02021-02-01

Pet_Insurances

InsuranceIDCustomerIDPolicyNumberInsuredAmountStartDateEndDatePaymentFrequency
(→ Customers.CustomerID)
11PI001200.02021-03-012022-03-01Monthly
22PI002300.02021-04-012023-04-01Quarterly

Disability_Insurances

InsuranceIDCustomerIDPolicyNumberCoverageAmountEffectiveDateExpirationDatePaymentFrequency
(→ Customers.CustomerID)
11DI0011000.02021-05-012024-05-01Monthly
22DI0021500.02021-06-012025-06-01Annually

Loans

LoanIDCustomerIDLoanAmountInterestRateTermYearsApprovalDate
(→ Customers.CustomerID)
1115000.05.052021-07-01
2220000.04.5102021-08-01

Investments

InvestmentIDCustomerIDTypeAmountPurchaseDate
(→ Customers.CustomerID)
11Stocks5000.02021-09-01
22Mutual Funds2000.02021-10-01