BANK Database Management System

Tables:

There are 11 tables created in this database. They are as follows:

• bank
• branch
• credentials
• employee
• account
• loan
• customer
• cust_phoneNum
• cust_account
• transactions
• credentials_account

Roles:

There are 3 group roles which are:

• customer
• employee
• bank manager

customer is not granted any previleges, employee is granted all previleges on few tables, functions and procedures. bank_manager has previleges to access all the tables, functions and prcoedures except the credentials table.

Views:

There are few views created as for now, one view for customer which is for getting the customer details, and two views for employees which are for getting employee details and for getting the pending loans.

Functions:

As of now, only one function - view_balance has been created which gives the balance amount in the account

Procedures:

As of now, only one procedure - create_account has been done which creates an account

To run an sql file in postgres:

psql -U user_name -d database_name -a -f file_name