software development document ceng 407 version 2 · online car rental web site ... srs software...
TRANSCRIPT
1
ÇANKAYA UNIVERSITY
FACULTY OF ENGINEERING
COMPUTER ENGINEERING DEPARTMENT
Software Development Document
Ceng 407
Version 2
ONLINE CAR RENTAL WEB SITE
Özlem ŞAHİNER 201111045
Zehra GÜLEN 201111023
Cansun DEMİREL 201111014
ADVISOR: Roya CHOUPANI
2
Table Of Contents
Figure ................................................................................................................... 4
1.Introduction ...................................................................................................... 6
1.1 Purpose ....................................................................................................... 6
1.2 Scope ........................................................................................................... 6
1.3 Glossary ...................................................................................................... 6
1.4 Overview of Document ............................................................................. 7
2.Deployment ....................................................................................................... 7
2.1 Client .............................................................................................................. 7
2.2 Server ......................................................................................................... 7
2.3 Ms-Sql ........................................................................................................ 7
2.4 Asp.Net ....................................................................................................... 7
2.5 C# ................................................................................................................ 8
3. System Architecture ........................................................................................ 8
4. GUI Design ....................................................................................................... 8
4.1 Login Page ................................................................................................. 9
4.2 Customer Page ....................................................................................... 11
4.3 Employee Page......................................................................................... 13
4.4 Manager Page .......................................................................................... 14
5. Work Follow .................................................................................................. 16
5.1 Manager Sequence Diagram .................................................................. 16
5.2.Employee Sequence Diagram ................................................................ 17
5.3.Customer Sequence Diagram ................................................................ 18
5.4 General System Sequence Diagram ...................................................... 19
6. Database Design ............................................................................................ 20
6.1 Tables ....................................................................................................... 20
3
6.1.1 Customer Table ................................................................................ 20
6.1.2 Car Informatıon To Be Rented Table ............................................ 20
6.1.3 Rental Car Table ............................................................................. 21
6.1.4 Customer Passport Table ............................................................... 22
6.1.5 Customer Licence Table ................................................................. 22
6.1.6 Guide Table .................................................................................... 22
6.1.7 Interpreter Table ............................................................................ 23
6.1.8 Chauffeur Table ............................................................................... 23
6.1.9 Reserving Car Table ........................................................................ 23
6.1.10 Payment Table ................................................................................ 24
6.2 Database Diagram ................................................................................... 25
6.3 E-R Diagram ............................................................................................ 27
6.4 Block Diagram ......................................................................................... 28
4
Figure
Figure 1: System Architecture ........................................................................... 8
Figure 2: Login Page ........................................................................................... 9
Figure 3: Customer Page .................................................................................. 11
Figure 4: Employee Page .................................................................................. 13
Figure 5: Manager Page ................................................................................... 14
Figure 6: Employee Sequence Diagram .......................................................... 17
Figure 7: Customer Sequence Diagram .......................................................... 18
Figure 8: General System Sequence Diagram ................................................ 19
Figure 9: Database Diagram ............................................................................ 25
Figure 10: E-R Diagram ................................................................................... 27
Figure 11: Block Diagram ................................................................................ 28
5
Tables
Table 1: Login Page .......................................................................................... 10
Table 2: Customer Page ................................................................................... 12
Table 3: Employee Page ................................................................................... 14
Table 4: Manager Page ..................................................................................... 15
Table 1: Customer Information ....................................................................... 20
Table 2: Car Informatıon For Rental ............................................................. 21
Table 3: Rental Car Information..................................................................... 22
Table 4: Customer Passport Information ....................................................... 22
Table 5: Customer Licence Information ........................................................ 22
Table 6: Guide Information ............................................................................. 23
Table 7: Interpreter Information .................................................................... 23
Table 8: Chauffeur Information ...................................................................... 23
Table 9: Reserving Car Information ............................................................... 24
Table 10: Payment Information ...................................................................... 24
6
1.Introduction
1.1 Purpose
Online car rental web site to provide the requirements of the target software project. In this
system, the target is the system administrator, employees and customers. With the system we
have developed, it is aimed to reach the customers quickly by means of the categories
determined by the information of the vehicles they want to rent. The car rental system
provides the information of the vehicles in categories so that users can easily access the
desired information and contents about the vehicle they are looking for. In this way, users
will be able to access the route they need without any problems. The car rental system
enables the customers to make quick transactions on the solutions offered to the customers
and to transfer the transactions to the system. Thanks to this system, users will have the
opportunity to solve their needs quickly. The car rental system project aims to rent the vehicle
that the customers need. The purpose of the system will be to provide a quick access to the
system by responding to the needs of the users.
1.2 Scope
The scope of the software is that the user can rent the vehicle he / she wants by signing up
and logging on the site via a website which is easily understood by the users. On this count, it
will be easier to achieve goals such as reaching more people. The entire system will be
created between the site users and the administrator. In the project, C # language is preferred
because of its new generation programming language and high performance that MsSQL
provides. The forms that users will use in their relationship to the system are outlined in the
interface design section. Variables, functions, parameters and types are given and all these
values can be changed or improved during implementation.
1.3 Glossary
MicroSoft SQL Server is a database server
software. It provides the creation and
management of databases.
MSSQL
Web application language that runs on the
Net Framework which is developed by
Microsoft.
ASP.NET
One of the next generation programming
languages developed for Microsoft .NET
technology.
C#
It is an integrated development environment
developed by Microsoft. Microsoft Visual Studio
7
A location on the World Wide Web Website
A mobile app is a software application
designed Application
Software Requirements Specification SRS
Software Design Descripton SDD
1.4 Overview of Document
In the parts of the document, design decisions to be taken in the system, steps to be followed
in the direction of these decisions, assumptions, dependencies, software hardware
environments, end user environment, compliance with the standards are detailed. It also
includes the components of the software and hardware environments, the components'
relationships with the classes, and the diagrams and diagrams of what needs are needed to
work together.
2.Deployment
2.1 Client
The client sends requests to the servers to perform their transactions. The resulting result after
the processing of the code is seen with the help of the user browser.
2.2 Server
It has many interfaces for ASP.NET users. There are many components such as email forms,
database lists, and so on.
2.3 Ms-Sql
MSSQL extract data from the database, record data in the database, update the data, and
delete the records.
2.4 Asp.Net
It has many interfaces for ASP.NET users. There are many components such as email forms,
database lists, and so on.
8
2.5 C#
The next generation programming language, C #, runs everywhere that supports the .net
framework.
3. System Architecture
Figure 1: System Architecture
4. GUI Design
The gui design of Online Car Rental Web Site is made by Microsoft Visual Studio. In this
section, the forms that the users will use in relation to the system are given in general terms
independent of the modules and objects, and it is thought that it will be better to leave the
objects and modules to be used in the design stage.
9
4.1 Login Page
Figure 2: Login Page
10
Name Login Page
Type Web Page
Description This page includes four tabs which are username, password fields, login button
and remember me.
Attributes • Username
• Password
Operations • Login
• Enter username
• Enter password
Returns When customer clicks login button, customers redirected to login page. When
customer clicks remember me, system does not forget this user.
Pre-
Condition
Internet Connection
Post-
Condition
-
Exceptions • If the customer password is entered incorrectly, the system will not
open.
• If the customer enters the password correctly, the information will be
approved and the system will be turned on.
Table 1: Login Page
11
4.2 Customer Page
Figure 3: Customer Page
Name Customer Page
Type Web Page
Description It is the page used by the customer. Customer only uses online this page. This
pace includes seven buttons which are view rental car, reserving car, guide
12
interpreter, chauffeur and entry and exit hours.
Attributes -
Operations • Rental Car Page
• Reserving Car
• Guide
• Interpreter
• Chauffeur
• Entry and Exit Page
Returns The customer can see all the car information from the main page, but when he
rents the car he cannot do anything without registering in the system. When
recording to the system, it will be able to do all the operations in order.
Pre-
Condition
• Internet Connection
• When the customer rents the car, the system must be registered.
Post-
Condition
-
Exception The customer will get a bug or warning when he tries to rent a car without
registration.
Table 2: Customer Page
13
4.3 Employee Page
Figure 4: Employee Page
Name Employee Page
Type Web Page
Description Employees are the people who manage the site here. On this page you can add,
update or delete cars. The employee is often referred to as the manager of this
site. Because the manager has all the authority of the site, but the employee will
not do the work. For this reason, the employee will make the registration system
of the site, the car information system, the database system and the overall
design of the site.
Attributes -
Operations • View, update and delete rental car page
• View and changing reserving car ne page
• View, update and delete guide, interpreter and chauffeur page
• And update all other properties of the site.
Returns When employee clicks login button, employee will be directed to five page
segments. When employee clicks rental car, employee redirecting to rental car
page. This site will be guided like this.
Pre- • Internet Connection
14
Condition • The employee has to log in to the system.
Post-
Condition
Employee enters car information and updating some information.
Exception If the employee is not logged in to the system to enter the site he will receive an
error message.
Table 3: Employee Page
4.4 Manager Page
Figure 5: Manager Page
Name Manager Page
Type Web Page
Description Manager use online this page. The manager has all the authority on the site. The
15
manager can see the payment page and report page that the employee has not
seen. The manager can add, update and delete all car information. The manager
can check the entry and exit times of the employee's site.
The manager can make all the changes he wants on the site. But he has
transferred all work to work by employing workers.
Attributes -
Operations • View, update and delete rental car page
• View and changing reserving car page
• View, update and delete guide, interpreter and chauffeur page
• View and update payment page
• View and update report page
• And update all other properties of the site.
Returns When employee clicks login button, employee will be directed to five page
segments. When employee clicks rental car, employee redirecting to rental car
page. This site will be guided like this.
Pre-
Condition
• Internet Connection
• The employee has to log in to the system.
Post-
Condition
Manager enters all information and views all information of site.
Exception If the manager is not logged in to the system to enter the site he will receive an
error message.
Table 4: Manager Page
16
5. Work Follow
5.1 Manager Sequence Diagram
Figure 6 : Manager Sequence Diagram
17
5.2.Employee Sequence Diagram
Figure 7: Employee Sequence Diagram
18
5.3.Customer Sequence Diagram
Figure 8: Customer Sequence Diagram
19
5.4 General System Sequence Diagram
Figure 9: General System Sequence Diagram
20
6. Database Design
The data includes the rental car database. Data shows attributes, types, and attribute size from
this systems. The relations are shown in the E-R diagram. The data fiels define in section
which appears in below.
6.1 Tables
6.1.1 Customer Table
Attribute Name Attribute Type Attribute Size
int CustomerId
50 nvarchar(50) Name
50 nvarchar(50) Surname
int Age
50 nvarchar(50) City
50 nvarchar(50) Phone
50 nvarchar(50) Emailg
int Driving_licenceId
int PassportId
int TC_Id
Table 1: Customer Information
6.1.2 Car Informatıon To Be Rented Table
Attribute Name Attribute Type Attribute Size
int R_CarId
50 nvarchar(50) Brand
21
50 nvarchar(50) Model
50 nvarchar(50) Color
date Year
50 nvarchar(50) Plate
int Km
image Photograph
50 nvarchar(50) Fuel
50 nvarchar(50) BodyType
int EngineeCapacity
int EngineePower
Table 2: Car Informatıon For Rental
6.1.3 Rental Car Table
Attribute Name Attribute Type Attribute Size
int RentalCarId
int CustomerId
int R_CarId
int PaymentId
date RentalDate
7 time(7) RentalTime
date DeliveryDate
time DeliveryTime
int GuideId
int InterpreterId
22
int Chaufferurld
Table 3: Rental Car Information
6.1.4 Customer Passport Table
Attribute Name Attribute Type Attribute Size
int PassportId
50 nvarchar(50) PlaceOfIssue
date DateOfIssue
Table 4: Customer Passport Information
6.1.5 Customer Licence Table
Attribute Name Attribute Type Attribute Size
int DrivingLicenceId
50 nvarchar(50) PlaceOfIssue_Licence
date DateOfIssue_Licence
20 varchar(20) ClassType
Table 5: Customer Licence Information
6.1.6 Guide Table
Attribute Name Attribute Type Attribute Size
int GuideId
50 nvarchar(50) GuideName
50 nvarchar(50) GuideSurname
50 nvarchar(50) GuidePhone
23
20 varchar(20) GuideGender
Table 6: Guide Information
6.1.7 Interpreter Table
Attribute Name Attribute Type Attribute Size
int InterpreterId
50 nvarchar(50) InterpreterName
50 nvarchar(50) InterpreterSurname
50 nvarchar(50) InterpreterPhone
20 varchar(20) InterpreterGender
50 nvarchar(50) Interpreter_known_language
Table 7: Interpreter Information
6.1.8 Chauffeur Table
Attribute Name Attribute Type Attribute Size
int ChauffeurId
int DrivingLicenceId
50 nvarchar(50) ChauffeurName
50 nvarchar(50) ChauffeurSurname
50 nvarchar(50) ChauffeurPhone
20 varchar(20) ChauffeurGender
Table 8: Chauffeur Information
6.1.9 Reserving Car Table
24
Attribute Name Attribute Type Attribute Size
int ReservationId
int CustomerId
int R_CarId
int S_CarId
date DateOfReservation
7 time(7) TimeOfReservation
Table 9: Reserving Car Information
6.1.9 Payment Table
Attribute Name Attribute Type Attribute Size
int PaymentId
50 nvarchar(50) PaymentType
Table 9: Payment Information
25
6.2 Database Diagram
Figure 10: Database Diagram
Brief Description
Database Diagram, is necessary for making E-R Diagram and determining primary keys.
According to that diagram, we relate and see relationships of entries between each other.
26
27
6.3 E-R Diagram
Figure 11: E-R Diagram
Brief Description
E-R Diagram attributes and relationships between tables are shown.
28
6.4 Block Diagram
Figure 12: Block Diagram
Brief Description
In Block Diagram actors and their tasks are shown.