If you have any queries please leave a message here
Your Message

A bank proposes to develop an information portal for its customers. The portal provides secure login to customer account and online information services. The services include finding the list of all the accounts hold by a logged in customer, balance in his/her accounts, recent transactions, m-passbook and service requests like stopping the payment of a cheque, issue of a new cheque book, and complaint registration. A customer can have more than one accounts with the Bank, however, for online information purposes they all can be linked to a single user name and password. The proposed application can have only read only access to the accounts of the customer. Also the website should be a secure website as this application requires confidential information.

You may study the requirements of this system in more details by experiencing the online services of your own bank. Perform the following tasks for the system proposed above:

Q1. a) Which Systems Development Life Cycle (SDLC) will you propose for the specification given above?

Answer : - The systems development life cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project, from an initial feasibility study through maintenance of the completed application.

There are various SDLC models defined and designed which are followed during the software development process. Some important and popular SDLC models are given below −

I use Waterfall Model for the specification given above.

Q1. b) Justify you selection by evaluating suitability of at least two SDLCs.

Answer : -

Waterfall Model - The Waterfall Model was first Process Model to be introduced. It is also referred to as a linear-sequential life cycle model. It is very simple to understand and use. In a waterfall model, each phase must be completed fully before the next phase can begin. This type of software development model is basically used for the project which is small and there are no uncertain requirements.

At the end of each phase, a review takes place to determine if the project is on the right path and whether or not to continue or discard the project.

V-Model - In software development, the V-model represents a development process that may be considered an extension of the waterfall model, and is an example of the more general V-model. Instead of moving down in a linear way, the process steps are bent upwards after the coding phase, to form the typical V shape. The V-Model demonstrates the relationships between each phase of the development life cycle and its associated phase of testing. The horizontal and vertical axes represents time or project completeness (left-to-right) and level of abstraction respectively.

Q2. a) What would be the major costs of the system?

Answer : -

Q2. b) What may be the financial benefits of installing such a system?

Answer : -


Q2. c) Perform a cost-benefit analysis for the proposed software and report its findings.

Answer : -

Q2. d) List the major tasks and milestones of the Project and make a project schedule. You schedule must include both GANTT and PERT charts. Explain the two charts drawn by you.

Answer : -

Q3. a) Study the system and create a software requirement specification. You must identify either the processes or objects while analyzing. During the analysis give consideration to possible input and output of the processes.

Answer : -

Q3. b) After identifying the requirements, create Analysis Models. You may either use the classical approach and draw Entity relationship diagram and data flow diagrams (DFD’s) up to level 2-3; or you may use object oriented analysis approach and create class diagram, use case diagram, use cases etc.

Answer : -

Q4. a) Design the system architecture and the database as per the needs of the system. You must perform normalization on tables up to 3rd normal form. The table design must include Primary and Foreign keys and constraints.

Answer : -

Table Name : customer

Field NameData TypeConstraintDescription
cust_idintPrimary KeyUniquely identify each Customer in this table
cust_namevarchar(100)Name of the customer
cust_addressvarchar(200)Address of the customer
cust_phonebigintCustomer's contact details
cust_emailvarchar(100)Mail id of the customer
PANvarchar(12)Customer's PAN details
aadhaar_nobigintAadhaar number of the customer
date_of_birthdateCustomer's date of birth
join_datedateCustomer's join date
usernamevarchar(20)Foreign KeyLogin username for online banking

Table Name : login

Field NameData TypeConstraintDescription
usernamevarchar(20)Primary KeyLogin username for online banking
passwordvarchar(32)Login password for online banking

Table Name : account

Field NameData TypeConstraintDescription
account_nobigintPrimary KeyUniquely identify each Account in this table
current_balancenumber(20,2)Current account balance
opening_datedateAccount opening date
IFSCvarchar(12)Foreign KeyBranch identification code

Table Name : account_holder

Field NameData TypeConstraintDescription
account_nobigintForeign KeyAccount number
cust_idintForeign KeyCustomer identification number

Table Name : savings

Field NameData TypeConstraintDescription
interest_ratenumber(4,2)Interest rate of the account

Table Name : current

Field NameData TypeConstraintDescription
trade_licensevarchar(20)Trade license of the business
business_PANvarchar(12)PAN details of the business

Table Name : branch

Field NameData TypeConstraintDescription
IFSCvarchar(12)Primary KeyUniquely identify each Branch in this table
branch_namevarchar(50)Name of the branch
branch_addressvarchar(100)Address of the branch
branch_phonebigintContact number of the branch

Table Name : passbook

Field NameData TypeConstraintDescription
account_nobigintForeign KeyAccount number
transaction_datedatetimeDate of the transaction
descriptionvarchar(50)Description of the transaction
withdrawal_amountnumber(20,2)Withdrawal amount
deposit_amountnumber(20,2)Deposit amount
balancenumber(20,2)balance after withdrawal or deposit

Table Name : transaction

Field NameData TypeConstraintDescription
transaction_idbigintPrimary KeyUniquely identify each Transaction in this table
transfer_datedatetimeDate of amount transfer
amountnumber(20,2)Transfer amount
account_nobigintForeign KeySender account number
receiver_account_nobigintReceiver account number
usernamevarchar(20)Foreign KeyLogin username for online banking

Table Name : services

Field NameData TypeConstraintDescription
usernamevarchar(10)Foreign KeyLogin username for online banking
messagevarchar(500)Service request/complaint
message_datedateDate of the service request/complaint

Q4. b) Create the system flow chart or detailed process design and state transition diagrams. Also design the user input screens and output report formats.

Answer : -

Q5. Design various unit test cases for the application given above using different testing strategies.

Answer : -

ABOUT US is an educational website that helps worldwide students in solving computer education related queries.

Also, different software like Visual Studio, SQL Server, Oracle etc. are available to download in different versions.

Moreover, provides solutions to your questions and assignments also.


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution

Solutions of Different Questions


Website Devlopment


Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


Follow Us