Financial_Advisors

idfullName
1John Doe
2Jane Smith
3Michael Brown
4Emma White
5William Black

Clients

clientIdtypename
1Senior CitizenAlice Johnson
2OtherDavid Miller
3Senior CitizenEva Wilson
4OtherFrank Thompson
5Senior CitizenGrace Lewis

Accounts

accountNumberbalanceinterestRate
11000.00.02
25000.00.03
38000.00.04
412000.00.05
515000.00.06

Transactions

transactionIddateamountaccountNumber
(→ Accounts.accountNumber)
12022-01-01 10:00:00500.01
22022-01-02 15:00:00750.02
32022-01-03 20:00:001000.03
42022-01-04 23:00:001250.04
52022-01-05 0:00:001500.05

Financial_Advisors_Accounts

advisorIdaccountNumber
(→ Financial_Advisors.id)(→ Accounts.accountNumber)
11
22
33
44
55

Senior_Citizens

citizenIdnameage
1Charles Brown65
2Helen Green67
3Isabella White69
4Jackson Black71
5Karen Gray73

Other_Clients

clientIdname
1Linda Jones
2Mark Smith
3Natalie Davis
4Paul Evans
5Quinn Robinson

Client_Accounts

clientIdaccountNumber
(→ Clients.clientId)(→ Accounts.accountNumber)
11
22
33
44
55

Financial_Advisors_Clients

financialAdvisorIdclientId
(→ Financial_Advisors.id)(→ Clients.clientId)
11
12
23
24
35