Transcription
A Project Presentation onOnline Car Rental SystemSubmitted To:Department of Computer Science,Ganpat University,384012Group No: 74Submitted By:Internal Guide:Khushbu Patel (13084231136)Niyati Patel (13084231163)Mr. Amit B.Suthar
INDEXSr. NoTitlePage No1Abstract (Project Profile)12Existing System23Need for new System34Functional Specification45Hardware and Software Requirement76System Flow Chart97Timeline Chart108E-R Diagram119UML Diagrams129.1 Use Case Diagram139.2 Activity Diagram159.3 Class Diagram179.4 Sequence Diagram189.5 Collaboration Diagram20Data Dictionary2210
Sr. NoTitlePage No11Input Design3012Output Design6213Testing6514Post Implementation Review6815Future Enhancement6916Bibliography70
PROJECT PROFILEProject NameOnline car rental systemObjectiveIt is a system design specially for large, premium and small car rentalbusinessThe car rental system provides complete functionality of listing andbooking car.In this system, Tourism and Travelling facilities also provide.PlatformwebsiteFront EndAsp . NET 4.0 with c#Back EndMicrosoft Sql Server 2008Other ToolsMS Office 2007 , Crystal Report ,Visio 2007Project Duration90daysInternal GuideMr. Amit B. Suthar1
EXISTING SYSTEM An existing system can provide manually paper work. The user has to go in the office where user can get the car on rent and book their car. In the existing system you can not provide feedback of the user to the admin online.2
NEED FOR NEW SYSTEM The new system is totally computerized system. A new system provides features like time efficiency to show car details, user profilesand whatever the customer will give the feedback to the admin. This system provides tourism and travelling facilities. An inquiry is easily done by user in the system. It is the most software application for managing online car rental business.3
FUNCTIONAL SPECIFICATIONSUSER SPESIFICATION Admin :Admin can add a car, manage booking car and rent and also view feedback andenquiry. User :User can view information of available car, booking car, easily get the car on rentand also give feedback and can enquiry.4
MODULE SPECIFICATION View Availabale Cars :It is a system design specially for large, premium and small car rental business.The user can view Available cars and user can book for that car. Booking Car :The user can view Available cars and user can book for that car. Easily Get the Car on rent :The Customer can easily get the car whenever they need to on the rent with use ofthis system. Give Feedback :The customer will give the feedback to the admin. Enquiry:The inquiry can easily done by user.5
Add Car :The Admin can add the car so that The user can see the available cars and book thecar. Manage Rent :The Admin can manage the rent so that The user can see the rent and book the car. View Feedback :The admin easily view the feedbacks and solve the query.6
HARDWARE REQUIREMENTClient side:RAM512 MBHarddisk10 GBProcessor1.0 GHzRAM1 GBHarddisk20 GBProcessor2.0 GHzServer side:7
SOFTWARE REQUIREMENTClient side:Web BrowserInternet Explorer 6 or anycompatible browserOperating SystemWindows or any equivelent OSWeb ServerIIS 7.5Framework.NET 4.0 with C#Database ServerMS SQL Server 2008Web BrowserInternet Explorer 6 or anycompatible browserOperating SystemWindows Server 2007Server side:8
SYSTEM FLOWCHART9
TIME LINE CHART10
E-R DIAGRAM11
UML DIAGRAM12
USE CASE DIAGRAM FOR ADMIN13
USE CASE DIAGRAM FOR USER14
ACTIVITY DIAGRAM FOR ADMIN1515
ACTIVITY DIAGRAM FOR USER16
CLASS DIAGRAM FOR CAR RENTAL SYSTEM17
SEQUENCE DIAGRAM FOR ADMIN18
SEQUENCE DIAGRAM FOR USER19
COLLABORATION DIAGRAM FOR ADMIN20
COLLABORATION DIAGRAM FOR USER21
DATA DICTIONARY22
Admin:Table NameAdminDescriptionThis table is store information about AdminPrimary KeyA idForeign Key-Sr. NoField NameData type(Size)ConstraintsDescription1A idIntPrimary KeyIt is store Admin id2A NameVarchar(10)Not NullIt is store admin name3PasswordVarchar(20)Not NullIt is store the password of Admin4Contact NoVarchar(12)NotNullIt is store the Contact no of Admin5E mailVarchar(70)NotNullIt is store the Email id of Admin23
User Registration:Table NameUserMasterDescriptionThis table is provide the information about User registrationPrimary KeyU IdForeign Key-Sr.NoField NameData type(Size)ConstraintsDescription1U IdIntPrimary KeyIt is store User id2Full nameVarchar(50)Not NullIt is store User name3PasswordVarchar(20)Not NullIt is store Password4AddressVarchar(100)Not NullIt is store address of User5BirthdateDatetimeNot NullIt is store Birthdate6Contact NoVarchar(12)Not NullIt is store Contact no7EmailVarchar(50)Not NullIt is store email address of User24
Car Table:Table NameCarDescriptionThis table is provide the information about CarPrimary KeyC IdForeign Key-Sr. NoField NameData type(Size) ConstraintsDescription1C IdIntPrimary KeyIt is store Car id2Model NameVarchar(20)Not NullIt is store Model name3BrandVarchar(20)Not NullIt is store Brand of the car4ColorVarchar(10)NotNullIt is store Color name of the car5No of PasVarchar(10)NotNullIt is store information of passengerseats6PriceIntNotNullIt is store price of the car7ImageVarchar(50)NotNullIt is store images of car8FueltypeVarchar(10)NotNullIt is store fueltype in car25
Booking Table:Table NameBookingDescriptionThis table is provide the information about book the carPrimary Key-Foreign KeyCar IdSr. NoField NameData type(Size) ConstraintsDescription1C IdIntForeign KeyIt is references to C Id from car2NameVarchar(20)Not NullIt is store name of the car3DateDateTimeNot NullIt is store booking date4S addressVarchar(50)NotNullIt is store source address5D addressVarchar(50)NotNullIt is store information aboutdestination address6Email IdVarchar(50)NotNullIt is store email address7No PiecesIntNotNullIt is store information how many caravailable in time8Contact NoVarchar(12)NotNullIt is store Contact no of user26
Enquiry Table:Table NameEnquiryDescriptionThis table will store the information of car enquiry of userPrimary KeyE IdForeign Key-Sr. NoField NameData type(Size) ConstraintsDescription1E IdIntPrimary KeyIt is store enquiry id2User NameVarchar(20)Not NullIt is store user name3Email IdVarchar(50)Not NullIt is store email id4Contact NoVarchar(12)NotNullIt is store contact no for user5Date FromDateTimeNotNullDisplay date of which the car shouldtake6To DateDateTimeNotNullDisplay date that is required date willcome7QueryVarchar(50)NotNullIt is store query of the user27
Feedback Table:Table NameFeedbackDescriptionThis table store information about feedbackPrimary KeyF IdForeign Key-Sr. NoField NameData type(Size) ConstraintsDescription1F IdintPrimary KeyIt is store feedback id2F NameVarchar(20)Not NullIt is store user name3Email IdVarchar(50)Not NullIt is store email id4AddressVarchar(50)NotNullIt is store user address5CityVarchar(20)NotNullIt is store user city name6Postal CodeVarchar(6)NotNullIt is store postal code7Phone NoVarchar(12)NotNullIt is store phone no of user8ServiceVarchar(20)NotNullIt is store service of user required9OpinionMAXNotNullIt is store user opinion28
Payment Table:Table NamePaymentDescriptionThis table store information about paymentPrimary KeyP IdForeign Key-Sr. NoField NameData type(Size) ConstraintsDescription1P IdIntPrimary KeyIt is store Payment id of user2Car NameVarchar(20)Not NullIt is store Car name3EmailVarchar(70)NotNullIt is store email id for user4AmountIntNotNullIt is store Amount of car rent29
INPUT DESIGN30
User Home page: This is home page of User.31
Service page: This is Service page of User.32
Continue This is Service page of User.33
Catalogue page: This is Catalogue page of User.34
Registration Validation page: This is validation page of User Registration.35
Registration page: This is page of User Registration.36
Registration Successfully: This page is display User Registration successfully.37
Login page: This is login page of User.38
Forgot Password page: This is forgot password page of user.39
Booking page: This is booking page of User.40
Booking Successfully page: This is booking successfully page of User.41
Payment page: This is payment page of user.42
Payment Receipt page: This is payment receipt page of user.43
Booking Cancellation page(Sign in): This is booking cancellation Sign in page of User.44
Booking Cancellation page: This is booking cancellation page of User.45
Booking Cancellation Successfully: This is booking cancellation successfully page of User.46
Terms & Condition page: This is terms & condition page of user.47
Enquiry page: This is Enquiry page of user.48
Feedback page: This is feedback page of User.49
Feedback successfully page: This is feedback successfully page of User.50
About us page: This is about us page of user.51
Contact us page: This is contact us page of User.52
Admin Login page: This is login page of admin.53
Admin Home page: This is home page of admin.54
Add Car page: This is add car page of admin.55
Edit Car page: This is edit car page of admin.56
Delete Car page: This is delete car page of admin.57
Manage Reservation page: This is manage reservation page of admin.58
Manage Booking page: This is manage booking page of admin.59
Renting Status page: This is Renting status page of admin.60
View Feedback page: This is view feedback page of admin.61
OUTPUT DESIGN62
User Registration Report: This is report for User Mst page.63
Car Report: This is report for add car page.64
TESTING65
No1Data inputAll files are empty2Email3Password and confirmpassword45LoginUserExcepted OutputActual OutputError message:Error message:*indicates compulsory field**indicates compulsory field*Error message: Invalid Email-address Error message: InvalidEmail-addressError message:Error message:Both Password does not matchBoth Password does notmatchLogin to the system should be tryLogin should be successfulwith the login assigned by the admin and the user should enterand the correct passwordinto the systemThe System give an error and deniedfrom the Login.Login should be allow and admin getAdmin home page.Login should be allow and Traveladmin get Travel admin home page.Login should be allow and User getVisitor side User page.Login should fail with anerror ‘Invalid Details’Login successfully andadmin get its admin homepageLogin successfully andTravel admin get its Traveladmin home pageLogin successfully and Usergets its user page.Pass / FailPassPassPassFailPassPassPassPass66
6Pre-define format must beValidation Test cases required in controlSystem give error to entervalid inputEnter data in a compulsory field Data must be field inwith required field validations. compulsory field otherwiseits messages are displayed.PassPass67
POST IMPLEMENTATION The website application is self –maintained. The project support already multiple Car . There is no need provide post implementation support. The admin can access add ,edit ,delete process.68
FUTURE ENHANCEMENT Add new car is represent the car list. The User payment for the current receipt of the payment. Add the current project for booking easy.69
BIBLIOGRAPHY Book Reference:Asp.net with c# by Shyam N.Chavda.Author :-Shyam N.Chavda Web Reference: www.code-project.com www.asp.net www.ASPdotnet-suresh.com www.msdn.com70
Other Tools MS Office 2007 , Crystal Report ,Visio 2007 Project Duration 90days Internal Guide Mr. Amit B. Suthar 1 . EXISTING SYSTEM An existing system can provide manually paper work. The user has to go in the office where user can get the car on rent and book their car. In the existing s
