Road Transport Authority RTA Information System .Net Project

Abstract:

Road Transport Authority is a C#.Net based web application which enhances the use of RTA Services with ease. In this .Net Project there are 3 Modules

1. RTO
2. Employee
3. Apply For LLR (User)

Employee:

In This Application RTO Will add the employees with details the employee can login by the given username and password. The employee can add the LLR details received from the user. An employee can also renew the LLR of the users. The employee can also generate the payment against issued challan.

Employee performs the following Functions

• Issue of Challans
• View Renewed LLR Details
• View Renewed PL Details
• View Registered Vehicle Details
• View New LLR Registrations
• Can Also view the registration details Monthly Wise

RTO:

RTO Can add the employee details and can view the registration of vehicle details and issue of LLR and PL Details and renewals of LLR and PL. 

User:

The user can simply for LLR by giving all necessary details and then clicking on submitting we are taken to the challan payment page after successful completion of payment we should write the Test for Learning License. After Exam completion, the result will be shown.

UML Diagrams:

Object Diagram:

Activity Diagram Renewal of Learner License And Permanent Licence:

Use Case Diagram:

Class Diagram:

Sequence Diagram:

Existing & Proposed System:

Nowadays we see that using the internet has grown a lot so we need to implement everything online to provide fast and efficient services to the public or users. Users in the earlier days must visit the RTO office to complete the registration of a newly Brought vehicle or to apply an LLR or Pl, which takes a lot of time. Using this application, the RTO and Employee can register the vehicles Using their applications. In this application, we also provided and LLR Test to written online, but in practical to write an LLR we must go to RTO Office and register and wait for a long time. The Whole process is made Simple By this application.

Now in this application generating or extracting the user details are just matter of time because everything which is registered or added is made to store in a centralized database so extracting the details and generating the monthly reports was easy. Previous days we used to maintain or write the records manually, so to search the details or providing the monthly reports was a big task. 

Data Dictonary

• Table Name: Challana details

Column Name	Type	Size
cno	nvarchar	50
name	varchar	50
amount	nvarchar	50
ianame	varchar	50
Ides	varchar	50
Vfrom	Varchar	50
Vto	Varchar	50

• Table Registration details

Column Name	Type	Size
regno	nvarchar	50
regdate	varchar	50
nameofapp	varchar	50
sdwof	varchar	50
age	varchar	50
Add1	varchar	50
Add2	varchar	50
city	varchar	50
state	varchar	50
phno	varchar	50
nameadd	varchar	50
typeofveh	varchar	50
date1	varchar	50
chassisno	varchar	50
engineno	varchar	50
Seatcap	varchar	50
Fuel	varchar	50

• Table Name: LLR details

Column Name	Type	Size
Img_pk	Int	4
Img_title	varchar	50
Img_stream	Image	16
Img_type	Varchar	50
llrno	Varchar	50
ldate	Varchar	50
name	Varchar	50
swd	Varchar	50
dob	Varchar	50
bg	Varchar	50
a1	Varchar	50
a2	Varchar	50
City	Varchar	50
State	Varchar	50
Phone	Varchar	50
Mark	Varchar	50
Vfrom	Varchar	50
Vto	Varchar	50
Type	Varchar	50

• Table Name: Admin

Column Name	Type	Size
Id	nvarchar	50
Password	nvarchar	50

• Table Name: LLR Exam

Column Name	Type	Size
Examno	Varchar	50
Ans1	Varchar	50
Ans2	Varchar	50
Ans3	Varchar	50
Ans4	Varchar	50
Ans5	Varchar	50
Ans6	Varchar	50
Ans7	Varchar	50
Ans8	Varchar	50
Ans9	Varchar	50
Ans10	Varchar	50
name	Varchar	50
Edate	Varchar	50
chalno	Varchar	50

• Table Name:Addemp

Column Name	Type	Size
Id	nvarchar	50
Password	nvarchar	50
Name	varchar	50
Address	varchar	50
phno	varchar	50

• Table Name: Renewal of LLR and PL

Column Name	Type	Size
llr	nvarchar	50
dateofiss	varchar	50
dateofren	varchar	50
typelicence	varchar	50
name	varchar	50
sdw	varchar	50
dob	varchar	50
bloodg	varchar	50
Add1	varchar	50
Add2	varchar	50
city	varchar	50
state	varchar	50
phno	varchar	50
Ident1	varchar	50
Ident2	varchar	50
vfrom	varchar	50
vto	varchar	50
chano	varchar	50
amount	varchar	50

• Table Name:Result

Column Name	Type	Size
aname	nvarchar	50
examno	nvarchar	50
cno	varchar	50
edate	varchar	50
marks	varchar	50
result	Varchar	50

Conclusion:

In all the above advantages we must use this application for fast completion of Process and secure payments using challan details.

Download Road Transport Authority RTA Information System .Net Project Source Code, Project Report