AI.

SHA

SIGMA INSTITUTE OF
TECHNOLOGY&ENGINEERING (POLYTECHNIC-648)
Ajwa-Nimeta Road, Bakrol, Ta.: Waghodia,
Vadodara - 390019
Contact :(91)-9909976831, 0265-267111, 267122
www.sigmainstitute.org

PROJECT REPORT
ON
AI.SHA

Submitted by:

MEET DARSHAN BISHT (186480307015)

GUIDED BY: HOD:

KAMLESH PARMAR SHREYAS PATEL

SIGMA INSTITUTE OF TECHNOLOGY &

SITE/CE/2020-21 Page 1
 AI.SHA

ENGINEERING (POLYTECHNIC-648)

Certificate
This is to certify that
MEET DARSHAN BISHT
Of Sigma Institute of Technology & Engineering(POLY)-648 college having

Enrollment no: 186480307015 have completed Final Project Report having title

AI.SHA under the guidance of Faculty Guide Mr. KAMELESH PARMAR.

Institute Guide – UDP Head of Department

DATE: DATE:

PRINCIPAL
(Mr. MILAN MEHTA)

USER DEFINED PROBLEM

SITE/CE/2020-21 Page 2
 AI.SHA

AI.SHA
Artificial Intelligence
Simulated Humanoid
Assistant

SITE/CE/2020-21 Page 3
 AI.SHA

SITE/CE/2020-21 Page 4
 AI.SHA

ACKNOWLEDGEMENT

We are extremely Thankful to SIGMA INSTITUTES OF TECHNOLOGY &

ENGINEERING (POLYTECHNIC) for giving the source and support in this
project.

We had taken help and guideline of some respected persons, who deserve our greatest
gratitude to our PRINCIPAL Mr. MILAN MEHTA. We would like to show our gratitude
to our HOD Mr.SHREYAS PATEL for giving us a good guideline for our project
throughout the year. We would also like to expand our deepest gratitude to Ms. NIDHI
PATEL and all our faculties who have directly and indirectly guided us in this project.

Many persons, especially our classmates, have made valuable comment suggestions on this
proposal which gave us an inspiration to improve our project. We also thank our parents for
their support.

SITE/CE/2020-21 Page 5
 AI.SHA

ABSTRACT

AI.SHA is a smart AI Bot Which can perfrom many tasks.

It provides capabilities for registering students in courses, admitting

students, tracking student attendance and Generating detain list online.

Ensures data integrity, privacy, and security in an open-access

environment

SITE/CE/2020-21 Page 6
 AI.SHA

INDEX
SR. NO CONTENT PAGE. NO

CH: 1 INTRODUCTION OF PROJECT 7

1.1 Introduction of project 8

1.2 Project Definition
8
1.3 Objective & Scope of Project
9
CH:2 PROJECT DESCRIPTION 10

2.1 Study of Problem 11

2.1.1 Hardware & Software requirement 11
2.1.2 Backend Technology 12

2.2 System Analysis 13

2.2.1 Software Introduction 14
2.2.2 Study Feasibility 15
2.2.3 System Model
16
2.3 System Diagrams 18
2.3.1 Data Dictionary 18
2.3.2 Diagrams 20
2.3.2.1 E-R Diagram
20
2.3.2.2 Data Flow Diagram
2.3.2.3 Use Case Diagram 22
2.3.2.4 Activity Diagram 25
26
2.4 Designing 29
2.4.1 Login Form 29
2.4.2 Admin 29
2.4.3 Teacher
31
2.4.4 Student
32
CH:3 ADVANTAGES & DISADVANTAGES 33

3.1 Advantages & Disadvantages 34

CH:4 System Testing 35
4.1 Introduction 36
4.2 Testing Methodologies 36
4.2.1 Unit Testing 36
4.2.2 System Testing 37
4.2.3 Performance Testing
37

SITE/CE/2020-21 Page 7
 AI.SHA

CHAPTER 1

INTRODUCTION

SITE/CE/2020-21 Page 8
 AI.SHA

1.1 INTRODUCTION OF PROJECT

Attendance Management System is a software developed for daily student
attendance in schools, colleges and institutes. It facilitates to access the
attendance information of a particular student in a particular class. The
information is sorted by the operators, which will be provided by the teacher for
a particular class. This system will also help in evaluating attendance eligibility
criteria of a student. It will help the teachers to mark a student’s attendance in a
more efficient and convenient way and the student can also view his/her
attendance anytime and anywhere.

1.2 PROJECT DEFINITION

Attendance Management System is a web-application for managing the
students’ attendance. Marking attendance in the traditional way and then
checking if the student fits in the criteria is a very time-consuming process. This
application allows the teacher to mark the attendance efficiently. In this
application the student can see his attendance just by logging in into his/her
account. This application contains different functions which are useful for the
teachers as well as the student such as generating a detain list, or managing
schedule according his/her current attendance.

SITE/CE/2020-21 Page 9
 AI.SHA

1.3 Objective & Scope of Project

❖ Objective
➢ Computerize the traditional way of taking attendance.

➢ Generate the report automatically at the end of the session or in the

between of the session.

➢ Fast storing and retrieval of data.

➢ Very less paper work.

➢ Minimalize the errors.

❖ Scope

➢ It Can Be Accessed Through a Web Browser on a Computer or

Any Other Device.

➢ It Will Be Used by a Particular Institute.

➢ It Can Be Accessed from Anywhere Just an Internet Connection

and A Web Browser Is Required.

SITE/CE/2020-21 Page 10
 AI.SHA

CHAPTER 2

PROJECT
DESCRIPTION

SITE/CE/2020-21 Page 11
 AI.SHA

2.1 Study of Problem

The system being developed is economic with respect to School or College’s

point of view. It is cost effective in the sense that has eliminated the paper work
completely. The system is also time effective because the calculations are
automated which are made at the end of the month or as per the user
requirement. The result obtained contains minimum errors and are highly
accurate as the data is required. The technical requirement for the system is
economic and it does not use any other additional Hardware and software. The
system working is quite easy to use and learn due to its simple but attractive
interface. User requires no special training for operating the system.

2.1.1 Hardware & Software Requirement

• Hardware
- Processor: i3 or Above
- Hard Disk: 500 GB
- RAM: 4 GB or Higher
-
• Software
- Microsoft Visual Studio 2019
- MSSQL Database
- Sublime Text Editor 3
- Windows XP Operating System

• Device Requirement
- Any device with a web browser and a stable internet connection.

SITE/CE/2020-21 Page 12
 AI.SHA

2.1.2 Backend Technology

MS SQL Server
• Automatically converts column data types to appropriate Oracle data
types.
• Automatically resolves object name conflicts, such as conflicts with
Oracle reserved words.
• Parses and transforms T-SQL stored procedures, functions, triggers, and
views to Oracle PL/SQL.
• Provides advanced customization capabilities such as the ability to
change data type mappings, delete and rename objects.
• Generates reports about the status of the migration.
• Generates the DDL scripts for the creation of the destination Oracle
database.
• Generates scripts for data movement
• Displays informational, error, and warning messages about the migration
in a progress window.

SITE/CE/2020-21 Page 13
 AI.SHA

2.2 System Analysis

It is a process of collecting and interpreting facts, identifying the problems, and
decomposition of a system into its components. System analysis is conducted
for the purpose of studying a system or its parts in order to identify its
objectives.

SITE/CE/2020-21 Page 14
 AI.SHA

2.2.1 Software Introduction

Visual Studio

Microsoft Visual Studio is an integrated development environment (IDE) from

Microsoft. It is used to develop computer programs, as well as websites, web
apps, web services and mobile apps. Visual Studio uses Microsoft software
development platforms such as Windows API, Windows Forms, Windows
Presentation Foundation, Windows Store and Microsoft Silverlight. It can
produce both native code and managed code.

Visual Studio includes a code editor supporting IntelliSense (the code

completion component) as well as code refactoring. The integrated debugger
works both as a source-level debugger and a machine-level debugger. Other
built-in tools include a code profiler, forms designer for building GUI
applications, web designer, class designer, and database schema designer. It
accepts plug-ins that enhance the functionality at almost every level—including
adding support for source control systems (like Subversion and Git) and adding
new toolsets like editors and visual designers for domain-specific languages or
toolsets for other aspects of the software development lifecycle (like the Team
Foundation Server client: Team Explorer).

Visual Studio supports 36 different programming languages and allows the code
editor and debugger to support (to varying degrees) nearly any programming
language, provided a language-specific service exists. Built-in languages
include C, C++, C++/CLI, Visual Basic .NET, C#, F#, JavaScript, TypeScript,
XML, XSLT, HTML, and CSS. Support for other languages such as Python,

SITE/CE/2020-21 Page 15
 AI.SHA

Ruby, Node.js, and M among others is available via plug-ins. Java (and J#)
were supported in the past.

The most basic edition of Visual Studio, the Community edition, is available
free of charge. The slogan for Visual Studio Community edition is "Free, fully-
featured IDE for students, open-source and individual developers".

2.2.2 Study Feasibility

A feasibility study is an analysis that takes all of a project's relevant factors into
account—including economic, technical, legal, and scheduling considerations—
to ascertain the likelihood of completing the project successfully. Project
managers use feasibility studies to discern the pros and cons of undertaking a
project before they invest a lot of time and money into it.

Feasibility studies also can provide a company's management with crucial

information that could prevent the company from entering blindly into risky
businesses.

The Importance of Feasibility Studies: -

Feasibility studies are important to business development. They can allow a

business to address where and how it will operate. They can also identify
potential obstacles that may impede its operations and recognize the amount of
funding it will need to get the business up and running. Feasibility studies aim
for marketing strategies that could help convince investors or banks that
investing in a particular project or business is a wise choice.

SITE/CE/2020-21 Page 16
 AI.SHA

2.2.3 System Model

Incremental Model is a process of software development where requirements
divided into multiple standalone modules of the software development cycle. In
this model, each module goes through the requirements, design, implementation
and testing phases. Every subsequent release of the module adds function to the
previous release. The process continues until the complete system achieved.

1. Requirement analysis: In the first phase of the incremental model, the

product analysis expertise identifies the requirements. And the system
functional requirements are understood by the requirement analysis team. To
develop the software under the incremental model, this phase performs a crucial
role.

2. Design & Development: In this phase of the Incremental model of

SDLC, the design of the system functionality and the development method are
finished with success. When software develops new practicality, the incremental
model uses style and development phase.

SITE/CE/2020-21 Page 17
 AI.SHA

3. Testing: In the incremental model, the testing phase checks the

performance of each existing function as well as additional functionality. In the
testing phase, the various methods are used to test the behavior of each task.

4. Implementation: Implementation phase enables the coding phase of the

development system. It involves the final coding that design in the designing
and development phase and tests the functionality in the testing phase. After
completion of this phase, the number of the product working is enhanced and
upgraded up to the final system product

Advantage of Incremental Model

o Errors are easy to be recognized.
o Easier to test and debug
o More flexible.
o Simple to manage risk because it handled during its iteration.
o The Client gets important functionality early.

Disadvantage of Incremental Model

o Need for good planning

o Total Cost is high.
o Well defined module interfaces are needed.

SITE/CE/2020-21 Page 18
 AI.SHA

2.3 System Diagram

2.3.1 Data Dictionary
1. Admin Table:

Sr. No. Field Name Datatype Description

Store user name for checking correct

1. Username Varchar2
username

Store password corresponding to

2. Password Varchar2
username.

3. User Type Varcahr2 User type Administrator or User.

2. Teacher Table:

Sr. No. Field Name Datatype Description

Store user name for checking correct

1. Username Varchar2
username

Store password corresponding to

2. Password Varchar2
username.

3. Attendance Table

Sr. No. Field Name Datatype Description

1. Student Name Varchar2 Name of student

Total number classes attended by

2. Status Number
particular Student

In which semester the student is

3. Semester Varchar2
studying

The Subject Wise Attendance is

4. Subject Varchar2
Maintained

The Month Wise Attendance is

5. Month Varchar2
Maintained

SITE/CE/2020-21 Page 19
 AI.SHA

4. Subject Table:

Sr. No. Field Name Datatype Description

1. Code Number Subject Code for unique key

2. Subject Name Varchar2 Name of Subjects in all Semester

In Which Semester student is

3. Semester Varchar2
studying.

5. Student Table:

Sr. No. Field Name Datatype Description

1. Student ID Varchar2 Enroll Number of user.

2. Student Name Varchar2 Name of student

Course in which the student is

3. Course Varchar2
studying.

4. Semester Number Semester in which student is studying

SITE/CE/2020-21 Page 20
 AI.SHA

2.3.2 Diagrams
2.3.2.1 E-R Diagram
Entity Relationship Diagram, also known as ERD, ER Diagram or ER model,
is a type of structural diagram for use in database design. An ERD contains
different symbols and connectors that visualize two important
information: The major entities within the system scope, and the inter-
relationships among these entities. And that's why it's called "Entity"
"Relationship" diagram (ERD).

SITE/CE/2020-21 Page 21
 AI.SHA

Attendance Management System E-R Diagram

SITE/CE/2020-21 Page 22
 AI.SHA

2.3.2.2 Data Flow Diagram

Also known as DFD, Data flow diagrams are used to graphically represent the
flow of data in a business information system. DFD describes the processes that
are involved in a system to transfer data from the input to the file storage and
reports generation. Data flow diagrams can be divided into logical and physical.
The logical data flow diagram describes flow of data through a system to
perform certain functionality of a business. The physical data flow diagram
describes the implementation of the logical data flow.

Symbols Used in DFD: -

SITE/CE/2020-21 Page 23
 AI.SHA

SITE/CE/2020-21 Page 24
 AI.SHA

SITE/CE/2020-21 Page 25
 AI.SHA

2.3.2.3 Use Case Diagram

SITE/CE/2020-21 Page 26
 AI.SHA

2.3.2.4 Activity Diagram

Activity diagram is another important diagram in UML to describe the dynamic
aspects of the system.
Activity diagram is basically a flowchart to represent the flow from one activity
to another activity. The activity can be described as an operation of the system.
The control flow is drawn from one operation to another. This flow can be
sequential, branched, or concurrent. Activity diagrams deal with all type of
flow control by using different elements such as fork, join, etc.

Activity Diagram for Admin

SITE/CE/2020-21 Page 27
 AI.SHA

Activity Diagram for Teacher

SITE/CE/2020-21 Page 28
 AI.SHA

Activity Diagram for Teacher

SITE/CE/2020-21 Page 29
 AI.SHA

2.4 Designing
2.4.1 Login Form

2.4.2 Admin

Home Page:

SITE/CE/2020-21 Page 30
 AI.SHA

Manage Staff :

Manage Standard:

Manage Division:

SITE/CE/2020-21 Page 31
 AI.SHA

2.4.3 Teacher
Home Page:

Manage Attendance:

Manage Students:

SITE/CE/2020-21 Page 32
 AI.SHA

2.4.4 Student
Home Page:

View Attendance:

SITE/CE/2020-21 Page 33
 AI.SHA

CHAPTER 3

SITE/CE/2020-21 Page 34
 AI.SHA

Advantages and
Disadvantages

3.1 Advantages & Disadvantages

❖ Advantages
• Get rid of the traditional way of taking attendance.

• Report can be generated automatically.

• Storing and retrieval of the data is fast.

• Reduce the use of paper.

• Errors are reduced.

• Can be accessed at anytime and anywhere.

SITE/CE/2020-21 Page 35
 AI.SHA

o Disadvantages
o An internet connection is required.

o Might be less user-friendly in the start.

SITE/CE/2020-21 Page 36
 AI.SHA

CHAPTER 4
System Testing

4.1 Introduction
Once source code has been generated, software must be tested to uncover (and
correct) as many errors as possible before delivery to customer. Our goal is to
design a series of test cases that have a high likelihood of finding errors. To
uncover the errors software techniques are used. These techniques provide
systematic guidance for designing test that Exercise the internal logic of
software components, and Exercise the input and output domains of the
program to uncover errors in program function, behavior and performance.
Internal program logic is exercised using ―White box test case design
Techniques. Software requirements are exercised using ―block box test case
SITE/CE/2020-21 Page 37
 AI.SHA

Design techniques. In both cases, the intent is to find the maximum number of
errors with the Minimum amount of effort and time.

9.2 Testing Methodologies

A strategy for software testing must accommodate low-level tests that are
necessary to verify that a small source code segment has been correctly
implemented as well as high-level tests that validate major system functions
against customer requirements. A strategy must provide guidance for the
practitioner and a set of milestones for the manager. Because the steps of the
test strategy occur at a time when deadline pressure begins to rise, progress
must be measurable and problems must surface as early as possible. Following
testing techniques are well known and the same strategy is adopted during this
project testing.

4.2.1 Unit testing

Unit testing focuses verification effort on the smallest unit of software design-
the software component or module. The unit test is white-box oriented. The unit
testing implemented in every module of student attendance management
System. By giving correct manual input to the system, the data are stored in
database and retrieved. If you want required module to access input or gets the
output from the End user. Any error will accrued the time will provide handler
to show what type of error will accrued.

4.2.2 System testing

System testing is actually a series of different tests whose primary purpose is to
fully exercise the computer-based system. Below we have described the two
types of testing which have been taken for 26 this project. It is to check all
modules worked on input basis .if you want change any values or inputs will
change all information. So specified input is must.

4.2.3 Performance Testing

SITE/CE/2020-21 Page 38
 AI.SHA

Performance testing is designed to test the run-time performance of software

within the context of an integrated system. Performance testing occurs
throughout all steps in the testing process. Even at the unit level, the
performance of an individual module may be assessed as white-box tests are
conducted. This project reduce attendance table, codes. It will generate report
fast.no have extra time or waiting of results .entered correct data will show
result few millisecond. Just used only low memory of our system.
Automatically do not getting access at another software. Get user permission
and access to other applications.

SITE/CE/2020-21 Page 39