Organization

IDName
1Global Corp
2Tech Innovations Inc.
3Financial Services Group
4Economic Solutions Ltd.
5Investment Bankers Co.

Employee

IDFirstNameLastNamePositionHireDateSalaryOrgID
(→ Organization.ID)
1JohnDoeCEO2018-07-3095000.01
2JaneSmithCFO2016-05-1585000.01
3MichaelWilliamsCTO2017-11-2090000.02
4LindaBrownCOO2016-09-0180000.03
5TomBlackHR Head2018-03-1575000.04

Independent_Director

DirectorIDEmployeeID
(→ Employee.ID)
11
22
33
44
55

Executive_Manager

ManagerIDEmployeeID
(→ Employee.ID)
11
22
33
44
55

Accounts

AccountNumberCustomerIDBalanceOpenDate
(→ Customer.ID)
111000.02019-01-01
22500.02019-02-01
332000.02019-03-01
44700.02019-04-01
551500.02019-05-01

Transactions

TransactionIDAccountNumberAmountTypeDate
(→ Accounts.AccountNumber)
11200.0Deposit2021-01-01
21-50.0Withdrawal2021-01-15
32300.0Deposit2021-01-20
42-100.0Withdrawal2021-01-25
53400.0Deposit2021-01-30

Customer

IDFirstNameLastNameDateOfBirthOrgID
(→ Organization.ID)
1AliceWhite1985-01-011
2BobGreen1988-02-012
3CarolBlue1990-03-013
4DavidRed1991-04-014
5EvaYellow1992-05-015