See the general requirements here.
- Client and Employee entities are subtypes of Employee entity
- YearlyInterestTransaction, MoneyTransfer, MoneyDeposit, MoneyWithdrawal and LoanPayments are all subtypes of MoneyTransaction entity
- run create_tables.sql
- run create_functions.sql
- run create_views.sql
- run create_procedures.sql
- there are two tests scripts in
test_scripts
folder. Run these immediately afterinsert_test_data
(these scripts contain hard-coded IDs). Otherwise, it may not work. Firstly run test01 and then test02.
- run drop_all.sql