The management of customer accounts, balances, and deposits poses a complex and time-consuming challenge for banking institutions, with potential financial losses and reputational damage resulting from inadequate management. Banks face several obstacles when managing customer accounts, balances, and deposits including managing multiple accounts, large customer base,complex transactions, security risks etc.
To manage customer accounts, balances, and deposits more efficiently, reduce errors, and provide better customer service, it is essential for banks to use a centralized database system. The proposed solution is the implementation of a Swift Bank Management System to streamline banking operations and enhance the customer experience.
Database Design: This project involves the decision on the entities, relationship between them, cardinalities of the relationship and the attributes of the entities. Based on several iterations, ERD is finalized and has been shown in the report.Further, ERD is converted to relational schema after the 3NF conversion.
Database Creation: Tables are created in the Oracle. The codes for the table creation is in the attached report. Upon table creation, data is inserted in the tables.
Database Querying: SQL is used to query the database. SQL query for some actions is present in the report file.