icNIMS Project - Abridged Report

or um 'F ts en ud St A C M U

O

icNIMS

IG

N

Indian Customs Nepal Import Management System MCA (MCSP-060) Project on developing an online system for management of customs clearance of third country goods imported by Nepal through India

Santanu Acharya 30/09/2009 IGNOU MCA

m PROJECT REPORT

Fo ru

MCSP-060

St ud

en

by

ts '

icNIMS: Indian Customs Nepal Import Management System

SANTANU ACHARYA

A

Under Guidance of Mr. Saikat Dhar

C

Submitted to the School of Computer and Information Sciences, IGNOU

M

in partial fulfilment of the requirements for the degree of

IG N

O U

Master of Computer Applications (MCA)

2009

Indira Gandhi National Open University Maidan Garhi New Delhi – 110068

m Address

: W.I.B.(M) 15/4, Phase-2 Golf Green, Kolkata - 700095

Phone

: 9433755992

Study Centre

: 2802

en

St ud

Regional Centre

: 28

Program Name

: MCA

C

A

Course Code

O U

M

Submission Date

IG N

Fo ru

: Santanu Acharya

ts '

Name

: MCSP-060 : 30.09.2009

m Fo ru ts '

ABSTRACT

en

As per the international conventions, Nepal, which is a landlocked country, is entitled to use the facility of the nearest seaport(s) of India to import goods from third countries and to get duty-free transit facility of such goods through India.

St ud

Movement of such third country cargo often poses an inherent security risk for India and the management and monitoring of such cargo is vital to the economic and national well-being of India. On the other hand, the need for expediting the Customs formalities and clearance of such cargo is of paramount importance, keeping in view the bilateral ties between India and Nepal.

M

C

A

icNIMS: Indian Customs Nepal Import Management System is an online and webbased system to handle issuance of Letters of Credit by banks, filing of CTD by the importers of third-country goods based in Nepal, handling the Customs clearance of imported third country goods and generation of statistical reports.

IG N

O U

By successfully implementing icNIMS, a substantial knowledge has been acquired regarding the implementation of a dynamic web based database system using open source technologies. This knowledge will be useful in the future for creating any type of web based application with backend database.

m Fo ru

ts '

ACKNOWLEDGEMENT

en

I would like to express my deepest gratitude to my project guide, Mr. Saikat Dhar, IT Analyst, Tata Consultancy Services for his valuable guidance, advice and support, which enabled me to successfully complete the project.

St ud

I am extremely grateful to all the members of IGNOU MCA Students’ Forum (IMSF) at http://www.santanu.in/forums who offered me valuable inputs, information, feedback, guidelines, opinion and encouragement, which enabled me to complete this project successfully.

C

A

I extend my thanks to all the faculties and staff members of St. Xavier’s College, IGNOU Study Centre, Kolkata and the St. Xavier’s Computer Centre for providing me with a good environment, valuable guidance and educational facilities during the past few years, which significantly enhanced my ability to undertake a project of this scale.

O U

M

I would also like to take this opportunity to thank my classmate and friend Mr. Pintu Majumder for his invaluable assistance, encouragement and support during the execution of this project.

IG N

Finally, I would like to extend my deep gratitude to my parents for their understanding, unwavering encouragement and support for me while I worked on this project, without which this endeavour could not have been successful.

U

O

N

IG A

C

M

or um

'F

ud en ts

St

icNIMS : Indian Customs Nepal Import Monitoring System Project Proposal : IGNOU MCA (MCSP-060)

Version: 1.0 Date: 30th September 2009

TABLE OF CONTENTS

Page

1. INTRODUCTION AND OBJECTIVES

1

1.1 Introduction 1.2 Objectives

-

1 1

2. SYSTEM ANALYSIS

-

en

St ud

2.6 Software Requirement Specifications (SRS)

IG N

O U

M

C

A

INTRODUCTION Purpose Scope Definition, acronyms and abbreviations Product and its function Benefits and Goals Overview OVERALL DESCRIPTION Product Description Product Functioning Users of the Product Assumptions made and Dependencies SPECIFIC REQUIREMENTS External Interface Requirements Interface Requirements and I/O Formats Hardware Requirements Software Requirements Logical Database Requirements - Data Dictionary Functional Requirements Non Functional Requirements Performance Requirements Design Constraints User Interface Constraints Operational Constraints Hardware Constraints Software Constraints Software System Attributes

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

-

3 4 5 8 8 8 10 11 11 11 11 12 13 13 14 15 16

Fo ru

Identification of Need Preliminary Investigation Feasibility Study Project Planning 2.4.1 Determination of unadjusted function point counts 2.4.1.1 External Inputs 2.4.1.2 External Outputs 2.4.1.3 External Inquiries 2.4.1.4 Internal Logical Files 2.4.1.5 External Interface Files 2.4.1.6 Computing unadjusted function points 2.4.2 Determination of Value Adjustment Factor 2.4.3 Determination of Function Points 2.4.4 Determination of cost and time 2.5 Project Scheduling 2.5.1 Gantt Chart 2.5.2 PERT Chart

ts '

2.1 2.2 2.3 2.4

m

-

-

17

-

18 18 18 18 19 19 20 20 20 20 21 23 24 24 24 24 31 31 55 63 63 64 64 64 64 64 65

Project URL: http://www.santanu.in/icnims IGNOU MCA

(ii) Version: 1.0 Date: 30th September 2009

APPENDICES Appendix-A : Instruction for Security Appendix-B : Result of Fact Finding Appendix-C : Overall Network Architecture Appendix-D : Data Model - E-R Diagram Appendix-E : Functional Model - DFD 2.7 Software Engineering Paradigm applied 3. SYSTEM DESIGN

-

66 66 68 71 72 73

-

81

84

Fo ru

-

m

icNIMS : Indian Customs Nepal Import Monitoring System Project Proposal : IGNOU MCA (MCSP-060)

-

84 86 87 94 100 100 101

-

108

-

108 269 272 276 278

-

279

-

279 279 279 282 285 293 312 313

-

319

-

319 321 325

7. COST ESTIMATION OF PROJECT

-

330

8. REPORTS

-

332

-

332 333 335 337 337 338

-

341

-

341 341 342 342

4. CODING

en

Complete project coding Standardization of the coding and code efficiency Error Handling and validation checks Parameter calling/passing Security Mechanisms

St ud

4.1 4.2 4.3 4.4 4.5

ts '

3.1 Modularization Details 3.2 Data Integrity Constraints 3.3 Database Design 3.4 Procedural Design 3.5 User Interface Design 3.5.1 Input Design 3.5.2 Output Design

5. TESTING

C

A

5.1 Testing Techniques and Testing Strategies 5.2 Test Case Design 5.2.1 Unit Test Case Design 5.2.2 Integration Test Case Design 5.2.3 System Test Case Design 5.3 Testing 5.4 Test Report 5.5 Debugging and Code Improvement

M

6. SYSTEM SECURITY MEASURES

IG N

O U

6.1 Database/Data Security 6.2 Creation of user profiles and access rights 6.3 Steps taken against hacking of system

8.1 Administrative Reports 8.2 Bank Reports 8.3 Kolkata Customs Reports 8.4 Land Customs Station Reports 8.5 Nepal Customs Reports 8.6 Miscellaneous Reports

9. SCREEN SHOTS OF USER INTERFACES 9.1 icNIMS Home Page and Login Form 9.2 icNIMS Logout Page 9.3 icNIMS Admin 9.3.1 Manage User By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

(iii)

ts ' en

C

A

St ud

M

10. FUTURE SCOPE AND FUTHER ENHANCEMENT OF THE PROJECT 10.1 Future Scope of the Project 10.2 Further enhancement of the Project

O U

-

342 343 343 344 344 344 345 345 345 346 346 347 347 348 348 348 348 349 349 349 350 350 350 350 351 351 352 352 353 353 353 354 354 354 355 355 355 356

m

9.3.2 Tariff and sensitive goods 9.3.3 Bank Registration 9.3.4 Insurance Company Registration 9.4 icNIMS Bank 9.4.1 L/C Issue 9.4.2 L/C View 9.5 icNIMS Importer 9.5.1 File CTD 9.5.2 View CTD 9.5.3 Submit CTD to Customs 9.5.4 CTD Claim at LCS 9.5.5 CTD Claim at Nepal 9.6 icNIMS Tax Assistant 9.6.1 Country 9.6.2 Route 9.6.3 Currency 9.6.4 Port 9.6.5 Transporter 9.6.6 Customs Formation 9.6.7 Importer 9.6.8 Foreign Exchange 9.6.9 Customs Officer 9.7 icNIMS Kolkata Customs 9.7.1 Verify submitted CTD 9.7.2 Forward CTD to Port 9.7.3 Assess Examined CTD 9.7.4 CTD Printout 9.7.5 Forward CTD to LCS 9.8 icNIMS Port Customs 9.8.1 Examine CTD 9.8.2 Send CTD for Assessment 9.9 icNIMS Land Customs Station 9.9.1 Examine CTD 9.9.2 Send CTD to Nepal 9.10 icNIMS Nepal Customs 9.10.1 Examine CTD 9.10.2 Release CTD to Importer 9.10.3 CTD Printout

Version: 1.0 Date: 30th September 2009

Fo ru

icNIMS : Indian Customs Nepal Import Monitoring System Project Proposal : IGNOU MCA (MCSP-060)

-

357 357 357

11. BIBLIOGRAPHY

-

358

12. APPENDIX

-

359

-

359

-

360

IG N

-

Scanned copy of CTD used in manual process

13. GLOSSARY

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

(iv) icNIMS : Indian Customs Nepal Import Monitoring System Project Proposal : IGNOU MCA (MCSP-060)

Version: 1.0 Date: 30th September 2009

LIST OF FIGURES Page -

2.2 Gantt Chart

-

15 16

Fo ru

2.3 PERT Chart

5

m

2.1 Geographical coverage of icNIMS

2.4 Network Architecture

-

72

-

73

-

74

-

75

-

76

-

77

2.10 Data Flow Diagram - Level-2 (Kolkata Customs)

-

78

2.11 Data Flow Diagram - Level-2 (Land Customs Station)

-

79

2.12 Data Flow Diagram - Level-2 (Nepal Customs)

-

80

2.13 Software Engineering paradigm used in icNIMS

-

81

3.1 icNIMS Table Relations

-

86

-

100

-

100

-

101

-

101

-

108

4.2 Common areas/elements of the user interface

-

269

4.3 Table design with CSS

-

272

4.4 Drop down combo for selecting CTD

-

273

4.5 User Management form

-

274

5.1 Login testing

-

293

5.2 Duplicate user creation

-

293

5.3 Password testing

-

294

5.4 Userlevel test

-

294

5.5 Sensitive commodity test

-

295

5.6 Email address validation

-

295

5.7 URL validation

-

296

5.8 Date validation

-

296

5.9 CTD printout testing

-

297

2.5 Entity-Relationship Diagram 2.6 Data Flow Diagram – Context Level 2.8 Data Flow Diagram – Level-2 (Admin Functions)

3.4 Input Forms

C

3.5 Drop down combo

A

3.3 Layout of user home page

St ud

3.2 Layout of site home page

IG N

O U

M

4.1 Zend IDE Environment

By: Santanu Acharya ©2009 Under Guidance of: Mr. Saikat Dhar, MCA

en

2.9 Data Flow Diagram – Level-2 (Registration Module)

ts '

2.7 Data Flow Diagram – Level-1

Project URL: http://www.santanu.in/icnims IGNOU MCA

(v) icNIMS : Indian Customs Nepal Import Monitoring System Project Proposal : IGNOU MCA (MCSP-060)

Version: 1.0 Date: 30th September 2009 -

297

5.11 New CTD creation

-

298

5.12 New L/C Issue

-

298

5.13 Availability of L/C while filing CTD

-

299

5.14 Availability of CTD to Customs Appraiser

-

299

5.15 Forwarding of CTD to Port

-

300

5.16 Availability of CTD at Port

-

m

5.10 New CTD filing

-

301

-

301

-

302

-

303

-

303

-

304

-

304

-

305

-

305

-

306

5.27 Submission of CTD to Customs

-

306

5.28 Availability of forwarded CTD to Port

-

307

5.29 Assessment of CTD

-

307

-

308

5.31 Creation of profile by Tax Assistant

-

310

5.32 Modification of profile

-

311

5.33 Addition of new exchange rate

-

312

5.34 User Management error rectification

-

317

6.1 PhpMyAdmin Database privileges for root

-

319

O U

Fo ru

300

5.17 Forwarding of CTD to Kolkata Customs from Port

6.2 PhpMyAdmin Database privileges for user

-

320

6.3 Server Security

-

320

6.4 MySQL management using PuTTY SSH Client

-

321

6.5 icnims_users table in PhpMyAdmin

-

322

6.6 User profile creation by Tax Assistant

-

323

6.7 icNIMS Security Implementation

-

325

6.8 icNIMS User Data

-

327

12.1 Scanned copy of CTD collected during preliminary investigation

-

359

5.18 Availability of CTD at Kolkata Customs 5.19 User Login Page 5.20 Logged in user

5.23 Deletion of user 5.24 Changing sensitiveness of an item 5.26 Availability of L/C to importer

IG N

M

C

A

5.30 Printing of CTD by Appraiser

St ud

5.25 Changing email of bank

en

5.22 Changing userlevel and password of existing user

ts '

5.21 Forwarding of CTD from Kolkata Customs to Port

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

(vi) icNIMS : Indian Customs Nepal Import Monitoring System Project Proposal : IGNOU MCA (MCSP-060)

Version: 1.0 Date: 30th September 2009

LIST OF TABLES Page

2.2 External Inputs

-

2.3 External Outputs

-

2.4 Computation of Unadjusted Function Points 2.5 Determination of Value Adjustment Factor 2.6 Phases and Sub-Phases of icNIMS

2.9 Functional Requirements 3.1 Tables, attributes and constraints 4.1 Functions used in icNIMS and their purpose

St ud

5.1 Test plan

en

ts '

2.7 Interface Requirements and I/O Formats 2.8 Data Dictionary

5.2 Test Case design 5.3 Test Report

9

10

-

11

-

12

-

14

-

24

-

32

-

55

-

87

-

278

-

279

-

279

-

312

-

331

IG N

O U

M

C

A

7.1 Calculation of Total Cost of icNIMS Project

7

m

-

Fo ru

2.1 Feasibility Study

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

P a g e | 358 icNIMS : Indian Customs Nepal Import Monitoring System Project Report : IGNOU MCA (MCSP-060)

11.

Version: 1.0 Date: 30th September 2009

Bibliography

Achour, Mehdi, Friedhelm Betz, and Antony Dovgal. "PHP: PHP Manual - Manual." PHP: Hypertext Preprocessor. The PHP Group, 2009. Web. 18 Sept. 2009. <http://www.php.net/manual/en/>.

or um

Bawane nee' Singhal, Neelam, and C.V. Srikrishna. "A Case Study to Assess the Validity of Function Points." World Academy of Science, Engineering and Technology 42 (2008): 224-27. Print.

Converse, Tim. PHP5 and MySQL Bible. Indianapolis, IN: Wiley, 2004. Print.

Function Point Counting Practices Manual. 4.1th ed. International Function Point User?s Group (IFPUG), 1999. Print.

'F

Goel, Prof. M.P., Ms. Huma Anwar, Ms. Tamanna Siddiqui, and P. Venkata Suresh. MCS-014:

Systems Analysis and Design. New Delhi: Indira Gandhi National Open University, 2004.

ts

Print.

IEEE-SA Standards Board. IEEE 1016-1998: Recommended Practice for Software Design

en

Descriptions. New York: IEEE Computer Society, 1998. Print.

IEEE-SA Standards Board. IEEE 1063-2001: IEEE Standard for Software User Documentation. New

ud

York: IEEE Computer Society, 2001. Print.

IEEE-SA Standards Board. IEEE 829-1998: Standard for Software Test Documentation. New York: IEEE Computer Society, 1998. Print.

St

Kruthiventy, Ajitha, Amrish Shah, Ashna Datye, and Bharathy Jayaraman. Software Testing Guide Book. Vol. I. The SoftREL Team, 2006. Print.

A

Kumar, Akshay, Divya Sharma, and Ranjana Sharma. MCS-043: Database Design and

2006. Print.

C

Implementation. Ed. Prof. N. Nirmala. New Delhi: Indira Gandhi National Open University,

M

Kumar, Akshay, Ranjana Sharma, V.V. Subrahmanyam, and Archana Singhal. MCS-023: Introduction to Database Management Systems. Ed. Milind Mahajani. New Delhi: Indira Gandhi National Open University, 2005. Print.

U

Nepal. Ministry of Commerce. Customs. Treaty of Transit between the Government of India and His

O

Majesty's Government of Nepal. Kathmandu: Ministry of Commerce, Nepal, 1999. Print.

IG

N

Siddiqui, Tamanna, Dr. Ela Kumar, P. Venkata Suresh, and Akshay Kumar Purohit. MCS-034: Software Engineering. Ed. Prof. A.K. Tripathi. New Delhi: Indira Gandhi National Open University, 2005. Print.

Tripp, Leonard L., ed. IEEE Std 830-1998: IEEE Recommended Practice for Software Requirements Specifications. New York: IEEE Computer Society, 1998. Print.

Wandschneider, Marc. Core Web Application Development with PHP and MySQL (Core Series).

Upper Saddle River: Prentice Hall PTR, 2005. Print.

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

P a g e | 359 icNIMS : Indian Customs Nepal Import Monitoring System Project Report : IGNOU MCA (MCSP-060)

12.

Appendix

Scanned copy of CTD used in the manual process

IG

N

O

U

M

C

A

St

ud

en

ts

'F

or um

•

Version: 1.0 Date: 30th September 2009

Figure 12.1: Scanned copy of CTD collected during preliminary investigation By: Santanu Acharya ©2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

P a g e | 360 icNIMS : Indian Customs Nepal Import Monitoring System Project Report : IGNOU MCA (MCSP-060)

13.

Version: 1.0 Date: 30th September 2009

Glossary - An officer of Customs who determined the nature and value of imported or exported goods with a view to determine its value in order to assess customs duty - Bill of Lading a document issued by a carrier to a shipper, acknowledging that specified goods have been received on board as cargo for conveyance to a named place for delivery to the consignee who is usually identified.

- Custom House Agent A clearing agency which specializes in Customs clearance procedures and engaged by importers and exporters on fee to clear goods on their behalf - A unix based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site. cPanel utilizes a 3 tier structure that provides functionality for administrators, resellers, and end-user website owners to control the various aspects website and server administration through a standard web browser.

- Customs Transit Declaration The primary import document submitted by the Nepalese Importers of third country goods through India - Data Flow Diagram A graphical representation of the "flow" of data through an information system. DFDs can also be used for the visualization of data processing (structured design).

- A Customs related electronic documentation terminology to indicate the time a import related document stays in the system between its filing and clearing - Entity-Relationship Diagram Entity-relationship diagram based on a database modeling method, used to produce a type of conceptual schema or semantic data model of a system, often a relational database, and its requirements in a top-down fashion - Function Point Analysis The method of measuring the size of an information system and expressing it in a number of function points - a type of bar chart that illustrates a project schedule. Gantt charts illustrate the start and finish dates of the terminal elements and summary elements of a project.

- Indian Customs EDI System A system for electronic processing of import documents and customs clearance meant for handling goods imported into India and exported out of India - Indian Customs Nepal Import Management System An online web-based system to handle the clearance of third country goods imported by Nepal through India - Institute of Electrical and Electronics Engineers IEEE goals include scientific and educational pursuit directed

or um

Appraiser

B/L

'F

CHA

en

ts

cPanel

ud

CTD

St

DFD

C

A

Dwell-time

M

ERD

O

U

FPA

N

Gantt Chart

IG

ICES

icNIMS

IEEE

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

P a g e | 361 icNIMS : Indian Customs Nepal Import Monitoring System Project Report : IGNOU MCA (MCSP-060)

Version: 1.0 Date: 30th September 2009

toward the advancement of the theory and practice of electrical, electronics, communication and computer engineering, as well as computer science, the allied branches of engineering and the related arts and sciences Letter of Credit A document issued mostly by a financial institution, used primarily in trade finance, which usually provides an irrevocable payment undertaking.

Land Customs Station “Dry Ports” situated at the land border between two countries where customs formalities can be handled Message-Digest algorithm 5 A widely used cryptographic hash function with a 128-bit hash value. As an Internet standard (RFC 1321), MD5 has been employed in a wide variety of security applications, and is also commonly used to check the integrity of files.

A relational database management system (RDBMS) which has more than 6 million installations. MySQL stands for "My Structured Query Language". The program runs as a server providing multiuser access to a number of databases.

Program (or Project) Evaluation and Review Technique A method to analyze the involved tasks in completing a given project, especially the time needed to complete each task, and identifying the minimum time needed to complete the total project.

-

LCS

-

MD5

-

MySQL

-

PERT

-

PHP

- PHP Hypertext Processor

PhpMyAdmin

- An open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

- A free telnet and SSH Client for Windows and Unix platforms.

Includes FAQ, documentation and contact information - Software Requirement Specifications A complete description of the behavior of the system to be developed. It includes a set of use cases that describe all the interactions the users will have with the software. Use cases are also known as functional requirements. In addition to use cases, the SRS also contains nonfunctional (or supplementary) requirements.

- A clerical level employee of Customs who assists the Customs Appraiser - Windows, Apache, MySQL, PHP

ud

en

ts

'F

or um

L/C

A

O

U

M

C

PuTTY SRS

St

An open source HTML-embedded scripting language

N

Tax Assistant

IG

WAMP WAN

A package combining Apache, MySQL and PHP, meant for automatic installation and combination under Windows OS.

- Wide Area Network a computer network that covers a broad area (i.e., any network whose communications links cross metropolitan, regional, or national boundaries). This is in contrast with personal area networks (PANs), local area networks (LANs), or metropolitan area networks (MANs) which are usually limited to a room, building, campus or specific metropolitan area (e.g., a city) respectively.

By: Santanu Acharya ©2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

P a g e | 362 Version: 1.0 Date: 30th September 2009

IG

N

O

U

M

C

A

St

ud

en

ts

'F

or um

icNIMS : Indian Customs Nepal Import Monitoring System Project Report : IGNOU MCA (MCSP-060)

By: Santanu Acharya Š2009 Under Guidance of: Mr. Saikat Dhar, MCA

Project URL: http://www.santanu.in/icnims IGNOU MCA

St

ud

en

ts

'F

or um

icNIMS

Indian Customs Nepal Import Management System Santanu Acharya

IG

N

O

U

M

C

A

MCSP-060 IGNOU MCA

Š2009