QUICK RESPONSE CODE BASED SMART CARD
GENERATION
ABSTRACT
This project is designed using VB.Net as the front end coding language and MS-
SQL Server 2008 as the back end.
The project contains student record collection for comma separated values, the
records extraction and QR Code generation for each student. Then, smart card is
generated based on the column values in the records and saved as image along with QR
Code image inside the card image.
Moreover, blood group column is fetched, number of records found out, count of
records blood group wise is calculated and percentage for each of them is calculated.
The administrator views all the QR Codes or selected student’s QR Code image,
Smart Card image and blood group wise reports. Blood group wise records filtering is
also carried out.
OBJECTIVES
1. To collect student records.
2. To process comma separated values files.
3. To generate QR Code based information.
4. To generate smart card images.
5. To prepare blood group wise percentage for students.
SYSTEM ANALYSIS
EXISTING SYSTEM
In the existing system due to the absence of QR code generation, the information
need to be accessed after verifying the ledgers. The details are managed in Excel work
book only. Phone call communication is required to get the blood group information of
students. Smart card cannot be provided to students without third party smart card
generation.
DRAWBACKS OF EXISTING SYSTEM
The existing system has following disadvantages.
1. Student details cannot be consolidated quickly.
2. Smart card generation requires third party image processing company.
3. More number of hard copies to be maintained.
4. Possibility of data theft.
PROPOSED SYSTEM
In the proposed system, using QR code generation, the information is accessed
without verifying the ledgers. The details are managed in single windows application.
Phone call communication is not required to get blood group information. Smart card is
generated with QR Code present inside the card image.
ADVANTAGES OF PROPOSED SYSTEM
The proposed system has following advantages.
1. Student details can be consolidated quickly.
2. Smart card details are easy to maintain.
3. No hard copies maintenance.
4. No possibility of data theft.
5. Fast information processing due to QR Code presence.
SYSTEM SPECIFICATION
HARDWARE SPECIFICATION
This section gives the details and specification of the hardware on which the
system is expected to work,
Processor : Pentium IV 1.7 GHz
Hard Disk Capacity : 500 GB
RAM : 4 GB DDR RAM
Monitor : 17” Color
Keyboard : 102 keys
Mouse : Optical Mouse
SOFTWARE SPECIFICATION
This section gives the details of the software that are used for the development,
Environment : Visual Studio .Net 2010
Coding language : VB.NET
Back-End : MS SQL Server 2008
Operating System : Windows 10 Professional
MODULE DESCRIPTION
The following modules are present in the project.
1. RECORD COLLECTION FROM COMMA SEPARATED VALUE
FILES
2. QR CODE GENERATION
3. SMART CARD GENERATION
4. BLOOD GROUP ANALYSIS
1. RECORD COLLECTION FROM COMMA SEPARATED VALUE FILES
In this module, the boys.csv and girls.csv records are fetched and records are
extracted. For each line in the ‘csv’ files, the column values such as name, date of birth,
age, blood group, etc.
2. QR CODE GENERATION
In this module, for each line in the ‘csv’ files, a Quick Response Code is
generated and the image is saved with serial number.jpg. It contains the column values
such as name, date of birth, age, blood group, etc.
3. SMART CARD GENERATION
In this module, for each line in the ‘csv’ files, labels are printed with column
values, for example, Name: <name>, Age: <age>, etc along with a Quick Response image
inside the card image and is saved with serial number.jpg. It contains the column values
such as name, date of birth, age, blood group, etc.
4. BLOOD GROUP ANALYSIS
In this module, for each line in the ‘csv’ files, blood group values are fetched for
all records and unique blood groups are found out along with count of each blood group.
Then percentage of those blood groups count are calculated and printed.
DATA FLOW DIAGRAM
ADMINISTRATOR
Admin Admin
Login
Get
Generate Smart
CSV
Card
Generate QR
Code
Blood Group
Percent
Calculation SmartCard
QRCode
View
View
SYSTEM FLOW DIAGRAM
QR CODE BASED SMART CARD
GENERATION
Administrator
Login
Get CSV Files
QR Code Generation
Smart Card Generation
Blood Group
Analysis
View QR Codes
View Smart
Cards
Change
Password
TABLE STRUCTURE
1. Table: Admin
Primary Key: UserName.
FIELD NAME TYPE SIZE
UserName Varchar 15
Password Varchar 15
2. Table: QRCodes
Unique: SNo.
FIELD NAME TYPE SIZE
SNo Int 4
Type Varchar 10
ImageName Varchar 50
3. Table: SmartCards
Primary Key: PoliceId.
FIELD NAME TYPE SIZE
FIELD NAME TYPE SIZE
SNo Int 4
Type Varchar 10
ImageName Varchar 50
