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

User/ people table
SQL queries
Structure query a standard language that are used to manipulate, retrieve the data into the
database management system. A query is the request that are made for accessing the data from
the database tables, this information can be developed as the outcomes that is returned from the
SQL. It can be used to perform the operations like creating, inserting, updating and modifying
the details (Boissay, Claessens and Villegas, 2020). It helps in understanding the structure data
and enables the users to easily set the constraint into the table columns. In this report SQL
queries is used to populate the data into the database table, by using the create, insert operation,

thus below there are some queries which is generated for creating the tables into the banking
database system. It further shows the insert operation that are performed to load the data into the
table.

Entity relationship diagram
Entity relationship model describe the interrelation between the specific domain of knowledge.
ER diagram show how entities are related with each other in a system. It helps in describing the
structure of database by using ER diagram where the proper arrangement and relation between
the tables are found. It can be also understood as the blueprint details of the database which can
be later implemented as the database system (Bandaranayake, 2019). Main purpose of designing
the ER diagram is to layout the snapshot as how entities and its object relate to each other. Main
elements of this diagram is its entities, attributes and relationship, where the specific shapes are
available to differentiate it. In which entities represent in the rectangular shape, attributes are in
ellipse shape and relation shows in diamond shapes.
In this Banking database all entities are made using ER diagram tool which is Visio, it
shows the connectivity about the entities which is further use in designing the database by using
SQL server. Details have been made to give proper clarity about the data so that it can develop
the proper understanding as how data is populated in the database.

CONCLUSION
From the above report it is concluded that database management system helps in managing
and storing the details in an appropriate manner. Relational database management system is
mainly in wide used that provides the simplicity and easy perform of the operations. Above
report have illustrated the descriptions about the Entity relationship diagram and about the
database diagram. As it discussed how database system could have utilised to arrange the data in
systematic order and it enables the end user to performs the operation like create, insert and
update. Above report also discussed the descriptions about the SQL queries as how it is used in
order to modify and perform different operations so it helps in retrieving or manipulating the
data easily. Thus database system helps the organisations to manage all their information into the
systematic order, it helps in keeping the data safe for longer use and with easy use it helps in
reducing the time consuming factors also provides the up to date data. Therefore, above report
have involves the database diagram, Entity relationship diagram, and structured queries to
perform functions over the database system.

REFERENCE
Books and journals
Ahmad, N. and et.al 2020. Banking sector performance, profitability, and efficiency: a citation‐
based systematic literature review. Journal of Economic Surveys, 34(1), pp.185-218.
Aldasoro, I., Borio, C.E. and Drehmann, M., 2018. Early warning indicators of banking crises:
expanding the family. BIS Quarterly Review, March.
Bandaranayake, S., 2019. How Does Bank Competition Affect Systemic Banking Crises?.
Boissay, F., Claessens, S. and Villegas, A., 2020. Tools for managing banking distress: historical
experience and lessons for today.
Ferhi, A., 2018. Credit risk and banking stability: A comparative study between Islamic and
conventional banks. International Journal of Law and Management.