Team ID: 288442

TRICKY TECHNIQUES INTERNSHIP REPORT

A PROJECT REPORT

Submitted by

VISHAL M PATEL

190820107021

In partial fulfilment for the award of the degree of

BACHELOR OF ENGINEERING

In

Computer Engineering

Dr. Jivraj Mehta Institute of Technology, MOGAR

Gujarat Technological University, Ahmedabad

April 2023

Gujarat Technological University Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Dr. Jivraj Mehta Institute of Technology, MOGAR

CERTIFICATE

This is to certify that the project report submitted along with the
project entitled Tricky Techniques has been carried out by Vishal
M Patel (190820107021) under my guidance in partial fulfilment
for the degree of Bachelor of Engineering in Computer
Engineering, 8th Semester of Gujarat Technological University,
Ahmadabad during the academic year 2022-23.

Sign: Sign:
Prof. Riddhi.N.Shukla Ms. Hetal Chokshi
Internal Guide Head of the Department

Gujarat Technological University Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Dr. Jivraj Mehta Institute of Technology

MOGAR

DECLARATION

We hereby declare that the Internship report submitted along with the
Internship entitled TRICKY TECHNIQUES submitted in partial
fulfillment for the degree of Bachelor of Engineering in Computer
Engineering to Gujarat Technological University, Ahmedabad, is a bonafide
record of original project work carried out by me / us at Hatkech Infotech
under the supervision of Mr. Rinkal Jani and that no part of this report has
been directly copied from any students’ reports or taken from any other
source, without providing due reference.

No. Name of the Student Sign of Student

1 Vishal M Patel

Gujarat Technological University Dr. Jivraj Mehta Institute of Technology

Team ID: 288442

Acknowledgement

“I would start by thanking my honourable faculty Prof. Riddhi.N.Shukla

Who has provided me with the necessary guidance and information needed
to complete this internship report. I would like to thank Ms. Hetal Choksi
(CSE-HOD) for giving me technical and non-technical knowledge and
guideline during activation period.

Also, I would like to thank Mr. Rinkal Jani (Instructional designer and
Guide for the training program) for teaching me all the basic of my task and
patiently showing me every elaborate detail and guiding me throughout my
internship period. I would like to thank Mr. Rinkal Jani for answering my
questions related to Tricky Techniques, during my training. I would like to
thank you to Hatkesh Infotech PVT LTD, Bakrol for providing me good
information related to ASP.NET with VB for the development of Tricky
Techniques. I am very thankful to DJMIT”.

Gujarat Technological University i Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Abstract

ASP.NET is a web development platform, which provides a programming

model, a comprehensive software infrastructure and various services
required to build up robust web applications for PC, as well as mobile
devices. ASP.NET works on top of the HTTP protocol, and uses the HTTP
commands and policies to set a browser-to-server bilateral communication
and cooperation.

ASP.NET is a part of Microsoft .Net platform. ASP.NET applications are

compiled codes, written using the extensible and reusable components or
objects present in .Net framework. These codes can use the entire hierarchy
of classes in .Net framework.

The ASP.NET application codes can be written in any of the following

languages:

1) C#, 2) Visual Basic.Net , 3) Jscript, 4) J#

ASP.NET is used to produce interactive, data-driven web applications over

the internet. It consists of a large number of controls such as text boxes,
buttons, and labels for assembling, configuring, and manipulating code to
create HTML pages. .NET is a free, cross-platform, open source developer
platform for building many different types of applications. With .NET, you
can use multiple languages, editors, and libraries to build for web, mobile,
desktop, games, IoT, and more.

Gujarat Technological University ii Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Lists of Figures

Figure No Figure Name Figure Page

1 Registration Page 19
2 Login Page 20
3 Academic Page 21
4 Assignment Page 22
5 Branch Page 23
6 GTU 100 Points Page 24
7 IMP Materials Page 25
8 Lab Manuals Page 26
9 Previous Year Exam Paper Page 27
10 Subject Page 28

Gujarat Technological University iii Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Lists of Tables

Table No. Table Name Table Page

1 ADM_ACADEMIC 12
2 ADM_ASSIGNMENT 12
3 ADM_BRANCH 13
4 ADM_GTU_100_POINTS 13
5 ADM_IMP_MATERIAL 14
6 ADM_LAB_MANUAL 14
7 ADM_PAPER 15
8 ADM_SEMESTER 15
9 ADM_STUDENT_REGISTRATION 16
10 ADM_SUBJECT 16
11 ADM_REGISTRATION 17

Gujarat Technological University iv Dr. Jivraj Metha Institute of Technology

Team ID: 288442

LIST OF ABBREVIATIONS

ASP Active Server Pages

HTML Hyper Text Markup Language

CSS Cascading Style Sheets

SQL Structured Query Language

VS Visual Studio

ADM Admin

XHTML Extensible Hyper Text Markup Language

DBMS DataBase Management System

JS JavaScript

PHP Hyper-Text PreProcessor

Gujarat Technological University v Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Table of Contents
Acknowledgement.........................................................................................i

Abstract.........................................................................................................ii

Lists of Figures.............................................................................................iii
List of Tables................................................................................................iv
List of Abbreviations.....................................................................................v
Table of Contents..........................................................................................vi

Chapter-1 Overview of the Company……………………………………1

1.1 History………………………………………………………………....1

1.2 Different product/Scope of work……………………………………...1

1.3 Capacity of Department……………………………………………….2

Chapter-2 Production Management……………………………………...3

2.1 Work being carried out in each department...…………………………3

2.1.1 Web Solution….…………………………………………………..3

2.1.2 Digital Marketing….……………………………………………...3

2.2 Technical specification of major equipment used in department……..3

2.2.1 Website Development.....................................................................3

Chapter-3 Internship Management............................................................4

3.1 Internship Summary...............................................................................4

3.2 Purpose...................................................................................................4

3.3 Objective................................................................................................4

3.4 Internship planning................................................................................5

3.4.1 Internship development approach & justification...........................6

Gujarat Technological University vi Dr. Jivraj Metha Institute of Technology

Team ID: 288442

3.4.2 Group dependencies........................................................................6

3.5 Internship scheduling.............................................................................6

3.6 Technology & Literature review............................................................7

Chapter-4 System Analysis.........................................................................8

4.1 Study of current system.........................................................................8

4.2 Problem & Weakness of current system...............................................8

4.3 System feasibility..................................................................................9

4.4 Features of New system.......................................................................10

Chapter-5 System Design………………………………………………..11

5.1 System Design……………………………………………………….11

5.2 Database design / Data dictionary……………………………............11

Chapter-6 Implementation………………………………………………18

6.1 Process/Program/Module Specification/Technology….……………..18

6.2 Finding/Results/Outcomes…….………………..……………………18

6.3 System Interface…………………………………………………...…19

Chapter-7 Testing………………………………………………………..29

7.1 Testing plan………………………………………………………..…29

7.2 Test results & analysis……………………………………………….29

7.2.1 Test Cases…….…………………………………………………30

Chapter-8 Conclusion & Discussion……………………………………31

8.1 Dates of Continuous Evaluation…………………………………..…31

8.2 Summary of internship work……………………………………........33

Gujarat Technological University vii Dr. Jivraj Metha Institute of Technology

Team ID: 288442

8.3 Future Enhancement………...……………………………………….34

Appendices……...………………………………………………………...35

References………………………………………………………………...59

Gujarat Technological University viii Dr. Jivraj Metha Institute of Technology

Team ID: 288442

CHAPTER -1 OVERVIEW OF THE

INTERNSHIP

1.1History

Hatkesh Infotech PVT LTD India based company. With more than 14
years of practical experience we bring the experts in Following Web
Technologies as following:

 Photoshop Designers
 Custom WordPress Designing
 Digital Marketing
 PHP/ASP.NET Web Development
 Database Design, Programming and Management

We have envisaged providing solutions to every IT-related problem in

the most cost-friendly way. With this noble vision, we have expanded
globally giving innumerable IT solutions to our widely existing and
growing client and customer. Hatkesh Infotech PVT LTD. In
receptive to new ideas and promise help and support anytime and
anywhere.

1.2 Different product/Scope of work

We offer industry and business consulting with industry focusing

experienced teams and we have done a good number of projects in
Hotels, Engineering, Hospitals, Gyms. The goal of the company is to

Gujarat Technological University 1 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

achieve the growth rate more than 200% by doing Business with
International Market as up to now we are growing by 100% yearly.

1.3 Capacity of Department

Vision: To become the best IT Solutions and Services platform by

giving optimal solutions to Business and Educational Institutions for
their consistent growth.

Mission: To provide such software solutions that is functional,

reliable, maintainable, and Cost-friendly to our existing and growing
Client and customer base. To consistently cater to their growing needs
for an optimal solution, ensuring excellent support and service
platform to give a Hassle-free experience in achieving their dreams.

Gujarat Technological University 2 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

CHAPTER -2 PRODUCTION
MANAGEMENT

2.1 WORK BEING CARRIED OUT IN EACH

DEPARTMENT

2.1.1 WEB SOLUTION: Hatkesh Infotech PVT LTD provides the web
solution services in Web Solution Company provide below:

Types of Services:

 Website Design & Development

 Ecommerce Website Development
 Graphics Design and Service

2.1.2 DIGITAL MARKETING: Hatkesh Infotech PVT LTD provides

the Digital Marketing services Digital Marketing Company provides below
types of services:

 SEO Service
 Social Media Marketing & Content Writing Service

2.2 TECHNICAL SPECIFICATION OF MAJOR

EQUIPMENT USED IN DEPARTMENT

Gujarat Technological University 3 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

2.2.2 WEBSITE DEVELOPMENT: Hatkesh Infotech PVT LTD provides

the website development services in Website Development Company
provide below:

 Java Script
 HTML/CSS
 Databases
 ASP.NET

CHAPTER -3 INTERNSHIP
MANAGEMENT

3.1 INTERNSHIP SUMMARY

We have done our internship at Hatkesh Infotech PVT LTD, Anand. The
internship was for duration about 12 weeks, and it involved a lot of learning
activities all around. Our internship based on .NET Web Development. I
have worked with computers – laptops access to taking other PC or mobile
devices to setup whole project.

3.2 PURPOSE

The purpose of the Tricky Techniques is to provide Study Materials related

to Gujarat Technological University (GTU). Our Tricky Technique website
provides all the necessary details according to various Branches of GTU.
With the help of Tricky Techniques, we can provide educational materials
according to various Branches & Semester - wise IMP Questions list and
give some lecture videos related to particular topic. We help students to

Gujarat Technological University 4 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

complete their GTU 100 Activity Points as soon as possible by using Tricky
Technique. And we can share information and updates related to GTU.

3.3 OBJECTIVE

In Tricky Techniques, there are some of the important objectives as follow:

 Quick access from Anytime & anywhere: Our Tricky Techniques is

one type of digital platform. So, for the use of its user required only a
laptop, smartphones or tablets with an internet connection, students
can easily learn from anywhere at convenient times. Our all kind of
information’s and materials are accessible easily, which makes the
process more streamlined.

 Time Saving: Our Tricky Techniques is a time saving for students

because with the help of its students get all types of information’s and
materials according to various Branches. So, any students find
necessary details in very less time.

 Cost less: Our Tricky Techniques provides students cost less

materials because many students are not able to pay fees, that is why
their study not completed. So, with the help of Tricky Techniques we
want to help these kinds of students to complete their study without
any kind of interruption.

3.4 INTERNSHIP PLANNING

Gujarat Technological University 5 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Internship planning is part of project management, which relates to the use

of schedules such as charts to plan and subsequently report progress within
the project environment. Initially, the project scope is defined and the
appropriate methods for completing the project are determined. The
durations for the various tasks necessary to complete the work are listed and
grouped into a work breakdown structure. Project planning is often used to
organize different areas of a project, including project plans, workloads and
the management of teams and individuals.

3.4.1 INTERNSHIP DEVELOPMENT APPROACH &

JUSTIFICATION

The activities we followed for this project is listed below:

 Planning the work or objectives

 Analysis & Design of objectives
 Assessing & Controlling risk
 Allocation of resource
 Organizing the work
 Database Designing

3.4.2 GROUP DEPENDENCIES

 We participated in live projects of company. So, we were divided with

so many tasks of a project like client handling programming, software
designing, product management, etc.
 We handled client issues and managed the database of the program.

3.5 INTERNSHIP SCHEDULING

Gujarat Technological University 6 Dr. Jivraj Metha Institute of Technology
Team ID: 288442

 Project Scheduling is the culmination of a planning activity that is

primary component of software project management.
 When combined with estimation method sand risk analysis,
scheduling, establishes a road map for the project management.
 Scheduling begins with the process composition. The characteristics
of the project are used to adept an appropriate task set for the work to
be done,
 The task network is used to compute the critical project path, a
timeline chart, and a variety of project information.

3.6 TECHNOLOGY & LITERATURE REVIEW

 The main technological review in our project is HTML, CSS.

3.6.1 HTML
 HTML stands for Hyper Text Markup Language.
 HTML is the standard markup language for creating
Webpages.
 HTML describes the structure of a Webpage.
 HTML consists of a series of elements,
 HTML elements tell the browser how to display the
content.
 HTML elements label pieces of content such as “this is a
heading”, “this is a paragraph”, “this is a link” etc.

3.6.2 CSS
 Cascading Style Sheets, fondly referred to as CSS, is a
simple design language intended to simplify the process
of making webpages presentable.
 CSS handles the look and feel part of a webpage.

Gujarat Technological University 7 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 CSS is used to design HTML tags.

 CSS is independent of HTML and can be used with any
XML based markup language.

CHAPTER -4 SYSTEM
ANALYSIS

4.1 STUDY OF CURRENT SYSTEM

We are building Tricky Techniques, in this application Students & Faculties

can get important details related to GTU according to various branches.
Tricky Techniques provides study materials related to CSE, IT,
MECHANICAL, CIVIL, ELECTRICAL ENGINEERING.

Tricky Techniques provides study materials like IMP Question Bank related
to subjects, some lecture videos, syllabus list etc. Tricky Techniques
provides previous year’s question papers to students to get ideas related to
which types of content asked GTU in external exam.

By using Tricky Techniques students can complete their GTU 100 activity
points without paying any kind of fees, without wasting their time. By using
Tricky Techniques students can complete their study before the exam which
helps to gain better results in any semesters examination’s. Students can

Gujarat Technological University 8 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

complete or learn or revised all the necessary topics, programmes, questions,

examples (sums), algorithms etc, which are most important for exam.

4.2 PROBLEM & WEAKNESS OF CURRENT SYSTEM

 Without internet it is not work

 Required daily News updates
 Marketing of our website is difficult at the starting time

4.3 SYSTEM FEASIBILITY

Feasibility is the measure of how beneficial the development of information

system will be to an organization. Feasibility is the analysis of risks, costs
and benefits relating to economics, technology, and user operation.

There are several types of feasibility depending on the aspect they cover.
Some important feasibility is as follows:

11 Operational Feasibility: Operational feasibility is the measure of

how well a proposal system solves the problems and takes advantages
of the opportunities identified during scope definition and how it
satisfies the requirements identified in the requirements analysis phase
of system development.

12 Technical Feasibility: Technical feasibility is the formal process of

assessing whether it is technically possible to manufacture a product
or service. Before launching a new offering or taking up a client

Gujarat Technological University 9 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

project, it is essential to plan and prepare for every step of the

operations.

13 Schedule Feasibility: Schedule feasibility is the degree to which a

deadline for a strategy, plan, project, or process is realistic and
achievable.
Schedule feasibility can determine if your timetable allows you
enough time to complete the project.

14 Economic Feasibility: Economic feasibility is a kind of cost benefit

analysis of the examined project, which assess whether it is possible to
implement it.
Management can assess economic feasibility by using by doing the
cost benefit analysis as well as using financial techniques, such as time
value of money or break-even point analysis.

4.4 FEATURES OF NEW SYSTEM

 Register/Login
 Branches wise Semester details
 Semester wise Subjects details
 Subjects related Materials details
 GTU related Activity details & information’s
 Easy for study
 Easily passing in exams

Gujarat Technological University 10 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

CHAPTER -5 SYSTEM
DESIGN

5.1 SYSTEM DESIGN

Systems design is the process of defining the architecture, components,

modules, interfaces, and data for a system to satisfy specified requirements.
The system design description report provides summary or detailed
information about a system design represented by a model. System design is
therefore the process of defining and developing systems to satisfy specified
requirements of the user.

5.2 DATABASE DESIGN / DATA DICTIONARY

Database Design or Data Dictionary is defined as a table which below

following points:

Gujarat Technological University 11 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 ADM_ACADEMIC
 ADM_ASSIGNMENT
 ADM_BRANCH
 ADM_GTU_100_POINTS
 ADM_IMP_MATERIAL
 ADM_LAB_MANUAL
 ADM_PAPER
 ADM_SEMESTER
 ADM_STUDENT_REGISTRATION
 ADM_SUBJECT
 ADM_REGISTRATION

 TABLE: ADM_ACADEMIC:
This table stores the data about Academic details i.e., Academic
Calendar and Scholarship information.

Field Name Data Type Allow Key

Nulls
ADM_ACADEMIC_ID int Primary Key
ACADEMIC_CALENDAR Varchar(50) YES
ACADEMIC_CALENDAR_LINK Varchar(MAX) YES
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_ASSIGNMENT:

Gujarat Technological University 12 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

This table stores the data about Assignment, which is according to

various subjects.

Field Name Data Type Allow Key

Nulls
ADM_ASSIGNMENT_ID Int Primary Key
ASSIGNMENT_NAME Varchar(50) YES
ASSIGNMENT_LINK Varchar(MAX YES
)
ADM_BRANCH_ID Int YES Foreign Key
ADM_SEMESTER_ID Int YES Foreign Key
ADM_SUBJECT_ID Int YES Foreign Key
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_BRANCH:
This table stores the data about Branches, which includes Branch
Code and Branch Name.

Field Name Data Type Allow Key

Nulls
ADM_BRANCH_ID Int Primary Key
BRANCH_CODE Varchar(50) YES
BRANCH_NAME Varchar(50) YES
ADM_SEMESTER_ID Int YES Foreign Key
ADM_SUBJECT_ID Int YES Foreign Key
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

Gujarat Technological University 13 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 TABLE: ADM_GTU_100_POINTS:
This table stores the data about GTU 100 Points, which includes
Activity Name, Description.

Field Name Data Type Allow Key

Nulls
ADM_GTU_100_POINTS_ID Int Primary Key
ACTIVITY_NAME Varchar(50) YES
DESCRIPTION Varchar(50) YES
GTU_100_POINTS_LINK Varchar(MAX) YES Foreign Key
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_IMP_MATERIAL:
This table stores the data about IMP Materials related to various
branches, which includes Material Name.

Field Name Data Type Allow Key

Nulls
ADM_IMP_MATERIAL_ID int Primary Key
MATERIAL_NAME Varchar(50) YES
MATERIAL_LINK Varchar(MAX YES
)
ADM_BRANCH_ID Int YES Foreign Key

Gujarat Technological University 14 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

ADM_SEMESTER_ID Int YES Foreign Key

ADM_SUBJECT_ID Int YES Foreign Key
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_LAB_MANUAL:
This table stores the data about Lab Manual, which includes Lab
Manual Code and Lab Manual Name.

Field Name Data Type Allow Key

Nulls
ADM_LAB_MANUAL_ID Int Primary Key
LAB_MANUAL_CODE Varchar(50) YES
LAB_MANUAL_NAME Varchar(50) YES
LAB_MANUAL_LINK Varchar(MAX YES
)
ADM_BRANCH_ID Int YES Foreign Key
ADM_SEMESTER_ID Int YES Foreign Key
ADM_SUBJECT_ID Int YES Foreign Key
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_PAPER:
This table stores the data about Papers, which includes Paper Name,
Code and Year.

Field Name Data Type Allow Key

Gujarat Technological University 15 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Nulls
ADM_PAPER_ID Int Primary Key
NAME_OF_BRANCH Varchar(50) YES
NO_OF_SEMESTER Varchar(50) YES
PAPER_LINK Varchar(MAX) YES
ADM_BRANCH_ID Int YES Foreign Key
ADM_SEMESTER_ID Int YES Foreign Key
ADM_SUBJECT_ID Int YES Foreign Key
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_SEMESTER:
This table stores the data about Semester according to various
Branches, which includes Semester No.

Field Name Data Type Allow Key

Nulls
ADM_SEMESTER_ID Int Primary Key
SEMESTER_NO Varchar(50) YES
ADM_BRANCH_ID int YES Foreign Key
ADM_SUBJECT_ID int YES Foreign Key
ADM_STUDENT_REGISTRATION_ID int YES Foreign Key
ADM_ REGISTRATION_ID int YES Foreign Key

 TABLE: ADM_STUDENT_REGISTRATION:
This table stores the data about Student Registration, which include
Name, Enrolment No, Email ID, Password.

Gujarat Technological University 16 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Field Name Data Type Allow Key

Nulls
ADM_STUDENT_REGISTRATION_ID Int Primary Key
STUDENT_NAME Varchar(50) YES
ENROLLMENT_NO Varchar(50) YES
MOBILE_NO Varchar(50) YES
EMAIL_ID Varchar(50) YES
ADM_STD_ATH_ID Varchar(50) YES
PASSWORD Varchar(50) YES
ADM_BRANCH_ID Int YES Foreign Key
ADM_SEMESTER_ID Int YES Foreign Key
ADM_SUBJECT_ID Int YES Foreign Key
ADM_REGISTRATION_ID Int YES Foreign Key

 TABLE: ADM_SUBJECT:
This table stores the data about Subject according to various Semester,
which includes Subject Code, Subject Name etc.

Field Name Data Type Allow Key

Nulls
ADM_SUBJECT_ID Int Primary Key
SUBJECT_CODE Varchar(50) YES
SUBJECT_NAME Varchar(50) YES
DETAILS_ABOUT_SUBJECT Varchar(50) YES
SUBJECT_LINK Varchar(MAX YES
)
ADM_STUDENT_REGISTRATION_ID Int YES Foreign Key
ADM_ REGISTRATION_ID Int YES Foreign Key
ADM_LAB_MANUAL_ID Int YES Foreign Key

Gujarat Technological University 17 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

ADM_COURSE_ID Int YES Foreign Key

 TABLE: ADM_REGISTRATION:
This table stores the data about Registration according to Students OR
Users necessary details etc.

Field Name Data Type Allow Key

Nulls
ADM_REGISTRATION_ID Int Primary
Key
FIRST_NAME Varchar(50) YES
LAST_NAME Varchar(50) YES
MOBILE_NO Varchar(50) YES
EMAIL_ID Varchar(MAX YES
)
PASSWORD Varchar(50) YES
ADM_ ATH_ID Varchar(50) YES

CHAPTER -6
IMPLEMENTATION

6.1 PROCESS / PROGRAM / TECHNOLOGY / MODULES

SPECIFICATION

Gujarat Technological University 18 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 Clean layouts (i.e., Visual Studio Web Pages, Brackets animated

Pages)
 Client’s Details (Student Name, Enrolment No, Mobile No, Email ID,
Password)
 Finding & Solving Errors:
1. SQL Database Identity Specification error when it turns OFF.
2. Data Type error possible.
3. Error solves in Visual Studio when we connect it with SQL
Server Database. (i.e., Coding base)

6.2 FINDING / RESULTS / OUTCOMES

Technical skills:

 Tools & Technologies

 Learn Development Techniques in Professional Environment
 Converting the Ideas to Action
 Design Frontend Website
 Troubleshoot Errors

Soft & Management skills:

 Designing Skills
 Communication Skills
 Interaction with Project Mentor

Gujarat Technological University 19 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 Decision Making
 Coding Skills

6.3 SYSTEM INTERFACE

1) Registration Page:

The admin or user register using Enrolment No, Email ID, Password on
Tricky Techniques Portal & submit data & then after page move to login
page.

2) Login Page:

Gujarat Technological University 20 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

The admin & student login on the system with correct authentication.
If correct login then open home page of the portal.

3) Academic Page:

Gujarat Technological University 21 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

In the Academic Page, we provide Academic Calendar with it’s

sharable link by using it user see all the necessary details related to
their Academic Calendar.

Gujarat Technological University 22 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

4) Assignment Page:
In the Assignment Page, we provide necessary assignment to user, by
using it they can gets more marks in any kind of examinations.

Gujarat Technological University 23 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

5) Branch Page:
In the Branch Page, we provide some information related to various
Branches of GTU.

6) GTU 100 Points Page:

Gujarat Technological University 24 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

By using this GTU 100 Points Page, we help students for completing
their GTU 100 Activity Points easily. We provide costless certificates
by using our YouTube Channel Vishal’s Techniques. Here, we share
the link to complete their points in short time.

7) IMP Materials Page:

Gujarat Technological University 25 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

By using this Page, we provide IMP Questions list as per Subjects and
according to various of GTU. Here, for some common subjects and for
Computer Engineering Subjects, we shared our YouTube Channel link
for providing IMP Materials to student. Our official YouTube Channel
is Vishal’s Techniques.

8) Lab Manuals Page:

Gujarat Technological University 26 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

By using this page, we provide some Lab Manuals to students for their
practical knowledge. Here, we provide sharable links of various Lab
Manuals. Just click on the link and you can see described Lab Manual.

9) Previous Year Exam Paper Page:

Gujarat Technological University 27 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Here we provide previous year exam papers, by using these student

gets some information’s related to paper style and more. Here, we
provide last 3 years Exam papers including all branches i.e., CSE, IT,
CIVIL, EE, MECH, and all semesters Exam papers to students.

10) Subject Page:

Gujarat Technological University 28 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

By using Subject Page, we provide Details about Subjects according

to Branches like: CSE, IT, CIVIL, EE, MECHANICAL. We provide
sharable links for watching various Subjects details. Here, we provide
subject syllabus links for understanding what kind of actual content
include as per various subjects of various branches.

CHAPTER -7
TESTING

Gujarat Technological University 29 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

7.1 TESTING PLAN

Test Case for Tricky Techniques: In this post below, we discuss test cases
for the Tricky Techniques. The system under test is taken from the
language .NET. You can check the below to get more ideas about the Tricky
Techniques.

If you are interested in looking at even better features and the complex
Tricky Techniques then I suggest checking the free open-source software
available. That way, you can practice writing test cases more effectively.

7.2 TEST RESULTS & ANALYSIS

Testing and validation are the most important steps after the implementation
of the developed system. The system testing is performed to ensure are no
errors in the implemented system. The software must be executed several
times to find out the errors in the different modules of the system. Validation
refers to the process of using the new software for the developed system in a
live environment i.e., new software inside the organization, to fine out the
errors.

The validation phase reveals the failure and the bugs in the developed
system. It will be come to know about the practical difficulties the system
faces when operated in the true environment. By testing the code of the
conducted to check whether the specification stating the program are
performing under various conditions. Testing may be done at given levels:

 Identity Specification Test in SQL Server Database

 Visual Studio Connection Test while it connected to the SQL Server
Database
 Validation Testing in Visual Studio

Gujarat Technological University 30 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 Web browser Data Testing Test

 Acceptance Testing

7.2.1 TEAST CASES

 A test case is a singular set of actions or instructions for a tester to

perform that validates a specific aspect of productor application
functionality.
 The test cases to consider in the internship are:
1. Separate authentication for both the front end as well as back
end.
2. Inclusion of all eligible data and modules to be tested.
3. Testing individual module according to requirement.
4. Privacy to the admin as well as user who becomes the part of
System.
5. Updating if the information from time to time.

Gujarat Technological University 31 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

CHAPTER -8 CONCLUSION &

DISCUSSION

8.1 DATES OF CONTINUOUS EVALUATION

 Review - I: 28/02/2023
 Review – II: 15/04/2023

Gujarat Technological University 32 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

 Review – III: 04/05/2023

Gujarat Technological University 33 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

8.2 SUMMARY OF INTERNSHIP WORK

In this internship I had work on .NET language at Hatkesh Infotech PVT

LTD, for this internship I learnt so many points or features of .NET
language. I learnt about how SQL Server Databases and Visual Studio2012
are used to develop website.

First I learnt about SQL Server Database. In it we learnt about how to make
new Database and after making New Database how to add necessary tables
we are related to our project. Learnt about how to give primary key and
foreign key to necessary table. After that I learnt about how to crate
Database Diagram. Now, finally I learnt about how to crate view of our
crated project related Database.

Gujarat Technological University 34 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Second I learnt about Visual Studio 2012. In it I learnt about how make
various types of webpages related to our project. After making various
webpages I learnt about how to make changes in the downloaded Free CSS
Templates and prepared new website. After that I learnt about how to add
master page in project. After that I learnt about how to link Visual Studio
Webpages with SQL Server Database which are related to our project. After
that we run all the pages for testing. After that I learnt about how to run
Admin Panel in Visual Studio to run our project properly and make some
changes. Here, we add Master Entry & Account Entry modules.

After all the necessary changes and proper designing, testing, analysis we are
work on finding domain name of our website, and after taking domain name
we are able to live our website project.

8.3 FUTURE ENCHANCEMENT

 Try to provide other Technical Courses.

 Share accurate information related to Courses.
 Try to provide these courses in less price or free of cost.
 Try to provide practical knowledge.
 Try to provide accurate study materials.
 More features include in this project.

Gujarat Technological University 35 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

APPENDICES

WEEK 1:

Gujarat Technological University 36 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 37 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 2:

Gujarat Technological University 38 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 39 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 3:

Gujarat Technological University 40 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 41 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 4:

Gujarat Technological University 42 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 43 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 5:

Gujarat Technological University 44 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 45 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 6:

Gujarat Technological University 46 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 47 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 7:

Gujarat Technological University 48 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 49 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 8:

Gujarat Technological University 50 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 51 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 9:

Gujarat Technological University 52 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 53 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 10:

Gujarat Technological University 54 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 55 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 11:
Gujarat Technological University 56 Dr. Jivraj Metha Institute of Technology
Team ID: 288442

Gujarat Technological University 57 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

WEEK 12:

Gujarat Technological University 58 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

Gujarat Technological University 59 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

REFERENCES

Gujarat Technological University 60 Dr. Jivraj Metha Institute of Technology

Team ID: 288442

1) GTU Study-
https://gtustudy.in/gtu-1st-year-books-study-material/

2) GTU Materials-
https://gtu-materials-4-diploma.blogspot.com/

3) Darshan University-
https://www.darshan.ac.in/gtu-study-material

4) Vision Paper GTU-

https://visionpapers.in/gtu/

5) Vishal’s Techniques-
https://www.youtube.com/@vishalstechniques

Gujarat Technological University 61 Dr. Jivraj Metha Institute of Technology