RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
RAMAKRISHNA MISSION VIVEKANANDA COLLEGE
                   EVENING COLLEGE (AUTONOMOUS)
   DEPARTMENT OF COMPUTER SCIENCE
                   COURSE: B.C.A.
                            MINI PROJECT
          STUDENT NAME                :      DINESH BABU .S
          CLASS                       :      III YEAR B.C.A
          REGISTER NUMBER             :      UCAA1512
          PROJECT TITLE               :      M-DEPOSIT CHELLAN
          BATCH                       :      2015 - 2018
          GUIDE                       :      Mr. J. SEKARAN
lll BCA            DINESH BABU S                UCAA1512                   1
                RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
                      ACKNOWLEDGEMENT
          From bottom of my heart, I thank to our Most Revered Secretary
          Maharaj for his blessings and inspiring every minute.
          My profound thanks to Revered Evening College In-Charge Maharaj
          for his blessings and providing all facilities which helped to complete
          this project successfully.
          My sincere thanks to our honorable Principal Dr.K. SETHUSANKAR
          for his kind support and motivation.
          I would also like to extend my gratitude to the Head of the
          Department Mr. J. SEKARAN for both guiding and encouraging me
          to complete this project successfully.
          I would like to convey my thanks to the faculties of the Department
          where my doubts were clarified.
          I finally express my deep respect to my parents for their continuous
          support and thanks to my friends for their valuable contribution in
          my project completion.
                        RAMAKRISHNA MISSION VIVEKANANDA COLLEGE
                           EVENING COLLEGE (AUTONOMOUS)
lll BCA                  DINESH BABU S                UCAA1512                   2
            RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
   DEPARTMENT OF COMPUTER SCIENCE
                       COURSE: B.C.A.
                                  CERTIFICATE
This is to certify that project entitled “M-DEPOSIT CHELLAN” is bonafide
record    work   done     by    S.     DINESH    BABU,    REGISTER       NUMBER:
UCAA1512 who is studying in III B.C.A. presently.
Project Guide      :        Mr. J. SEKARAN
H.O.D              :        Mr. J. SEKARAN
Exam Date          :        30 March 2021
INTERNAL EXAMINER                                        EXTERNAL EXAMINER
                                         INDEX
   S.NO                           CONTENTS                             PAGE.NO
     .                                                                 .
lll BCA                DINESH BABU S              UCAA1512                   3
           RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
      1   ABSTRACT
      2   EXISTING SYSTEM
      3   PROPOSED SYSTEM
      4   HARDWARE SPECIFICATION
          SOFTWARE SPECIFICATION
      5   ENTITY RELATIONSHIP DIAGRAM
      6   DATA FLOW DIAGRAM
      7   DATABASE DESIGN
          SCREEN SHOTS
     8    CODING
     9    VALIDATION TESTING
          MODULE LEVEL TESTING
     10   CONCLUSION
     11   BIBILIOGRAPHY
                                    ABSTRACT
lll BCA             DINESH BABU S                UCAA1512                   4
                RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
          The title of the project is “M-DEPOSIT CHELLAN” . The main aim of
the project is to digitalizing the way of depositing the money in bank. The
Account holder need not to take the paper chellan to fill out the form to deposit
money.
          All just need is the depositer have to enter his/her Account Number and
have to submit it. After submitting their account number the details of the
account number will be automatically displayed on the screen, the user have to
verify the details and to proceed to fill out the denomination part. In the
denomination part the depositer need to enter only how many notes he/she is
having in each category and the total amount will be automatically calculated.
Then the depositer have to make sure the total amount calculated is correct after
verifying it he/she have to generate QRCode by clicking the QRCode generator
Button.
          The QRCode contains the Account holder’s Account number and the
amount to be deposited in his account. After the QRCode generated the
depositer have to show the QRCode to the cashier and the cashier will easily
scan the QRCode to make deposit your money in your account.
                                 EXISTING SYSTEM
lll BCA                  DINESH BABU S                UCAA1512                   5
                RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
          In the existing system the banks are using deposit chellan in a form and
the customer has to fill each and every section of the chellan manually which
consumes lot of time.
DRAWBACKS OF EXISTING SYSTEM:
      Consumption of paper is high.
      The level of making mistakes is high.
      Correcting the mistakes is a tedious process.
      Take lot of time to fill it correctly.
                                 PROPOSED SYSTEM
          The proposed system makes the depositer to use the chellan in a
 digitalized manner where the depositer need not fill all his account details
 manually. All he/she have to do is just have to enter the Account number and
 the denomination part. Finally they have to show the QRCode to the cashier to
 deposit the money in bank.
 ADVANTAGES OF PROPOSED SYSTEM:
      Consumption of paper will be totally removed.
      Chances of making mistakes will be very low.
      If it is a mistake depositer can easily correct it in a matter of time.
      Need not to carry the pen.
 The time for depositing the money will be minimized and made easy.
                          SYSTEM REQUIREMENTS
lll BCA                  DINESH BABU S                UCAA1512                   6
           RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
 HARDWARE SPECIFICATION:
      PROCESSOR          : Intel® Pentium® CPU N350 @2.16 GHz
      RAM                : 4.00 GB
      SYSTEM TYPE :64-bit operating system, x64- based processor
      HARD DISK           : 500 GB
 SOFTWARE SPECIFICATION:
      OPERATING SYSTEM               : Windows 10
      FRONT END                      : PHP
      BACK END                       : PhpMyAdmin SQL Database
      BROWSER                        : Chrome/ Mozilla Firefox
                            SYSTEM DESIGN
              ENTITY RELATIONSHIP DIAGRAM:
lll BCA             DINESH BABU S                UCAA1512                   7
                    RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
                                                                  NAME
                   ACCOUNT NUMBER
                   NNNNNB
                                             CUSTOMER
          MOBILE
          NUM
                                                                                PAN.NO
                         BRANCH
                                                              ACC.TYPE
                                DATA FLOW DIAGRAM
lll BCA                      DINESH BABU S                UCAA1512                       8
             RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
      USER
                                              ENTERS
                                              ACCOUNT
                                              NUMBER
                                               ENTERS
                                               DENOMINATION
                                                GENERATES
                                                QRCODE
                                                                                  CUSTOMER
                             PROJECT DESIGN
lll BCA               DINESH BABU S                UCAA1512                   9
          RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
                         DATABASE DESIGN
  COLUMN NAME                  DATA TYPE                       LENGTH
ACC                       INT                           10
NAME                      VARCHAR                       50
MOBILE                    INT                           10
BRANCH                    VARCHAR                       20
ACC TYPE                  VARCHAR                       5
PAN NO                    VARCHAR                       10
                            SCREENSHOTS
lll BCA            DINESH BABU S                UCAA1512                   10
          RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
lll BCA            DINESH BABU S                UCAA1512                   11
          RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
lll BCA            DINESH BABU S                UCAA1512                   12
          RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
                                   CODING
lll BCA            DINESH BABU S                UCAA1512                   13
             RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
                                      TESTING
UNIT TESTING:
Unit testing provides a sort of living documentation of the system. Developers
looking to learn what functionality is provided by a unit and how to use it can
look at the unit tests to gain a basic understanding of the unit’s API. Classes are
tested individuals and test case was successful
VALIDATION TESTING:
The process of evaluating software during the development process or at the end
of the process to determine whether it satisfies specified requirements.
Validation testing ensures that the product actually meets the clients needs. It
can also be defined as to demonstrate that the product fulfils its intended use
when deployed on appropriate environment.
lll BCA               DINESH BABU S                UCAA1512                   14
          RAMAKRISHNA MISSION VIVEKANANDA (EVENING) COLLEGE (AUTONOMOUS)
                             CONCLUSION
“M-DEPOSIT CHELLON” project is a new idea for depositing money
in the bank. The proposed system provides the customer of the bank
to deposit money in a digitalized and in easy way. It will be very
useful for the bank customer as well as for the bank employees.
                            BIBLIOGRAPHY
GOOGLE
WWW.W3SCHOOLS.COM
lll BCA            DINESH BABU S                UCAA1512                   15