Loading documents preview...
PROJECT REPORT ON
Online Banking System
Registration Info
User
Reply
Reply
Valid user Access
Login_ Info
(n)
2.0 Login System
(a)
Registratio n Process
(b) (c)
3.0 Account Opening process
User Details
(m)
1.0
4.0 Account Transaction
Valid
user
user
(e) (f)
(g)
Access Valid
(d)
5.0 Loan
6.0 Customer Feed Back
(h)
(i) (j)
Access
Administrator (a) : (b) : (c) : (d) : (e) : (f) : (g) : (h) : (i) : (j) : (k) : (l) : (m): (n) :
User Details Response Personal details Reply Account Transaction entry Transaction Details Loan Application Response Feedback Reply Create ,Update ,Reply User data Login Info Invalid login
(k) Valid Administrator
7.0 Create and Update Process
(l)
Online Banking System Database
FIG:
Registration Info
1.1 Registratio n
LEVEL-1 DFD
Verify data
1.2 Verificatio n Valid User
Register Info Update 1.3
processing reigistration Login_Info
LEVEL-2 PROCESS-1
Account Request User Data User Data
CUSTOMER
Personal Details
3.1
3.2
Application process
Verification by administrator
update Response
3.2 Customer Response process
LEVEL 2 PROCESS-3
Retrieve Verified_ Appl
Other Bank
Other Account
Valid user
4.1 Money Transfer
Request for transfer Money_Transfer
Valid user
4.2 Account Balance
Balance Enquiry Account_tab
Deposit cash
4.3 Deposit
LEVEL 2 PROCESS-4
Branch
Loan_ application
5..1 Apply for Loan
Loan details Valid user
52
Response
5.3 Loan Sanction
Verification of application By administrator
Update Sanctioned_Loan
Valid user
5.4 EMI calculator
Valid user
5.5 Foreign Currency Exchange calculator
Valid user
5.6 Maturity Value calculator
LEVEL 2 PROCESS 5
Response
Response
Response
6.1 Feed Back
Customer Feedback User Feedback
Reply
Reply Process
FeedBack_tab Feedback
Reply
Feedbacks_ Reply 6.2 Reply
LEVEL-2 PROCESS-6
Reply Feedback By Administrator
New Password
7.1 Change Password
Confirm Password User Details
Response Account Details
Application data Verified data
Login_Info Old Password
Account_Requests Tab
7.2 Verification Of Account Application
7.2 Delete Account
7.3 Verification Of loan Application
Update Table
Customer_ Info Retrieve Data
Retrieve Data
Loan_ Application
Update
Sanctioned_ Loan
Retrieve Feedback
User Feedback
Reply
New Password
7.4 Feed Back Processing
Customer Feed Back Response Feed Back Update Data
Account details update
7.5 Monetary Transaction s
Update Data
LEVEL-2 PROCESS-6
Money Transfer _tab
Account_ tab
Valid user
4.2.1 Request Transfer Account_tab
verify Money_ Transfer Account_tab
Status Info
4.2.4 Update Account
LEVEL 3 PROCESS-4.2
4.2.2 Verify balance
update 4.2.3 Update Transfer By Administrato r
DATABASE DESIGN: Table : Login_info Column name
DataType Size
Key
Register_id Name
Varchar2 Varchar2
10 20
Primary
Hint Question
Varchar2
25
Hint Answer
Varchar2
20
password
Varchar2
10
Table: Registered_customer table:
Column Name CustomerID FirstName MiddleName Last Name DOB Sex City State Country ZipCode Email Mobile Telephone Occupation CorrespondenceAddress PermanentAddress2 NomineeFirstName NomineeMiddleName NomineeLastName RelationShip
DataType VarChar2 VarChar2 VarChar2 VarChar2 Date VarChar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 VarChar2 VarChar2 VarChar2 VarChar2
Size 15 20 20 20 20 1 20 20 20 6 20 20 20 20 20 20 20 20 20 15
Key Primary
Table: Branch Column Name BranchID BranchLocation BranchManager Telephone
Data Type Varchar2 Varchar2 Varchar2 Varchar2
Size 20 20 20 20
Key Primary
Email Address1 Address2 Address3 Address4
Varchar2 Varchar2 Varchar2 Varchar2 Varchar2
20 20 20 20 20
Table: Account_Tab Column Name AccountNo CustomerID BranchID AccountType DepositType AccountOpeningDate OpeningBalance ClosingBalance IntroducerCustID NetBankLogin NetBankPassword NetBankHintQuestion NetBankHintAnswer
Data Type Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Date Number Number VarChar2 VarChar2 VarChar2 VarChar2 VarChar2
Size 15 15 5 10 10 10 10 15 15 15 15 15
Key Primary Ref.. Branch
Ref .Customer_Inf
Table: Feedback Column Name CustomerName FeedbackDate EmailId Comments
Data Type Varchar2 Date Varchar2 Varchar2
Table: Account_Request
Size 20 20 100
Key
Column Name Request_Id Branch Account_Type First Name Mid_Name Last Name Date Of Birth Address State City Zip Home_Phone Work_Phone Mobile Email Id
Table:
Data Type Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 date Varchar2 Varchar2 Varchar2 Int Int Int Int Varchar2
Size 8 15 15 50 30 30 10 30 15 15 6 10 10 10 15
Key Primary
Size 15 10 15
Key Ref Account_tab
Money Transfer
Column Name AccountNo Amount TranferredAcNo TransferredDate
Data Type Varchar2 Double Varchar2 Date
Table: Loan_application
Column Name
Size
Key
LoanRequestID LoanType ApplicantFirstName ApplicantMiddleName ApplicantLastName Gender MaritalStatus Category NRI ResidenceOwnership TypeOfResidence EducationalQualification Address1 Address2 Occupation CompanyName CompanyAddress CompanyTelephone LICPolicies OtherLoanAmount OtherLoanEMI OtherLoanBalanceMonths
Data Type Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Boolean Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Varchar2 Number Number Number
15 15 15 15 15 1 2 2
Primary
AmountRequested RateType Terms RepayMode LoanPurpose EstimatedFund PropertyDetails
Double Varchar2 Varchar2 Varchar2 Varchar2 Number Varchar2
10 1 50 1 50 10 100
Table:
1 1 1 20 20 20 25 50 15 50 10 10 10
Loan_Sanctioned
Column Name Loan Type Customer_Id Customer name Loan amount Period of Loan
Data Type Varchar2 Varchar2 Varchar2 Number Number
Size 10 10 20 10 5
Key Ref Customer_info
1. DATA DICTIONARY FOR PROCESSES
PROCESS REGISTRATION PROESS LOG IN PROCESS ACCOUNT OPENING ACCOUNT TRANSACTION P LOAN PROCESS CUSTOMER FEEDBACK CREATE AND UPDATE USER REGISTRATION USER VERIFICATION PROCESSING REGISTRATION ACCOUNT APPLICATION VERIFICATION BY ADMINISTRATOR ACCOUNT BALANCE DEPOSIT APPLY FOR LOAN VERIFICATION OF APPLICATION LOAN SANCTION EMI CALCULATOR FOREIGN EXCHANGE CALCULATOR CUSTOMER FEEDBACK REPLY FEEDBACK CHANGE PASSWORD DELETE ACCOUNT
DESCRIPTION Registers user to the site Validates User ID and Password Deals with opening of Account Deals Monetary transactions Deals with loan procedure Receives customer feedback and sends reply Deals with administrative processes Receives registration data from user Verifies data with database Registers users and updates table Receives user data Verification of user data by administrator Updates Account table Updates table Receives user data for application Verification of data by admin Sends response and update table Calculates monthly interest payable Calculates foreign exchange Receives customer feedback Feedback replied by administrator Receives old password and gives new password to user Deletes user account informations
2. DATA DICTIONARY FOR DATAFLOWS
DATAFLOW NAME
SOURCE
DESCRIPTION
REGISTRATION INFO LOG IN INVALID LOGIN REQUEST FOR TRANSFER BALANCE ENQUIRY DEPOSIT LOAN DETAILS VERIFIED DATA
User, administrator User, administrator Administrator User User User User Administrator
Registration data Id, password to access the site Wrong id or password User request for money transfer Enquiry about balance Deposit cash Detail about the loan Data after verification by administrator
FEEDBACK REPLY FEEDBACK NEW PASSWORD OLD PASSWORD CONFIRM PASSWORD USER DETAILS UPDATE RETRIEVE RETRIEVE FEEDBACK RESPONSE FEEDBACK STATUS INFO
User Administrator Administrator User User User Administrator Administrator Administrator Administrator Administrator
Feedback by user Reply feedback by administrator Assign new password Gives old password Confirms new password User details for account opening Updates table Retrieve data from database Retrieves user feedback from database Replies feedback SENDS STATUS ABOUT THE ACCOUNT