Access over 20 million homework & study documents

DB2 Case Study INTRODUCTION

Content type
User Generated
Type
Study Guide
Rating
Showing Page:
1/16
36159801_db2_bank_case_study.doc Page 1 of 16
DB2 Case Study
Version 1.0
Prepared By
Madhavi Kadari

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/16
36159801_db2_bank_case_study.doc Page 2 of 16
Version History
S.No
Description
Date
Pages
Ver
Prepared/Upd
ated By
1
First Version
16-Jan-08
15
1.0
Madhavi
Kadari

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/16

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 16 pages?
Access Now
Unformatted Attachment Preview
 DB2 Case Study Version 1.0 Prepared By Madhavi Kadari Version History S.No Description Date Pages Ver Prepared/Updated By 1 First Version 16-Jan-08 15 1.0 Madhavi Kadari Table of Content 1 INTRODUCTION 4 2 REQUIREMENTS 4 3 BROAD SYSTEM SPECIFICATION 4 4 Input and Output Files 5 5 Table Layouts 6 6 Record structure of the DB2 Tables 9 7 Guidelines 10 8 Modules 11 9 Test Preparation 12 1 INTRODUCTION Purpose of this case study is to provide hands on experience for trainees by covering most of the programming concepts in COBOL with DB2. This case study is designed in Bank application domain. 2 REQUIREMENTS XYZ Bank Ltd maintains the current and personal accounts of the customers. To open an account, the customer needs to provide valid personal information and deposit Rs500 if it is a savings account. For a current account, no deposit is required. A third party captures the data and generates the customer id and the account number. All the transactions will be maintained on these with these 2 ids. The captured data will be loaded into the DB2 database. The data that is captured and being passed to the XYZ Bank Ltd can be grouped into 3 main functional areas Personal Data Account Data Transaction data Develop a system incorporating the above features with COBOL/DB2 programs 3 BROAD SYSTEM SPECIFICATION Development will be done in Batch mode. There will be an input file which contains the personal data, account data and the transaction Data. The r ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4