0% found this document useful (0 votes)
9 views8 pages

QR Code Smart Card Generation System

The document outlines a project for generating QR code-based smart cards using VB.Net and MS-SQL Server 2008, which includes student record management, QR code generation, and blood group analysis. The proposed system improves upon the existing method by consolidating student details quickly, eliminating the need for third-party services, and enhancing data security. Key functionalities include extracting records from CSV files, generating smart cards with QR codes, and providing blood group statistics.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views8 pages

QR Code Smart Card Generation System

The document outlines a project for generating QR code-based smart cards using VB.Net and MS-SQL Server 2008, which includes student record management, QR code generation, and blood group analysis. The proposed system improves upon the existing method by consolidating student details quickly, eliminating the need for third-party services, and enhancing data security. Key functionalities include extracting records from CSV files, generating smart cards with QR codes, and providing blood group statistics.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

QUICK RESPONSE CODE BASED SMART CARD

GENERATION

ABSTRACT

This project is designed using [Link] 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 : [Link]
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 [Link] and [Link] 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 [Link]. 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 [Link]. 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

Common questions

Powered by AI

The blood group analysis module fetches blood group values from CSV records and identifies unique blood groups. It calculates the count for each blood group and determines their percentage distribution among students. The output is a report listing these blood group percentages, contributing to an understanding of blood group distribution in the student population .

In the proposed system, smart card images are generated by extracting data from CSV files and printing it onto labels with column values like name, age, etc. This data is then combined with a QR code image inside the card image, and saved as an image file with a serial number designation for easy identification. This integration allows for the inclusion of vital information encoded within the QR Code alongside traditional printed data on the smart card .

The adoption of a single windows application improves efficiency by centralizing data management, thus enabling quicker access and processing of student information. It ensures consistency and data security within a unified platform, unlike dispersed Excel workbooks. This setup reduces redundancy, potential errors, and simplifies data update and retrieval processes, enhancing overall administrative efficiency .

The backend infrastructure of the system involves the use of MS SQL Server 2008 for database management, where records and generated images are stored and processed. The system runs on a Windows 10 Professional operating system environment, utilizing Visual Studio .Net 2010 for application development with VB.NET as the coding language .

The proposed system addresses and mitigates the risk of data theft by incorporating QR code technology, which reduces dependence on physical document copies that are vulnerable to unauthorized access and theft. It processes and manages all information digitally within a secure Windows application environment, thus minimizing the chances of data being misplaced or stolen from hard copies, a weakness seen in the existing system .

The required hardware specifications to run the proposed system include a Pentium IV 1.7 GHz processor, a 500 GB hard disk capacity, 4 GB DDR RAM, a 17” color monitor, a 102-key keyboard, and an optical mouse .

In the new student information system, the administrator's role involves logging into the system, retrieving CSV files, generating QR codes and smart cards, and conducting blood group analysis to produce reports. The administrator oversees viewing and managing the generated QR codes and smart card images, along with changing the system password as needed .

The proposed system streamlines the administrative workflow by significantly reducing the time spent on consolidating and accessing student information, which were previously reliant on physical ledgers and third-party intervention. It automates data processing tasks like card generation and blood group analysis, freeing up administrative resources for other activities. Furthermore, the system enhances data security and accuracy, enabling administrators to focus on strategic management rather than operational data handling, thus transforming the administrative role into a more efficient and effective process .

QR codes enhance system efficiency by allowing direct access to student information without the need to verify static ledgers, thus speeding up data retrieval. This eliminates reliance on external communication for specific information like blood groups and facilitates quick data consolidation and processing due to its embedded nature within smart card images .

The proposed system improves upon the existing system by including QR code generation, which allows for information access without verifying ledgers and eliminates the need for phone call communication to retrieve blood group information. It manages details within a single windows application, provides direct generation of smart cards with QR Codes, and removes the requirement for third-party image processing companies. Advantages include quick consolidation of student details, easy maintenance of smart card details, no maintenance of hard copies, prevention of data theft, and faster information processing due to the inclusion of QR Codes in the system .

You might also like