icNIMS Project - Abridged Report by IGNOU MCA

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

icNIMS

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

ts '

icNIMS: Indian Customs Nepal Import Management System

SANTANU ACHARYA

Under Guidance of Mr. Saikat Dhar

Submitted to the School of Computer and Information Sciences, IGNOU

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 â&#x20AC;&#x201C; 110068

m Address

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

Phone

: 9433755992

Study Centre

: 2802

St ud

Regional Centre

: 28

Program Name

: MCA

Course Code

O U

Submission Date

IG N

Fo ru

: Santanu Acharya

ts '

Name

: MCSP-060 : 30.09.2009

m Fo ru ts '

ABSTRACT

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.

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

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.

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

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.

IG A

or um

ud en ts

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 Introduction 1.2 Objectives

1 1

2. SYSTEM ANALYSIS

St ud

2.6 Software Requirement Specifications (SRS)

IG N

O U

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

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

Fo ru

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

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

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

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

St ud

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

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

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

2.1 Geographical coverage of icNIMS

2.4 Network Architecture

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

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

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

2.13 Software Engineering paradigm used in icNIMS

3.1 icNIMS Table Relations

100

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

3.5 Drop down combo

3.3 Layout of user home page

St ud

3.2 Layout of site home page

IG N

O U

4.1 Zend IDE Environment

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

5.10 New CTD filing

301

302

303

304

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

5.30 Printing of CTD by Appraiser

St ud

5.25 Changing email of bank

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

ts '

2.7 Interface Requirements and I/O Formats 2.8 Data Dictionary

5.2 Test Case design 5.3 Test Report

278

279

312

331

IG N

O U

7.1 Calculation of Total Cost of icNIMS Project

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.

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.

Print.

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

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

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

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.

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

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

2006. Print.

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

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.

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

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

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

or um

•

Version: 1.0 Date: 30th September 2009

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

CHA

cPanel

CTD

DFD

Dwell-time

ERD

FPA

Gantt Chart

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

or um

L/C

PuTTY SRS

An open source HTML-embedded scripting language

Tax Assistant

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.

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

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

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

or um

icNIMS

Indian Customs Nepal Import Management System Santanu Acharya

MCSP-060 IGNOU MCA

ÂŠ2009