Database model of a Bank

See the general requirements here.

Data model

• Client and Employee entities are subtypes of Employee entity
• YearlyInterestTransaction, MoneyTransfer, MoneyDeposit, MoneyWithdrawal and LoanPayments are all subtypes of MoneyTransaction entity

Create schema

• run create_tables.sql
• run create_functions.sql
• run create_views.sql
• run create_procedures.sql

Insert test data

• run insert_test_data.sql

Test scripts

• there are two tests scripts in test_scripts folder. Run these immediately after insert_test_data (these scripts contain hard-coded IDs). Otherwise, it may not work. Firstly run test01 and then test02.

Drop all tables, views and procedures

• run drop_all.sql

Update statistics

• run update_statistics.sql