MINOR PROJECT REPORT

RDBMS (MCAM1206L)
(Online Banking System Database)
A report submitted to Punjabi University, PATIALA in
partial fulfilment of the requirement for the award of
DEGREE course
In
MASTER OF COMPUTER APPLICATIONS (MCA)
(2021-2022)
2nd SEMESTER
(DEPARTMENT OF COMPUTER SCIENCE)

Submitted to: Submitted by:

Er.Amandeep kaur Name: Akashdeep
(Assistant Professor) Uni.Roll No:
Name: Nancy
Uni.Roll No:

BABA FARID COLLEGE, BATHINDA

 [2]

Contents

S. No Title Page No.

1. Declaration 3

2. Certificate 4

3. Acknowledgement 5

4. Introduction of Online Banking System 6 - 14

5. Introduction of RDBMS 15 - 17

6. Requirements of Project 18

7. Introduction of Oracle 19 - 26

8. Database Login 27

9. Oracle Create Table 28-29

10. Oracle Insert Table 30 - 35

11. ER Diagram of Project 36-37

12. Conclusion 38
 [3]

1. DECLARATION

I hereby declare that the project titled “Online Banking

System Database” is a project work which is carried out
under the guidance of supervisor. The information has been
collected form genuine and authentic resources.

The work has been submitted in partial fulfilment of the

requirement of MCA.

Akashdeep (21108053)
Nancy (21108001)
 [4]

2. CERTIFICATE

I here by certify that the work presented in this report

entitled "Online Banking System Database" submitted in the
partial fulfilment of the requirement for the award of degree
of Master Computer Applications from the department of
Computer Science, Baba Farid College, BATHINDA is an
authentic record of my own work.

Project Guide
Er. Amandeep Kaur Ghai

Dr. Tejinder Singh(HOD)

Signature with Date_________
 [5]

3. ACKNOWLEDGEMENT

With profound sense of gratitude, I take it as a highly

esteemed privilege in expressing my sincere thanks to my
supervisor and guide (Assistant Professor) Er. Amandeep
Kaur Ghai for his technical guidance, sound advice, excellent
supervision, valuable suggestions and ever available help
during entire course of training. Without his wise counsel and
able guidance, this training/project would not have been
completed in this manner.
I owe my sincere gratitude to all the faculties of Computer
Science Department, Baba Farid College, Bathinda for their
encouragement and unfailing interest in sincere suggestions
from time to time in this work.
Finally, I owe to the almighty who gave me to carry out this
work with sincerity and dedication.

Akashdeep
Nancy
 [6]

4. Introduction of Online Banking System: -

Online Banking System

Online Banking System provides many benefits to bank
consumers in terms of easy, fast, fast and secure
transactions, either through Internet, mobile phone or other
electronic devices. Nowadays Online Banking Project has
become one of the most essential parts of our daily life.
Online Banking Management System is the provision of
providing financial services using electronic communication
and computation. In practice, Online banking system includes
e-payment, e-shopping, and e-banking.
 [7]

Objective of Online banking system: -

The main objective of the proposed Online banking system

project is to be automated the various activities and
functions of any bank through Internet. Online banking
system project will facilitate to the bank employees and
the customers with the different modules. This Asp.net C#
based project is very much useful for the corporate sector
and the private sector banks. Using the project, the
bankers and customers can generate various kinds of
reports. The banking industry will take a big leap, shape
and explore like never before.
 [8]

Modules of Online banking system: -

 Account Opening
 Deposit in Account
 Account Status
 Cheque Book Request
 Payee Management
 Transfer Fund
 View Statement
 Change Password
 [9]

Types of Onilne Banking System: -

*Internet_banking
*Gpay
*Upi
*PhonePay
*Paytm
*AmazonPay
 [10]

More Usable Type of Online Banking System:-

*Gpay: -

Google pay is more usable type of Online Banking System.

Mostly Google pay used for Fund Transfer,
Check bank balance and received money from another
person.
Gpay provide 24 hours 7 days services.
 [11]

Scope of Online banking system: -

"Online banking system project aim is to automate

transactions of bank and providing better and faster service
to the customers by using internet. All the transactions
between customer and bank are stored in a database that is
the centre of all information. Online banking system project
make the things simple and makes the work of the involved
people easy. This C# project not only supports the current
process but also centralizes all data of the bank which is very
useful for producing different MIS based reports. The main
goal of Online banking system project is to automate the
general process carried out in any bank with improved
performance and also the vision of paperless banking.
 [12]

Goals of the Online banking system project: -

• Online banking system will manage large number of bank
transactions with ease.
• Online banking system will manage all details of the
existing customers who are registered with the respective
bank allow them to operate their account online via internet.
• Online banking system project will provide facility to open
new customer account and maintain its data efficiently and
effectively.
• This project will allow bank admin to view all the details of
the existing customer.
• Use of the proposed project will make activities like
updating, modification, deletion of records easier as
compared to the manual process.
 [13]

Features of Online banking system: -

The features provided by the proposed asp .net C# project
Online banking system are to those which are usually
available on visiting the local branch or on phone banking.
On-line banking features provided by the Online banking
system project includes:
• Provide facility to transfer of funds between two
accounts.
• Use of Online banking system brings efficiency in CRM
(Customer relationship management)
• Online Banking System project provides facility to the
customers to view balance and statements.
• It brings door to door services by using technology •
Customer can View debits and credits
 [14]

Advantages of Online banking project: -

• Online banking gives reliefs to their customer from
carrying heavy cash.
• Online banking provide facility of Opening & closing of
accounts to the customers.
• Make the payments of merchandise transaction through
internet.
• Online banking project enables prompt & speedy
operation to account holders.
• Online banking management saves lot of time of their
customers & provide convenient access to the banking
services online.
 [15]

5. Introduction of RDBMS: -

1. Project category

RDBMS (Relational Database Management System)

RDBMS stands for Relational Database Management System.
All modern database management systems like SQL, MS SQL
Server, IBM DB2, ORACLE, My-SQL, and Microsoft Access are
based on RDBMS.

It is called Relational Database Management System (RDBMS)

because it is based on the relational model introduced by E.F.
Codd.

What is table/Relation?

Everything in a relational database is stored in the form of

relations. The RDBMS database uses tables to store data. A
table is a collection of related data entries and contains rows
and columns to store data. Each table represents some real-
world objects such as person, place, or event about which
information is collected. The organized collection of data into
a relational table is known as the logical view of the database.
Properties of a Relation:

o Each relation has a unique name by which it is identified

in the database.
o Relation does not contain duplicate tuples.
o The tuples of a relation have no specific order.
 [16]

o All attributes in a relation are atomic, i.e., each cell of a

relation contains exactly one value.
A table is the simplest example of data stored in RDBMS.

What is a row or record?

A row of a table is also called a record or tuple. It contains the

specific information of each entry in the table. It is a horizontal
entity in the table. For example, The above table contains 5
records.

Properties of a row:
o No two tuples are identical to each other in all their
entries.
o All tuples of the relation have the same format and the
same number of entries.
o The order of the tuple is irrelevant. They are identified by
their content, not by their position.

What is a column/attribute?

A column is a vertical entity in the table which contains all

information associated with a specific field in a table. For
example, "name" is a column in the above table which
contains all information about a student's name.

Properties of an Attribute:

o Every attribute of a relation must have a name.

o Null values are permitted for the attributes.
 [17]

o Default values can be specified for an attribute

automatically inserted if no other value is specified for an
attribute.
o Attributes that uniquely identify each tuple of a relation
are the

What is data item/Cells?

The smallest unit of data in the table is the individual data
item. It is stored at the intersection of tuples and attributes.

Properties of data items:

o Data items are atomic.

o The data items for an attribute should be drawn from the
same domain.

Degree:

The total number of attributes that comprise a relation is

known as the degree of the table.
Cardinality:
The total number of tuples at any one time in a relation is
known as the table's cardinality. The relation whose
cardinality is 0 is called an empty table.

Domain:
The domain refers to the possible values each attribute can
contain. It can be specified using standard data types such as
integers, floating numbers, etc.
 [18]

6. Requirements of Project: -

Software Requirements

(Operating System Database)

*Window-10

Hardware Requirements

* 1TB ROM

* 4GB Ram

Used Technology

*Oracle 11g Express Edition

Database used:-

Oracle database
 [19]

7. Introduction of Oracle:-
Oracle database is a relational database management system
(RDBMS) from Oracle Corporation. This article will explain a
complete overview of the Oracle database, features, history,
and editions. Before discussing the oracle, we will first need to
know about the database.

The RDBMS system manages the relational data. Oracle

Database is the most famous relational database system
(RDBMS) because it shares the largest part of a market among
other relational databases. Some other popular relational
databases are MySQL, DB2, SQL Server, PostgreSQL, etc.

What is the Oracle database?

Oracle database is a relational database management system.
It is also called OracleDB, or simply Oracle. It is produced and
marketed by Oracle Corporation. It was created
in 1977 by Lawrence Ellison and other engineers. It is one of
the most popular relational database engines in the IT market
for storing, organizing, and retrieving data.
 [20]

Oracle database was the first DB that designed for enterprise

grid computing and data warehousing. Enterprise grid
computing provides the most flexible and cost-effective way
to manage information and applications. It uses SQL queries
as a language for interacting with the database.

Installation Steps of Oracle

1. Download oracleXE112_Win32 setup First of all.

2. Extract downloaded zip file.

 [21]

3. Open Extracted file now.

4. Open Disk1 file now.

 [22]

5. Click on setup option.

6. All files downloaded automatically.

 [23]

2. Now click on next option.

3. Click on I accept option.

 [24]

4. Choose path to store files.

5. Create Username and Password.

 [25]

6. Now click on install option.

7. Finally, your Oracle database is installed.

[26]
 [27]

8. Database Login: -

Before creating tables in the oracle database, we

must login with valid username and password. At very
first when we are creating our database we must
enter a username and password. So that
unauthorized person should not misuse our data of
the database. With username and password only
authorized person can access and login that particular
database.
 [28]

9. Oracle CREATE TABLE:-

In Oracle, CREATE TABLE statement is used to create a new
table in the database.
To create a table, you have to name that table and define its
columns and datatype for each column.

Syntax:

1. CREATE TABLE table_name

2. (
3. column1 datatype [ NULL | NOT NULL ],
4. column2 datatype [ NULL | NOT NULL ],
5. ...
6. column_n datatype [ NULL | NOT NULL ]
7. );

Parameters used in syntax

o table_name: It specifies the name of the table which you

want to create.
o column1, column2, ... column n: It specifies the columns
which you want to add in the table. Every column must
have a datatype. Every column should either be defined
as "NULL" or "NOT NULL". In the case, the value is left
blank; it is treated as "NULL" as default.
 [29]

Create table Online Banking System

CREATE table OnlineBankingSystem

(Name varchar2(255),

Gender varchar2(255),

Age number CHECK (Age>=18),

Plateform varchar2(255) ,
PhoneNumber number NOT NULL,

PRIMA RY KEY (PhoneNumber),

Payment_Secure varchar2(255),

HelpFul varchar2(255));
 [30]

10. Oracle Insert Statement or Table:-

In Oracle, INSERT statement is used to add a single record or
multiple records into the table.
Syntax: (Inserting a single record using the Values keyword):

1. INSERT INTO table

2. (column1, column2, ... column_n )
3. VALUES
4. (expression1, expression2, ... expression_n );

Syntax: (Inserting multiple records using a SELECT

statement):

1. INSERT INTO table

2. (column1, column2, ... column_n )
3. SELECT expression1, expression2, ... expression_n
4. FROM source_table
5. WHERE conditions;

Parameters
1) table: The table to insert the records into.

Keep Watching

2) column1, column2, ... column_n:

The columns in the table to insert values.

3) expression1, expression2, ... expression_n:

The values to assign to the columns in the table. So column1

would be assigned the value of expression1, column2 would
be assigned the value of expression2, and so on.
 [31]

4) source_table:

The source table when inserting data from another table.

5) conditions:

The conditions that must be met for the records to be

inserted.

Oracle Insert Example: By VALUE keyword:-

It is the simplest way to insert elements to a database by using
VALUE keyword.
See this example:

Consider here the already created supplier’s table. Add a new

row where the value of supplier_id is 23 and supplier_name is
Flipkart.

See this example:

1. INSERT INTO suppliers
2. (supplier_id, supplier_name)
3. VALUES
4. (50, 'Flipkart');
Output:

1 row(s) inserted.
0.02 seconds
 [32]

Oracle INSERT ALL statement:-

The Oracle INSERT ALL statement is used to insert multiple
rows with a single INSERT statement. You can insert the rows
into one table or multiple tables by using only one SQL
command.

Syntax
1. INSERT ALL
2. INTO table_name (column1, column2, column_n) VALU
ES (expr1, expr2, expr_n)
3. INTO table_name
(column1, column2, column_n) VALUES (expr1, expr2, e
xpr_n)
4. INTO table_name (column1, column2, column_n) VALU
ES (expr1, expr2, expr_n)
5. SELECT * FROM dual;

Parameters

1) table_name: it specifies the table in which you want to

insert your records.

2) column1, column2, column_n: this specifies the columns in

the table to insert values.

3) expr1, expr2, expr_n: this specifies the values to assign to

the columns in the table.
 [33]

ORACLE INSERT VALUES

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Surinder' , 'Male' , 23 , 'Gpay' ,8699916675, 'Yes'

,'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Akash' , 'Male' , 22 , 'Upi' ,9815450670, 'Yes' , 'No');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Mandeep' , 'Female' , 21 , 'Gpay' ,9779366563, 'No' ,

'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)
values ('Firdous_Ahmad_war' , 'Male' , 22 , 'Upi' ,6005052507,
'No' , 'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Manjot' , 'Female' , 22 , 'InternetBanking'

,8198041389, 'Yes' , 'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Manu' , 'Female' , 21 , 'Paytm' ,9888224648, 'No' ,

'Yes');
 [34]

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)
values ('Sandeep' , 'Female' , 23 , 'Gpay' ,9465394223, 'Yes' ,
'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Jagdish' , 'Male' , 22 , 'Gpay' ,8264431339, 'Yes' , 'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)
values ('Navjot' , 'Female' , 22 , 'Gpay' ,9501431277, 'Yes' ,
'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)

values ('Sukhjinder' , 'Male' , 21 , 'Gpay' ,8427048854, 'No' ,

'Yes');

INSERT INTO OnlineBankingSystem(Name , Gender , Age ,

Plateform , PhoneNumber , Payment_Secure , HelpFul)
 [35]

values ('Lovepreet' , 'Female' , 22 , 'Phonepay' ,8847496606,

'Yes' , 'Yes');
 [36]

11. ER Diagram of Online Banking System:-

Name Gender

Age

OnlineBankingSystem Plateform

PhoneNumber

Helpful
Payment_Secure

OnlineBankingSystem is a relation which is represented In

rectangle shape and others are attributes like Name, Gender,
Age, Plateform, PhoneNumber, Payment_Secure, Helpful
Which is represented using oval shape. The attribute
PhoneNumber is primary key of the table.
 [37]

Working Entity Relationship Diagram

Name Phone_No

Fail Payment

id Pass
s
Pin

Success

Balance_Report

Transaction_History
 [38]

Conclusion

CONCLUSION Thus, online banking system application provides

a very interactive, efficient and secure way to put essential
financial information of customer into their account whose
account number is known to the customer only. The best
important aspect of online banking’s is that it’s very easy to use
and manage financial transaction into the account.it offers loan
to bank customer according to customer and keeps information
related to it.

References :-

https://www.google.com
[39]