LMS Case Study Solution 1.0
LMS Case Study Solution 1.0
LMS Case Study Solution 1.0
diagram Software requirements specification Functional requirements Traceability matrix Non functional requirements Sequence diagrams E-R diagrams Design Element Class Diagram System Test Cases Page No. 2 5 6 7 16 17 19 26 26 27 45 46 48 49
Problem Statement
Scott Bank was established in 1985 and has since become a leader in the domain of banking. The bank has decided to automate its home loan system and make it online in order to provide better services to its customers. The Loan Management System (LMS) would serve as a sub-system of the existing online banking system. The Bank aims to overcome external competition by providing its customers a webenabled, user-friendly service. It allows users of the system to register themselves, and apply for home loans. An Officer can view the loan requests, reject the requests or forward the request to the manger. The Manager can then sanction/reject the loan request. General users of the site are called Visitors. Visitors can view general information about the bank and the loan procedures that are followed. . When a visitor submits a loan application, the bank executive can contact the visitor and set-up a meeting. During the meeting between , the visitor might decide to avail of the home loan scheme. This discussion could also take place over the phone or by exchange of electronic mails. Thereafter, the Visitor signs up and submits a formal loan application. After signing up the Visitor is identified as a customer, and assigned a customer-id.Each customer can login into the system and view/update his profile, change his password apply for a loan and also view the loan status after he has applied for the same. Once a customer requests for a loan, the application is forwarded to an Officerwho setups a meeting with the customer. During the meeting all documents are verified and a loan amount decided.. The Officer can hold , reject , or forward the application to the Manager for sanction. The Manager processes a loan request only after an Officer verifies the documents and forwards the request. The loan is sanctioned by the Manager and it is assumed that disbursement is done in one installment. For every loan applied through the system a LoanApplicationId is generated. used to track the status of the loan, until the loan is sanctioned. The LoanApplicationId is
The customer can view the loan application status and the loan information. After the loan is sanctioned, a LoanId is generated for future reference.A Customer can view the loan amount sanctioned, the interest rate, terms of repayment, tenure of loan, mode of repayment and total interest, using the LoanId. Presently the mode of repayment is through debiting from the Savings Bank Account. A customer can apply for more than one home loan. Types of loans: Only Home Loan is being considered for the current development.
Definitions of the terms used in LMS: Visitor: Any person who visits the home loan site but is not yet registered.
Customer: Officer:
A Bank Employee, who is responsible for checking the loan application, verifying the relevant documents and then forwarding the application to the manager. Manager: A Bank Employee, who actually sanctions the loan. He can also change the interest rates as per rules. CustomerId: Every customer on successful registration is alloted a CustomerId, using which he can login to the system. LoanApplicationId: For every Loan Application submitted by a customer a LoanApplicationId is generated which is used to track the status of the loan until it is sanctioned. LoanId: When the Manager sanctions a Loan, a Loan Id is generated. This is used to refer to the details of the loan.. Loan Application Status: Every Loan Application has a number of states. This state identifies the current Loan Application Status. The Loan Application States provided are 1 Applied 2 Officer Verified 3 Sanctioned 4 Rejected
5 On Hold (An application can be withheld for subsequent approval by an Officer until which time the status is withheld). After a loan is sanctioned it moves to a state called Active State. Once all the repayments are made it moves to the Closed State. Active Closed
Loan Status:
1 2
Business Logic:
1.
Any salaried person, self employed professional, business man, and agriculturist. Minimum net take home salary of $ 6000/- per month for salaried employees. Annual income of not less than $ 120,000 for businesspersons, self-employed professionals and agriculturists. Minimum age for sanctioning a loan to a person is 21 yrs. The maximum age at the time of loan maturity should not exceed 63 yrs. The maximum loan amount which can be given to an individual is $ 100,00,000. The minimum loan amount which can be given to an individual is $ 100,000.
2.
Interest Calculation:
Processing Charge: Nil. Rate of Interest (RoI): Flat rates of interest. Flat Interest Rate a fixed interest of 7.5% ( the Manager can change the interest rateas per rules) on the entire Loan Amount Sanctioned.
3.
This statement consists of Principal Amount Sanctioned. Total Interest and Principal Repaid.
4. 5. 6.
Penal interest: @ 5% on the defaulted amount (where default amount is given in batch mode in a text file/table) and if default is beyond 6 months then legal action commences. Changing Loan Interest Rate: The Manager has the authority to change the interest rate.
Reports: The Manger/Officer requires to view different types of reports. The LMS should provide the following reports Customer report consisting of details of all the registered users of the system. Defaulter report giving details of all loans and corresponding customers with pending dues. Repayment Reports containing details of loans and their respective due dates and balance to be paid. Financial report consisting of all loans sanctioned by the bank during a particular period and amount that is credited from EMIs of all loans sanctioned. Repayment is done by deduction from an Saving Bank A/c in Scott Bank every month.
Loans report consisting of details of all the Loans sanctioned / rejected / with held .
7.
Assumptions: 1. Every customer maintains a savings bank account with the bank. 2. The bank has a Home Loan Account to which all the repayments are credited. 3. The bank has adequate funds from which it can sanction loans to any number of customers.
Requirement Analysis
Objective: Real world application scenarios are captured as Use Cases. The Use Case diagrams are generated manually or using a tool. Requirement analysis along with the modeling elements forms the basis for the product development. Requirement Analysis provides the overall description of the product, the environment, detailed descriptions of the Use Cases.
Overview
Scott Bank was established in 1985 and has since become a leader in the domain of banking. The bank has decided to automate its home loan system and make it online in order to provide better services to its customers. This would serve as a sub-system of the existing online banking system. The bank aims to overcome external competition by providing its customers a web-enabled, user-friendly service. The objectives of this system are: To automate the Loan Management System (LMS), thereby making it more userfriendly and simple so that customers can apply for a home loan online
Purpose
Home Loan Customers of the bank. Officer of the bank. Manager of the bank.
Scope
LMS enables: Visitors to the site to view general information about the loan schemes offered by the bank and to register online. Home Loan Customers to apply for home loans, check loan application status and to maintain their profile. The Officer to forward, reject or put an application on hold. The Manager to sanction or reject a loan application and to maintain a rate of interest. The system implements role based login functionality for Home Loan Customer, Officer & Manager.
User Characteristics
The user should be proficient in the use of the English language. The user is not required to have any technical expertise. The user is required to have a basic knowledge of internet.
Password should be at least 6 characters long and should contain at least one numeric and one special character like @,#,$,%,& etc., The Home Loan Customer, Officer and Manager will have their own role based login id.
and
The user should have a SB account in the bank before applying for a loan. A Home Loan Customer has his/her unique customer id and password, r Database security must be ensured. The system is dependent on the banks existing SB account database for loan repayment.
9 10 11 12
Process Loan Application Maintain Interest Rate View Reports Repay Loan
2. The system displays the details about the various loan schemes offered by the bank such as: Loan amount
Mode of repayment and the eligibility criteria associated with the loan schemes. None. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None. None. The system updates the details associated with the loan schemes as per existing rules of the bank. None.
Use Case ID: LMS-UCE02 Description: Actors: Preconditions: Post conditions: Frequency of Use: Normal Course of Events:
Use Case Name: Calculate EMI This use case allows a user to calculate the probable instalment amount for a particular loan based on the rate of interest, tenure of loan and the loan amount. Visitor, Home Loan Customer, Officer, Manager None. If the use case was successful, the actor gets to know the equated monthly instalments for the given inputs. Otherwise the system state is unchanged. 400 per day. 1. The actor selects to view the EMI calculator. 2. The system requests the actor to enter the loan amount, rate of interest and tenure of loan. 3. The actor enters the required details. 4. The system processes the data and displays the calculated EMI. Business Logic: The EMI is calculated with a monthly reducing balance rate system, using the following formula: EMI = p*r*(((1+r)^n)/(((1+r)^n)-1)) P = Principal r = rate of Interest. If the rate is say 10% per annum then r = 10 /(100*12) n = Term duration. if the repayment is 20 Years then n will be 12* 20 For a loan of 100000.00 at 10.25% rate of interest and 20 years repayment period the EMI will be EMI=100000*(10.25/1200)*(((1+(10.25/1200))^240)/ ((1+(10.25/1200))^240)-1) EMI =$ 982.00 Invalid Format or Insufficient Information If in the Normal Course Of Events, the data entered is incomplete or incorrect, the system displays an error message. The actor can then choose to either input the required data or cancel the EMI calculation, at which point the use case ends. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure.
Alternative Courses:
Includes: Special Requirements: Assumptions: Notes and Issues: Use Case ID: LMS-USU03 Description:
Appropriate error messages will be displayed. None. None. None. None. Use Case Name: Signup This use case allows a Bank Customer to register with the Loan Management System (LMS). Once the registration is complete, the Bank Customer becomes a Home Loan Customer. A customer id and password are generated and displayed to the Home Loan Customer with which he/she can login, apply for a loan and access services offered by the system. Bank Customer The Bank Customer should hold a savings bank (SB) account in the bank, in order for this use case to begin. If the use case was successful, the Bank Customer is registered with the LMS. Otherwise, the system state is unchanged. 250 per day. This use case starts when the Bank Customer wishes to register with the LMS to apply for a loan. 1. The Bank Customer selects to register with the LMS. 2. The system requests that the Bank Customer enter the registration details such as: Personal details
Alternative Courses:
SB account details 3. The Bank Customer enters the necessary registration details. 4. The system generates and displays a customer id and default password which can be changed later. Invalid Format or Insufficient Information If in the Normal Course Of Events, the Bank Customer has not specified sufficient and/or valid details to register, the system will display an error message. The Bank Customer can either enter the missing information or cancel the sign-up, at which point the use case ends. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database Connection failure. Appropriate error messages will be displayed. None. None. The Bank Customer is not an existing Home Loan Customer. None.
Login Description: Actors: Preconditions: Post conditions: Frequency of Use: Normal Course of Events: This use case describes how a user logs onto the Loan Management System (LMS) Home Loan Customer, Officer, Manager None. If the use case was successful, the actor is now logged onto the system. If not, the system state is unchanged. 500 per day. This use case starts when the actor wishes to log onto the LMS.
1. The system requests that the actor enters his/her id and password. 2. The actor enters his/her id and password. 3. The system validates the id and password and logs the actor onto the system. 4. Based on the login details entered by the actor, the system displays the corresponding actors user interface. Alternative Courses: Invalid Id/Password If in the Normal Course Of Events, the actor enters an invalid id and/or password, the system displays an error message. The actor will have an option to either provide valid id and password, or cancel the login, at which point the use case ends. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None. Security check should be implemented to ensure that only the authorized actors are able to view their user interface. None. None.
Apply for Loan Description: Actors: Preconditions: Post conditions: Frequency of Use: Normal Course of Events: This use case allows a Home Loan Customer to apply for a home loan. A loan application id is generated and displayed to the Home Loan Customer. Home Loan Customer. Home Loan Customer is logged onto the system, before this use case begins. If the use case was successful, a loan application id is generated and updated in the system. Otherwise the system state is unchanged. 50 per day. This use case starts when the actor wishes to apply for a home loan. 1. The system requests the Home Loan Customer to enter the loan application details. 2. The Home Loan Customer enters the necessary details such as Loan amount
Mode of repayment 3. The system validates the entered data. 4. A loan application id is generated, updated in the system and displayed to the Home Loan Customer. Business Logic: The minimum limit for any loan is Rupees One Lakh and the maximum limit is Rupees One Crore. Alternative Courses: Invalid Format or Insufficient Information If in the Normal Course Of Events, the Home Loan Customer has not
specified sufficient and/or valid details to apply for loan, the system will display an error message. The Home Loan Customer can either enter the missing information or cancel the operation, at which point the use case ends. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None. None. A Home Loan Customer can apply for more than one home loan. None.
Use Case Name: View Loan Application Status This use case allows a Home Loan Customer to view his/her loan application status. Home Loan Customer The Home Loan Customer must be logged onto the system before this use case begins. The system state is unchanged by this use case. 500 This use case starts when a Home Loan Customer wishes to view his/her loan application status 1. The Home Loan Customer requests to view the status of his/her loan applications. 2. The system retrieves and displays the loan application status for the loans applied by the Home Loan Customer. The status of the application can be one of these: a. Under Processing b. On hold c. Sanctioned d. Rejected 3. When the Home Loan Customer indicates that he/she is done viewing the loan application status, the use case terminates. No Status Information Available If in the Normal Course of Events, the system cannot find any loan application status information for the Home Loan Customer, a message is displayed. Once the Home Loan Customer acknowledges the message, the use case terminates. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None. None. None. None.
Alternative Courses:
LMS-UMP07 Maintain Customer Profile Description: Actors: Preconditions: Post conditions: Frequency of Use: Normal Course of Events: This use case allows user to view profile, edit profile and change password. Home Loan Customer Home Loan Customer is logged onto the system, before this use case begins. If the use case was successful, any changes carried out by the Home Loan Customer are updated. Otherwise, the system state is unchanged. 150 per day. This use case starts when the Home Loan Customer wishes to view profile, edit profile or change password. 1. The system requests the Home Loan Customer to specify the function he/she would like to perform (view profile, edit profile, or change password). 2. Once the Home Loan Customer provides the requested information, one of the sub flows is executed. 2.1. View Home Loan Customer profile. 2.2. Update Home Loan Customer profile. The Home Loan Customer can update the following details: Contact details Employment details 2.3. Change password. 3. The system updates the Home Loan Customer profile and/or password in the system. Alternative Courses: Invalid Format or Insufficient Information If in the Update Home Loan Customer profile sub flow, the Home Loan Customer updates his/her profile incorrectly or incompletely the system will display an error message. The Home Loan Customer can either enter the missing information or cancel the operation, at which point the use case ends. Password Mismatch If in the Change Password sub flow, the new password and confirm new password are not the same, the system will display an error message. The Home Loan Customer can either enter the required information or cancel the operation, at which point the use case ends. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None. None. None. None.
Mailing details
Use Case Name: View Loan Applications This use case allows the user to view the loan applications. This includes viewing new applications, applications on hold and verified applications. Officer The Officer must be logged onto the system before this use case begins.
The system state is unchanged by this use case. 100 per day. This use case starts when the Officer wishes to view the loan applications. 1. The system requests the Officer to specify the kind of application (either new applications, applications on hold or verified applications) he/she would like to view. 2. The system retrieves and displays the loan applications requested by the Officer. 3. When the Officer indicates that he/she is done viewing the applications, the use case terminates Requested Information Unavailable If in the Normal Course of Events, the system cannot find any loan applications, a message is displayed. Once the Officer acknowledges the message, the use case terminates. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None. None. None. None.
Alternative Courses:
Process Loan Applications Description: This use case allows the user to process loan application in the loan management system. The loan application can be forwarded, sanctioned, rejected or kept on hold. The action is recorded by changing the status of the loan application appropriately. Officer, Manager The Home Loan Customer submits loan application before this use case begins. If the use case was successful, the status of the loan application is updated in the system. Otherwise, the system state is unchanged. 50 per day. This use case starts when the officer wishes to forward the loan application to the manager or reject the loan application or put it on hold
1. 2.
The system requests the Officer to specify the function to perform(either forward, reject loan application or put it on hold) Once the Officer provides the requested information, one of the sub flows is executed. 1. 2.1. Forward the loan application to Manager 2.1.1. The system requests the Manager to specify the function to perform(either sanction or reject the loan application) 2.1.2. Once the Manager provides the requested information, one of the sub flows is executed. 2.1.2.1. Sanction loan. The system generates a loan id and updates it in the system. 2.1.2.2. Reject loan The loan application is rejected and its status is updated in the system. 2.2 Reject the loan application The loan application is rejected and its status is updated in system. the
1.
Put the loan application on hold The loan application is put on hold and its status is updated in the system.
None Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. View Loan Application None Home Loan Customer is not notified by mail. The Home Loan Customer is expected to check his status on the web. Officer/Manager will be responsible for any issues arising out of the use case.
Use Case Name: Maintain Interest Rate This use case allows a Manager to maintain home loan interest rates. This includes specifying new interest rates and changing existing interest rates for various home loan schemes. Manager The Manager must be logged onto the system before this use case begins. If the use case was successful, the new interest rate is updated in the system. Otherwise, the system state is unchanged. 2 per year. This use case starts when a Manager wishes to specify or change interest rate for a verified loan application. 1. The Manager specifies or changes the interest rate. 2. The System updates the changes implemented by the Manager. None Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None None None None
Use Case Name: View Reports This use case allows the user to view the reports on Home Loan Customer details, loan sanction details, loan repayment details and the defaulter details Officer, Manager
The actor must be logged onto the system before this use case begins. The system state is unchanged by this use case 100 times per day. This use case starts when the actor wishes to view reports related to the Loan Management system. 1. The actor requests the system for the required report. 2. The system retrieves and displays the report requested by the actor. 3. When the actor indicates that he/she is done viewing the report, the use case terminates Requested Report Not Available If in the Normal Course of Events, the system cannot find any report requested by the actor, a message is displayed. Once the actor acknowledges the message, the use case terminates. Refer LMS-Model-1.1.5.mdl (Rational Rose file). The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None None None None
Alternative Courses:
Repay Loan Description: This use case allows the user to initiate the process of loan repayment by debiting the EMI amount from the SB account of the Home Loan Customer. Officer The Officer is logged onto the system, before this use case begins. If the use case was successful, the EMI amount is debited from the Home Loan Customers SB account. 50 per day. This use case starts when the Officer wishes to initiate repayment process. 1. The Officer requests the system to provide the details of the loans for which repayment process has to be executed. 2. The system gets the list of all loans that are due for repayment and starts the repayment process. 3. The system updates the SB account of the loan considered in one of the following ways: 1. The balance is sufficient, system debits the SB account towards EMI and interest payment. 2. The balance is insufficient; the system calculates the penalty and updates the information. If in the Normal Course Of Events, if there are no loans returned by the system then the use case terminates. Refer LMS-Model-1.1.5.mdl (Rational Rose file).
Exceptions:
The following exceptions could occur: 1. Network connection failure. 2. Database connection failure. Appropriate error messages will be displayed. None None None None
Product Functions
General information: Any Visitor to the site can view general information about the various loan schemes offered by the bank. It helps the visitors to know about the approximate EMI for any given loan amount, thus enabling them to take informed decisions. Signup: It allows a Bank Customer to register with the Loan Management System (LMS). Once the registration is complete, the Bank Customer becomes a Home Loan Customer. Login: The Login module implements role based login functionality for Home Loan Customer, Officer & Manager. Loan application processing: This module includes Officer responsibilities which deal with the evaluation of the loan application and forwarding the application to the Manager or rejecting it. It also includes Manager functionalities which deal with sanction/rejection of loan application. Loan repayment: This module handles online repayment process and viewing repayment details by the Home Loan Customer. Reports generation: This module deals with generation of various reports on customer details, loan sanction details, loan repayment details and the defaulter details. The reports will be generated for a period with specified start and end dates.
User Characteristics
The user is not required to have any technical expertise. The user is required to have a basic knowledge of internet.
The various user roles in the system are: Visitor: Any person who visits the banks web site and navigates to the Loan Management System (LMS). Home Loan Customer: Any bank customer who registers with the LMS would become a home loan customer. Such a customer must hold an SB account with Scott Bank . Officer: An authorized employee of the bank who verifies a loan application and either forwards, rejects the loan application or puts it on hold. Manager: An authorized employee of the bank who sanctions or rejects a loan and maintains the rate of interest. Operating Environment Target Environment Server Side : Hardware Operating system Database Web Server Client Side : Operating system Hardware : Pentium processor PC with 128 MB RAM and 10GB HDD or more : Windows NT : Microsoft SQL Server : Microsoft Internet Information Server. : Windows 9X and above, LINUX. : Pentium processor PC
Web browser
This software will be developed as an online system and will be integrated with existing online core banking system. Design will be done using OOAD methodology. The system will be developed using the naming standards of the software development. The naming conventions will be retained across all modules.
Assumptions
Only Visitor, Home Loan Customer, Officer and Manager are the categories of users. Only the details of the last update would be stored in the database for each record. Every Home Loan Customer has a valid savings bank account within the bank. The bank employees cannot apply for a loan under this scheme. The bank has a Home Loan Account to which all the repayments are credited. The bank has unlimited bank balance from which it can sanction money to any number of customers. Login page/Home page EMI calculation page Registration page View profile page Edit profile page Change password page New loan application page Generating loan application id page View loan application status page View/Forward/Reject loan application page Sanction/Reject loan page View loan details page
User Interfaces
Functional Requirements
System Features System Feature ID: LMS-UGI01-SF01 S y s t e m F e a t u r e N a m e :
D i s p l a y G e n e r a l I n f o r m a t i o n Description: This system feature allows a user to browse through the various loan schemes offered by the bank and the eligibility criteria
associated with the different schemes such as age limits, total income and profession.
Classes:
LMSHomePage, LMSGeneralInfo rmationPage View General information - Basic Flow The user selects to view the information regarding the loans offered by the bank. The requested details are displayed to the user. Requirement ID REQ-1
Requirement Description To display the loan schemes and the associated eligibility criteria on request by the user for these pages. S y s t e m F e a t u r e N a m e : E M I C a l c u l a t i
o n Description: This system feature allows a user to calculate the probable installment amount for a particular loan, based on the rate of interest, tenure of loan and the loan amount. Refer LMSUCE02 for further details CalculateEMIFor m, EMICalculator, CalculateEMIInf o, EMIPage Calculator EMI Sequence Diagrams - Basic Flow When a user clicks on EMI calculator link, the EMI calculation page is displayed to the user. This page requests the loan amount, tenure and rate of interest. If incorrect data are entered then the system displays appropriate error messages. If data are correct, system calculates the EMI and displays it to the user. Requirement ID REQ-1 REQ-2 REQ-3 REQ-4 REQ-5 Requirement Description To accept tenure, rate of interest and loan amount details. To validate the details entered. To calculate EMI based on the details. To display the calculated EMI amount. To display proper error messages when required.
Classes:
Operations:
S y s t e m F e a t u r e N a m e :
S i g n u p Description: This system feature allows a Bank Customer to register with the Loan Management System (LMS). Once the registration is complete, the Bank Customer becomes a Home Loan Customer. A customer id and password are generated and displayed to the Home Loan Customer, with which he/she can login, apply for a loan and access services offered by the system. Refer LMSUSU03 for further details. SignUpForm, SignUpControlle r, LoginInfo,
Classes:
CustomerInfo, SignUpSuccesfu lPage Sequence diagrams, collaboration diagrams, state transitions: Signup Sequence Diagram - Basic Flow Bank Customer browses through the home page and navigates to the registration form. After the Bank Customer submits the necessary details, the system will validate the data. If the data are valid, system displays a customer id using which the user can logon to the system. Requirement ID REQ-1 REQ-2 REQ-3 REQ-4
Operations:
Requirement Description To accept the user information. To validate the user information. To generate a unique customer id. To display proper messages when required.
System Name:
Feature
LMS-URL04-SF04 Description:
Role Based Login This system feature enables a user to log onto the system. Refer LMS-URL04 for further details. LoginForm, LoginInfo, LoginValidator, CustomerPage, OfficerPage, ManagerPage,
Classes:
Operations:
LoginErrorPage Role Based Login Sequence Diagrams Basic Flow The user id and password are entered in login screen. If the user id is invalid, the system will throw an error message User Id doesnt exist, please reenter the User Id. If the password entered is invalid, the system will throw an error message password entered is wrong, please reenter the password. If the user id and password are valid, the system will display the corresponding actors user interface. Requirement ID REQ-1 REQ-2 REQ-3 REQ-4
Requirement Description To accept user id and password. To validate the id and password entered by the user. To provide access to users (Customer/Officer/Manager) with their respective interfaces. To display proper error messages when required.
System Feature Name: Apply for Loan This system feature provides facility for the Home Loan Customer to apply for a home loan. Refer LMSUAL05 for further details LoanApplicationP age,
Classes:
LoanApplicationC ontroller, LoanApplicationI nfo, LoanApplicationS uccessfulPage Apply loan Sequence Diagrams - Basic Flow The Home Loan Customer enters all the necessary details in the form to apply for a loan with the system. If the details entered are valid, the loan application is submitted to the system. If the mandatory data is not entered, appropriate error messages are displayed. Requirement ID REQ-1
Operations:
Requirement Description To accept the loan application details: Loan type, property value, loan amount, loan tenure, repayment mode. To validate the entered details. To generate loan application id. To update the loan application status as Applied'. To display proper error messages when required. System Feature Name: Display Loan Application Status
This system feature allows the Home Loan Customer to view his/her loan application status. Refer LMS-UAS06 for further details LoanApplicationSta tusPage, LoanApplicationCon troller, LoanApplciationinfo , LoanInfo, StatusPage Display Loan Application Status
Classes:
Sequence collaboration
diagrams, diagrams,
state transitions:
Basic
Operations:
If no status information is available, the system will display an appropriate message. Requirement ID REQ-1 REQ-2
Requirement Description To accept the View Loan Application Status request from the Home Loan Customer. To display the set of loan applications applied by the Home Loan Customer and the corresponding status of the applications. To display proper error messages when required.
REQ-3
S y s t e m F e a t u r e N a m e :
V i e w C u s t o m e r
P r o f i l e Description: This system feature provides facility for the Home Loan Customer to view his/her personal details. Refer LMSUMP07 for further details. CustomerProfile Page, CustomerInfo, SuccessfulPage View Customer Profile Sequence Diagrams: Basic Flow The Home Loan Customer request to view his/her profile. The system displays the profile of the user. Requirement ID REQ-1 REQ-2 REQ-3 Requirement Description
Classes:
Operations:
To accept the request of the Home Loan Customer to view the profile. To display the profile of the Home Loan Customer. To display proper error messages when required.
S y s t e m F e a t u r e
N a m e :
E d i t C u s t o m e r P r o f i l e Description: This system feature provides facility for the Home Loan Customer to edit his/her personal details. Refer LMSUMP07 for further details. CustomerProfile Page, CustomerInfo, SuccessfulPage Edit Customer Profile Sequence Diagrams - Basic Flow The Home Loan Customer requests to edit his/her profile. The system displays the profile of the user. The Home Loan Customer edits the profile and submits it to the system.
Classes:
Operations:
If incorrect details are entered the system displays appropriate messages. Requirement ID REQ-1 REQ-2 REQ-3 REQ-4
Requirement Description
To accept the request of the Home Loan Customer to edit the profile. To display the profile of the Home Loan Customer. To accept the changes made by the user and update it in the system. To display proper error messages when required.
Description:
This syste m featur e provid es facilit y for the Home Loan Custo mer to chang e his/he r passw ord. Refer LMSUMP0 7 for furthe r detail s. Custo merPr ofileP age, Custo merIn fo, Succe ssfulP age
Classes:
Operations:
The Home Loan Custo mer reque sts to chang e his/he r passw ord. The Home Loan Custo mer modifi es the passw ord and submi ts to the syste m. The syste m valida tes the curre nt passw ord, most recen t passw ord and the old passw ord. The chang ed passw ord is
updat ed in the syste m. Requ irem ent ID REQ1 REQ2 REQ3 REQ4 REQ5
Requirement Description
To accept the request of the Home Loan Customer to change the password. To accept the new password. To validate the current password, most recent password and the old password. To update the changed password in the system. To display appropriate error messages when required.
System Name:
Feature
Description:
Display New Application This system feature allows the Officer/Manager to view the new loan applications submitted by the Home Loan Customers who have applied for a loan. Refer LMS-UVA08 for further details. LoanApplicationcon troller, LoanApplicationInf o, ApplicationListPage View New Loan Applications Sequence Diagrams Basic Flow The system will provide the Officer/Manager with the list of new loan applications, applied by the Home Loan Customers. If no new applications are available, the system will display
Classes:
Operations:
Requirement Description To accept the View New Loan Applications request from the Officer/Manager. To display all the new loan applications applied by the Home Loan Customers. To display appropriate error messages when required.
System Name:
Feature
Description:
Display Applications On Hold This system feature allows the Officer/Manager to view the loan applications submitted by the Home Loan Customers which have been put on hold by the Officer. Refer LMS-UC-08 for further details. LoanApplicationcon troller, LoanApplicationInf o, ApplicationListPage View Applications On Hold Sequence Diagrams Basic Flow The system will provide the Officer/Manager with the list of loan applications that have been put on hold by the Officer. If no applications are on hold, the system will display an appropriate error message. Requirement ID REQ-1 REQ-2 REQ-3
Classes:
State Transitions:
Operations:
Requirement Description To accept the View On Hold Loan Applications request from the Officer/Manager. To display all the loan applications those are kept on hold by the Officer. To display appropriate error messages when required.
System Name:
Feature
Description:
Display Verified Applications This system feature allows the Officer/Manager to view the loan applications submitted by the Home Loan Customers which have been verified by the Officer. Refer LMS-UVA08 for further details. LoanApplicationcontr oller, LoanApplicationInfo, ApplicationListPage View Verified Loan Applications Sequence Diagrams - Basic Flow The system will provide the Officer/Manager with the list of loan applications that have been verified by the Officer. If no verified applications are available, the system will display an appropriate message. Requirement ID REQ-1 REQ-2 REQ-3
Classes:
State Transitions:
Operations:
Requirement Description To accept the View Verified Loan Applications request from the Officer/Manager. To display all the verified loan applications applied by the Home Loan Customers and verified by the Officer. To display appropriate error messages when required.
System Feature Name: Forward/Reject/Hold Loan Applications This feature enables the Officer to view and forward/reject a loan application or to put the application on hold. Refer LMS-UPA09 for further details
Classes:
LaonApplciationDoc umentsPage, LoanSanctionPage, LoanInfo, LoanApplicationInf o, LoanController, LoanApplicationCon troller, LoanForwardedPag e, LoanWithHeldPage, LoanRejectedPage, LoanSanctionedPag e, LoanRejectedPage Forward Loan Applications Sequence Diagram Basic Flow Reject Loan Applications Sequence Diagrams Basic Flow On Hold Loan Applications Sequence Diagrams Basic Flow The Officer wishes to forward, reject a loan application or put it on hold. The Officer enters the details such as pan number, property value, The status of the loan application is updated in the system based on the operation (forward/reject/hol d) performed by the Officer. Requirement ID REQ-1 REQ-2 REQ-3 REQ-4
State Transitions:
Operations:
Requirement Description To accept the request of Officer to forward/reject/ a loan application or to put it on hold. To accept the verified documents details required to process the loan application such as pan number, property value, To update the status of the loan application in the system based on the operation performed by the Officer. To display appropriate error messages when required.
Description:
Classes:
This system feature enables the Manager to view and sanction/reject a loan application verified by the Officer. Refer LMS-UPA09 for further details LaonApplicationDoc umentsPage, LoanSanctionPage, LoanInfo, LoanApplicationInf o, LoanController, LoanApplicationCon troller, LoanForwardedPag e, LoanWithHeldPage, LoanRejectedPage, LoanSanctionedPag e, Sanction Applications Sequence Diagrams Flow Reject Applications Sequence Diagrams Loan
State Transitions:
Basic Loan
Operations:
- Basic Flow The Manager wishes to sanction, reject a loan application verified by the Officer. The Manager updates the loan application details such as the loan amount and the loan tenure. The status of the loan application is updated in the system based on the operation (sanction/reject) performed by the Manager. Requirement ID REQ-1 REQ-2 REQ-3 REQ-4
Requirement Description To accept the request of Manager to sanction/reject a loan application verified by the Officer. To accept the loan sanctioning details required to process the loan application such as the loan amount and loan tenure. To update the status of the loan application in the system based on the operation performed by the Manager. To display appropriate error messages when required.
Traceability matrix
Traceability Table
Traceability of System Features to User Requirements (System Feature ID to Use Case IDs.)
LMS-UAL05-SF05 LMS-UAS06-SF06 LMS-UMP07-SF07 LMS-UMP07-SF08 LMS-UMP07-SF09 LMS-UVA08-SF10 LMS-UVA08-SF11 LMS-UVA08-SF12 LMS-UPA09-SF13 LMS-UPA09-SF13
LMS-UVA08
LMS-UPA09
The system will be required to undergo testing by operational staff of the Scott bank before being used. The system should operate acceptably in the hardware and software configurations where the system is operational. (Refer Operating Environment(Page 7 of this document) 50 users can logon to the system at a time.
This application can not cause any harm/damage/loss of data to the user.
The direct access to database is strictly controlled. COMPANY will not be responsible for malfunctioning of the application in case database structures are modified at the customer end. Any data which is not entered through the application will not be validated and may cause erroneous results Access to the system is authorized to 3 persons (Home Loan Customer, Officer, and Manager) only.
Software Attributes
Quality
This software is made in accordance with the COMPANY Quality. The classes developed as part of the application may be used in other similar projects esp. classes like Login, EMICalculator etc. This software also provides the capability to integrate with any other components in future. For details of functions which can be performed by different roles (user groups) refer User Characteristics.
Business Rules
Sequence Diagrams
Visitor/Officer/Ma nager : User homePage : LMSHomePage generalPage : LMSGeneral InformationPage // User selects 'View General Information' link Display()
Viewprofilepage : customer Customerprofile f orm customerprofile controller customerinfo press view view profile view information display successful page
controller customerinfo Enter new password press update update password check for validity update information display successful page
: officer applicationcontr oller applciationinfo applicationlistp age get all OnHold applications get all applciations with status as on hold display applications list
: officer applicationcontr oller applciationinfo applicationlistp age get all verified applications get all applciations with status as verified display applications list
Basic Flow
Date of EMI Pending amount Regid O_id O_Name Sanctions EmailId Rate of interest Reg Id LoanId
Verifies Officer Emp Id Name DOB Check Status Forwards Loan Employee Loan Application Apply Loan id
EMI Status Loan scheme Duration Date of Application Payment Loan amount m
Loan application ID
EmaiId Name
Mid m 1
Design Element
Design Element ID: LMS-UAL05 SF05-DE04 Description: Note: A bookmark may be introduced here to hyperlink from the corresponding modeling element generated using Rational Rose. Design Element Name: Apply loan This design element allows the Home Loan Customer to apply for a loan. It captures all loan application related information. This design element also contains the information to generate a loan application id. For detailed information on this design element look at the design level sequence diagrams.
Classes:
For more information on this refer to the LMSUAL05SF05 of the LMS-SRS. <<aspx>> LMSLoanApplica tionPage (UI) <<cs>> LMSLoanApplica tion (BL) <<cs>> LMSLoanApplica tionDA (DA) <<cs>> SqlHelper (DAAB) <<aspx>> LMSLoanApplica tionSuccessPag e (UI) <<aspx>> LMSLoanApplica tionErrorPage (UI)
Method Specifications:
LMSLoan Applicati onPage.a spx: This is an ASPX page inherited from LMSPage Base class. This page captures informati on about loan applicatio n like the loan amount, loan tenure, property value, loan type, repayme nt mode. This page contains a SubmitB utton click event which instantiat es the Business Logic layer class LMSLoan Applicati on.cs to pass on the applicatio n details to the correspo nding method in the LMSLoan Applicati on.cs class. The event is as
follows:
1.
private vo id Su b mi tB utt on _C lic k (o bj ec t se nd er, Sy st e m. Ev en tA rg s e) Th is ev en t pa ss es th e lo an ap pli ca tio n sp eci fic in pu ts pr ov id ed by th e Ho m e
LMSLo anAppli cation: This is a class in the Busine ss Logic layer, which imple ments all the loan applica tion related functio nalities such as submis sion of loan applica tion by the Home Loan Custo mer
and viewin g of loan applica tions by the Officer and Manag er. This will pass on the applica tion specific details to a corres pondin g metho d in the LMSLo anAppli cation DA.cs class after perfor ming busine ss rules check, if any. The metho d specific ation in the class, corres pondin g to this design elemen t is:
1.
publi c int Sub mitA pplic ation (int login Id, strin g loan
Type , float prop ertyV alue, float loan Amo unt, float tenur e, strin g repayme ntMode)
LMSLoan Applicati onDA: This is a class in the Data Access layer, required to impleme nt all the loan applicatio n related functiona lities such as submissi on of loan applicatio n by the Home Loan Custome r and viewing of loan applicatio ns by the Officer and Manager and to communi cate with the DAAB for database operation s. A method in this class calls an appropria
te overload ed method in the SqlHelpe r.cs class for all the database operation s. The method specificat ion in the class, correspo nding to this design element is:
1.
public int In se rtL oa nA pp lic ati on (in t lo gi nI d, str in g lo an Ty pe , flo at pr op ert yV al ue , flo at lo an A m
ou nt, flo at te nu re, str in g re pa y m en tM od e) This method calls the ExecuteNonQu ery method in the SQLHelper class to execute a stored procedure to insert the loan application in to the database.
SQLHelp er.cs: This is a part of the DAAB. The DAAB consists of a single .NETbased assembly , which contains all of the functiona lity necessar y to perform the most common data access tasks against a Microsoft
SQL Server 2000 database and hence reduces the amount of custom code one needs to write. The SqlHelpe r class is intended to encapsul ate high performa nce, scalable best practices for common uses of SqlClient. The method in the class, correspo nding to this design element is:
1.
public st ati c int Ex ec ut eN on Qu er y( str in g co nn ec tio nS tri
ng , str in g sp Na m e, pa ra m s ob jec t [] pa ra m et er Va lu es ) This method executes a command that does not return any rows. This method will thus execute a stored procedure to insert the loan application details submitted by the Home Loan Customer.
LMSLo anAppli cation Succes sPage. aspx: This is an ASPX page inherit ed from LMSPa geBase class.
This is display ed when the loan applica tion submis sion proces s is succes sful.
LMSLo anAppli cationE rrorPa ge: This is an ASPX page inherit ed from LMSPa geBase class. This is display ed when the loan applica tion submis sion proces s fails due to the databa se connec tion failure.
Class Diagram
S.N o
Data Input
Expected Behavior
1.
Home link
Loan in
Schemes the
LMSHomeLoanSche mesPage is
2.
3.
4.
5.
6.
LMSHomePageCategorie s is clicked. Home Loan Schemes link in the LMSHomePageCategorie s is clicked. Eligibility Schemes link in the LMSHomePageCategorie s is clicked. Eligibility Schemes link in the LMSHomePageCategorie s is clicked. EMI Calculator link in the LMSHomePageCategorie s is clicked. EMI Calculator link in the LMSHomePageCategorie s is clicked.
LMS-UTC 02: This test case checks the Signup functionality. Obser ved Behavi or * Run 1 (P/F) H/M/ L
S.N o
Data Input
Expected Behavior
1. 2.
New User Signup link in the LMSHomePage is clicked All the required fields in the LMSSignUpPage are filled in and the Submit button is clicked The required fields are not filled in and the Create Account button is clicked. All the required fields in LMSSignUpPage are filled in and the Create Account button is clicked.
LMSSignUpPage displayed.
is
3.
SignUpSuccessFullPa ge is displayed with the system generated CustomerId. Appropriate error messages are displayed. If any exception occurs, LMSErrorPage is displayed.
4.
LMS-UTC 03: This test case checks the Login functionality. Obser ved Behavi or * Run 1
S.N o
Data Input
Expected Behavior
Run 2
Run 3
(P/F)
H/M/ L
(P/F)
H/M/ L
(P/F)
H/M/L
7.
8.
9.
10.
User Id and Password are not entered and Submit button is clicked. Valid User Id and Password are entered and Submit button is clicked. Invalid User Id and Password are entered and Submit button is clicked. Valid User Id and Password are entered and Submit button is clicked.
LMSLoginErrorPage is displayed.
The home page for the corresponding user is displayed. LMSLoginErrorPage is displayed.
*: P - Expected and observed behavior are same. F - Expected and observed behavior are different. This is classified as a defect. H - High severity defect (System crash / Incorrect data which impacts other regions / etc.) M - Medium severity defect (Execution can continue / Incorrect data which does not impact other regions / etc.) L - Low severity defect (Aesthetics / Message wording / Menu options / Wrong alarms / Help problems / etc.)
UI Screens
Under Construction and review