Banking Technology: Database Design, ER Diagrams & SQL Queries

This report delves into the realm of banking technology, focusing on the design and implementation of a robust database system. It covers essential aspects such as database diagrams illustrating the arrangement and relationships between database objects, detailed table descriptions including primary and foreign keys, and SQL queries for data manipulation and retrieval. The report also features an entity-relationship (ER) diagram created using Visio, providing a visual representation of the relationships between entities within the banking database. The comprehensive analysis demonstrates how database management systems are crucial for managing and storing banking data efficiently, ensuring data safety, and facilitating timely access to information. Desklib provides students access to this report and many other solved assignments.

BANKING TECHNOLOGY

TABLE OF CONTENT
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
Database diagram.........................................................................................................................3
Table description.........................................................................................................................6
SQL queries...............................................................................................................................13
Entity relationship diagram........................................................................................................17
CONCLUSION..............................................................................................................................23
REFERENCE................................................................................................................................24

INTRODUCTION
Banking technology mainly refer to the utilisation of the sophisticated information and the
use of communication technologies with the computer system to allow the banks to provide the
better customer services in a secure manner. Thus it helps the in enabling the banks to develop
the competitive edge in order to compete with other banks (Ahmad and et.al 2020). Database
provide the systematic information, it is the computerized system to store the data, it allows the
user to perform several operation and to retrieve the data easily whenever it is required. This
software system is used for storing, retrieving and to perform queries on the data, it enables the
interface among the end users and database, therefore end user can easily perform the delete,
update, create etc. operations to make data more useful. In banking database system, they use it
for tracking credit and debit detail and transaction information to develop the bank statement. It
also provides the inbuilt benefit to the banks so that they can easily exploits the stored data for
delivering better consumer experience. Following report will cover the database for banking, also
include the tables and linkage across it by using keys and relationship. This report will highlight
the database diagram along with the entity relationship diagram, ER diagram is based on Visio
tool and SQL queries to create and populate the data into database system.
MAIN BODY
Database diagram
It represents the graphical structure which shows the arrangement of database and their
relationship with the database objects. To develop the relation foreign key and primary key
usually use (Ferhi, 2018). It mainly helps in providing the visual layout, being able to analyse the
data flow and system operation will make easier as having the well-arranged database. Below is
the database diagram which shows the details about the tables and their relation with other to
form the reliable database system. The reason for loading the tables to design the database for
banking.

Table description
Banking database involves the tables like stock, organisation, people, bank, services and
country, each involves the primary and foreign key along with their data types. As in stock table
it involves the entities like stockID, ticker, leverage, shares and exchange which populate the
data. For organisation entity it involves the orgID, ticker, sedole, exchange, ISIN. People entity
involves the userID, user first name, user last name, nickname, EMP-No, bonus, base. In bank
entity the attributes are bankID, bankName, bankAsset, bankParent and in country entity suitable
attributes are contID, contName, date, category, status and lastly in service entity that involves
the attribute detail which are servID, servName (Aldasoro, Borio and Drehmann, 2018). For
using this table will help in giving the proper understanding about the database system
relationship between these relations will be represented with the help of foreign and primary
keys. Tables are connected by using the foreign key which is database kay use to link the tables
with each other. As foreign key easily identifies the relation among the database tables through
referencing the columns.
Stock table

Bank Table

Organisation table

Service table

Country table