Database Project: Implementing ATM Transaction Authentication System

This document details a computer science project focused on designing a database for an ATM transaction system that incorporates RFID and mobile authentication for enhanced security. The project includes an Entity Relationship (ER) diagram to illustrate the database structure, defining entities such as RFID, Registration, Login, Transaction, Blocking, and Unblocking, and their relationships. The solution also provides the tables and artifacts, which includes use case and class diagrams, and the software used, Microsoft Visio 2013, used to create the diagrams. System requirements for the software are also provided. This project aims to provide a secure and efficient system for ATM transactions, demonstrating the practical application of database design and authentication methods. The document is a resource available on Desklib, a platform offering study tools and solutions for students.

Table of Contents
Database...............................................................................................................................................2
1. ER Diagram.............................................................................................................................2
2. Tables........................................................................................................................................3
Artifact.................................................................................................................................................5
1. Use Case Diagram....................................................................................................................6
2. Class Diagram..........................................................................................................................7
1

Database
RFID and mobile fusion for authenticated ATM transaction Database Creation is
shown in below.
1. ER Diagram
The RFID and mobile fusion for authenticated ATM transaction Entity Relationship Diagram
is shown in below.
The Above entity relationship diagram has the following entities like,
 RFID
 Registration
 Login
 Blocking
 Unblocking
 Cash Deposit
 Cash Withdrawal
 Transaction
2

The Entity Relationship Diagram entities are connected with many to many relationship
by using the entity referential identity. The RFID tables includes the RFID ID, card number
and Registration ID. The Registration tables includes the user name, phone number, RFID
number, PIN, IMEI, pattern password and Login ID. The Login table includes the Login ID,
user name, password, card number, phone number, PIN, transaction ID, blocking ID and
unblocking ID. The Transaction table includes the Transaction ID, card number, PIN, cash
deposit and cash withdrawal. The blocking table includes the blocking ID, PIN, registered
mobile number, OTP number and IMEI. The unblocking table includes the unblocking ID,
OTP, Pattern password and PIN.
2. Tables
The Entities are shown in below.
3

4

Database File is attached here.
Artifact
The Artifact includes the use cases, class diagram, sequence diagrams and other
unified modelling language. It helps to describe the architecture, function and software
design.
5

1. Use Case Diagram
Use Case diagram file is attached here.
6

2. Class Diagram
The Class Diagram file is attached here.
MICROSOFT VISIO 2013 for Windows
 First, Download the Microsoft Visio professional 2013 by using the below link
http://getintopce.com/office-2013-professional-download-link/
 After, install the Visio software by Right click the downloaded Visio software and
click the Run.
 Once, installation completed.
 Go to Windows start button.
7

 Type the Visio and click the Visio.
Open the Visio.
 After, open the provided file by click the open other drawings in window. Choose the
file and open the use case diagram and class diagram.
 After, U will see the use case diagram and class diagram.
If any other doubt please asks.
8

SYSTEM REQUIREMENTS
 OS Required
Microsoft Windows 7, Microsoft Windows Server 2008 R2, Microsoft Windows Server
2012, Windows 8
 Software Requirements
Google Chrome 17.x, Internet Explorer 8.0 or later, Microsoft .NET Framework 3.5 or later,
Mozilla Firefox 10.0 or later, Safari 5
 OS Family
Windows
 Additional Requirements
1024 x 576 monitor resolution, DVD-ROM, DirectX 10.0 compatible graphics card
SYSTEM REQUIREMENTS DETAILS
 Min Operating System
Microsoft Windows (32 bit), Microsoft Windows (64 bit)
 Processor Type
Intel x86, Intel x86-64
 Processor Speed
1 Hz
 Min RAM Size
1 GB, 2 GB
 Min Hard Drive Space
2 GB
9