logo

Database Systems: Tables, Procedures, Triggers, Interest Calculation, Theory and SQL Code

Assignment 2 for ISYS224/ITEC624 course at Macquarie University, involving creating and populating database tables, implementing loan repayment procedures, database triggers, interest calculation, and transaction management.

17 Pages2167 Words422 Views
   

Added on  2023-06-04

About This Document

This article covers the creation of tables, procedures, triggers, and interest calculation in a bank database. It also discusses transaction, database schedule, and serializability. SQL code is included.

Database Systems: Tables, Procedures, Triggers, Interest Calculation, Theory and SQL Code

Assignment 2 for ISYS224/ITEC624 course at Macquarie University, involving creating and populating database tables, implementing loan repayment procedures, database triggers, interest calculation, and transaction management.

   Added on 2023-06-04

ShareRelated Documents
Database Systems
Table of Contents
Task -1 Table Generation...................................................................................................................2
Database Systems: Tables, Procedures, Triggers, Interest Calculation, Theory and SQL Code_1
Task – 2 Procedure..............................................................................................................................3
Task – 3 Triggers.................................................................................................................................7
Task -4 Procedure for Interest Calculation.......................................................................................8
Task -5 Theory...................................................................................................................................10
SQL Code...........................................................................................................................................11
Task -1 Table Generation
The Bank Database Tables are listed in below.
1
Database Systems: Tables, Procedures, Triggers, Interest Calculation, Theory and SQL Code_2
For Account Table (Brouard, Bruchez, Soutou & Larrousse, 2012),
For Account Type table,
For customer Table,
For Loan Table,
For loan type table,
For own table,
For repayment table,
2
Database Systems: Tables, Procedures, Triggers, Interest Calculation, Theory and SQL Code_3
ER Diagram
The entity relationship diagram for bank database is illustrated as below (Jones, 2013).
Task – 2 Procedure
1.
The procedure for repayment of loan is created sucessfully and it is demostrated as below
(PATHAK, 2011).
3
Database Systems: Tables, Procedures, Triggers, Interest Calculation, Theory and SQL Code_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Transaction
|13
|2319
|122

Database Transaction Assignment PDF
|13
|2240
|186