The MySql RDBMS Database will be used for storing all the persistence data uch as data concerning the customers, transactions (reservation, rental and ayment), vehicles and location.
3
Online Vehicle Rental Reservation System
3.6.1- Attributes domain
Table Attribute Domain Domain Type Location name(pk)
50 variable character 200 variable character
variables characters variables characters ariables characters 20 variables characters Double
50 variables characters 50 variables characters Date
50 variables characters
50 variables characters
mber
location 50 variables characters Varchar
rate Double
Online Vehicle Rental Reservation System Table Attribute Domain Domain Type Category Group(primary key)
te kly rate
30 character Varchar
Category
16 variables characters 200 variables character
3.6.2 – Functional Requirement
3.6.2.1 – Login Requirements
Purpose The purpose of this is e member
authentication
part of the application to provid
Inputs The user will enter two inputs throu is unique for every user and password.
gh keyboard. Inputs are user ID which
Processing The input will have to be verified by checking if the ID already exists in the database and the entered password matches the one in database
Outputs The output of the login function will be a menu screen that has list of operation user allowed to choose. If the user enters the ID that does not
exist in se or the entere rd does not d in
the database, the user will simply to re-enter the inputs
the databa d passwo match passwor
Online Vehicle Rental Reservation System
3.6.2.2 – New e ion Requireme
Purpose The new customer re ature of this ap allows the c re to beco mber enter his data y the rental vehicle company.
end user (Custom r) Registrat nts
gistration fe plication
ustomer desi me a me needed b
Inputs The user will enter some t of Customer ID d, complete
A ne number se n
data consis , Passwor
ddress, Pho , Email and Driving Licen umber.
Processing O customer da it w aved in an
appropriate format in d l ha verified for
correctness. For exam il da follow the
standard used and zip eric user enters
incorrect information, he it.
nce the ta has been entered, ill be s atabase. The data wil ve to be ple, the format for Ema ta should code should always num . If the will be asked to re-enter
Outputs The output of this function will be a statement letting the user knows that all data was entered correctly and saved. If the user enters incorrect information, an error message asking the user to re-enter it will be displayed. Once all inf correctly entered, the program will go back to the login screen so that the new customer may perform login action.
ormation is
3.6.2.3 – Adding or updating end user (Customer) Data Requirements
e information corresponding to a new customer or existing Purpose The adding or updating customer data feature of this application allows the
user to enter th customer.
Inputs The user will enter some data consist of Customer ID, Password, complete Address, Phone number, Email and Driving License number.
Processing Once the customer data has been entered, it will be saved in an appropriate format. The data will have to be verified for correctness, for example, the format for Email data should follow the standard used and zip code should always numeric. Any incorrect information will be asked to re-enter.
Outputs The output of this function will be a statement letting the user knows that all
Online Vehicle Rental Reservation System data was entered correctly and saved. For incorrect information, an error message asking the user to re-enter it will be displayed. Once all information is correctly entered, the menu screen will be displayed and user may perform another action.
3.6.2.4 – Add Purpose
ing or Updating Vehicle Data Requirements
The adding or updating vehicle data feature allows the user to enter the information corresponding to a new vehicle or existing vehicle.
Inputs The user will enter some data consist of Vehicle ID, Vehicle Type of the vehicle, model, year, color, Location of the vehicle, Registration number and status of the vehicle.
Processing
t information will be asked to re-enter.
Once the vehicle data has been entered, it will be saved in an appropriate format. The data will have to be verified for correctness, for example, the format for Registration number and year should always numeric. Any incorrec
Outputs The output of this function will be a statement letting the user knows that all data was entered correctly and saved. For incorrect information, an error message asking the user to re-enter it will be displayed. Once all
ed and user may perform another action.
information is correctly entered, the menu screen will be display
3.6.2.5 – Adding or Updating Location Requirements
Purpose This feature of this application allows the user to enter the information corresponding to a new location or existing location.
Inputs The user will enter some data consist of Location ID, and complete address.
Processing
tness, for example, the format for zip code should always numeric.
Once the location data has been entered, it will be saved in an appropriate format in database. The data will have to be verified for correc
Any incorrect information will simply be asked to re-enter.
Outputs The output of the adding or updating location function will be a statement letting the user knows that all data was entered correctly and saved. For
Online Vehicle Rental Reservation System incorrect information, an error message asking the user to re-enter it will be displayed. Once all information is correctly entered, the menu screen will be displayed and user may perform another action.
3.6.2.6 – Ma Purpose
data needed by the rental vehicle company.
king Reservation Requirement
The making reservation feature allows the customer to make a reservation by simply enter reservation
Inputs The user will enter three inputs through keyboard. Inputs entered are reservation date, pickup date, and drop date. Other data needed are simply chosen by clicking mouse.
Processing Once the reservation data has been entered, it will be saved in an appropriate format. The data will have to be verified for correctness, for example, the format for dates should always numeric and follow some standard. Any incorrect information will simply be asked to re-enter.
Outputs
ved. For incorrect information, an error message asking the user to re-enter it will be displayed. Once all
een will be displayed and user may perform another action.
The output of this function will be a statement letting the user knows that all data was entered correctly and sa
information is correctly entered, the menu scr
Online Vehicle Rental Reservation System
3.7 – SYSTE
For the client, the hardware requirement is at least Intel Pentium III 300 64 MB RAM. Keyboard and Mouse are needed as input device, and monitor is needed as output device. The system
ern The o XP, Mac O
Microsoft In va Script and shockwave/flash are
M REQUIREMENT
MHz or 800 MHz Athlon which has at least
needs int et connection to operate.
perating system needed is whether Windows 98, Me, NT, 2000 or S and Linux. To run the application, Netscape Navigator and ternet Explorer that support Ja
required. The different browsers will show the different view.
Online Vehicle Rental Reservation System
3.8 –
rental reservation system is the method which
CONCLUSION
In conclusion, the main objective of this chapter is to get the detail concept of the system before it will be design and implement. In this chapter, requirement analysis and design for online vehicle
the logical and physical design is implemented. It includes data flow diagram, entity relationships, attributes domain, system requirement and requirement specification. Therefore, the system can be seen in logical concept that might create new ideas for the implementation phase.
Online Vehicle Rental Reservation System
CH
system functionality.