PRACTICAL WORK

FINAL

SYSTEM OF
ADMINISTRATION
RENTAL OF
VEHICLES

GROUPA

MEMBERS:

LEONARDORIVADENEIRA
 GASTÓNAHTUY

LUISDOMÍNGUEZ

CONTENT

SLOGAN 2
OBJECTIVE 4
LIST OF EVENTS 4
CONTEXT DIAGRAM (LEVEL 0) 5
STIMULUS – RESPONSE TABLE 6
DATA FLOW DIAGRAM (LEVEL 1) 7
DATA FLOW DIAGRAM (LEVEL 2) 11
DFD: GROUPING 12
DATA DICTIONARY 13
TABLE SETUP 15

IFTS 12 - 2nd E - Group A 2

LABEL

It is about managing: the booking, delivery for rental of

cars in all the branches of the company, the
respective returns and comply with the requirements of the
Management (head office).

Car rental: the company accepts reservations for

automobiles, but requires the payment of the corresponding fee for the
contracted plan to make it effective. This reservation can
to be carried out: Personally, via telephone or Web (online) and will be
sent via email or delivered in person the Voucher
corresponding to the reserved service. In the case of making
the web reservation process must be registered with a
user in the same, with their respective password. If the client
is not previously registered and logged into the system
will have access to available dates, nor brands and models of
vehicles to choose from, you will only be able to see the rates and promotions
current rentals, as well as the ways to
contact and location of all branches.

To register you must provide: Name and

Apellido, Domicilio completo, DNI, Nacionalidad, Edad, el
username will be the ID number, you must choose one
password.

If the Client would like to make and/or confirm the reservation, after
log in to the system with your username and password, you must indicate
the date on which you will pick up and return the vehicle, at which branch
It will be the retirement, which car model do you prefer? You will only be able to see in

date screen, branches, and available models.

The tenant may confirm the reservation or cancel it (after

entered all the credit card information, where
finally the charge will be made), up to 48 hours before the
agreed time for the vehicle pickup, after that
limit, the total rent will be charged, no matter what
The client should not retrieve the vehicle, and it will be at their disposal.
vehicle if I wanted to pick it up on any day within the period
hired, at the agreed branch.

The units are subject to availability at the time of making.

The delivery of the vehicle and the voucher does not imply an obligation.

IFTS 12 – 2nd E – Group A 3

 by the company to deliver the assigned unit
previously, being able to replace it with one of equal category
according to the company's classification.

For the case of making the reservation or confirmation via

telephone, the procedure is exactly the same, only that
the person interacting with the system is the telephone operator,
requesting the client for the same data required for the
same procedure via the internet. And finally, if the person attends
personally, it must meet the same requirements as the
option to receive the voucher at the moment, in case of making
effective vehicle withdrawal at the moment or receive it via email,
for reservations with later pickup.

Vehicle delivery and return: On both occasions the

parts will verify: mileage and fuel load according to
the factory indicators, for the purposes of charging fees
additional, if applicable. If the Technical department and
"Locadora" mechanic (WORKSHOP) will check for damages, missing items
and/or defects that cannot be seen with the naked eye, are
it may notify the 'Client' of such circumstance and demand payment
relevant. Same procedure, including the damages that are
observe at first sight.

At the time of vehicle delivery, the Client must have

fulfilling all formal requirements of the case: Present
Document that proves identity, Driver's license
enabled, reservation voucher (in case it has been made).

The Client may return the car at a different branch.

to which I withdraw it, at no additional cost.

Yes, if the vehicle is not returned on time, it will have to face a

penalty equal to 200% of the daily value of the contracted rent
for each day of delay.

After the return, the final invoicing is carried out, which

it may include the contracted concepts as well as the
additional, fines, repairs, and any other
imponderable that could arise from the use of the car in the
rental period. The user will be able to replace the payment
original asignado a la tarjeta de crédito por pago en efectivo.

Monthly, management deemed it appropriate to send via email

the current promotions for registered users in the database
of data.

IFTS 12 - 2nd E - Group A 4

 Quarterly, the system will send a billing report to
the Management, for the preparation of the financial statements.

It will be the Management that establishes the minimum stock.

to enroll, which the system will use to send an alert
when that amount is reached, and to ask other branches
supply with available vehicles.

OBJECTIVE

Vehicle Rental Management

The purpose is to manage bookings, rentals, returns, and

maintenance of the company's vehicles, as well as to comply with
the requirements of the Management.

LIST OF EVENTS

A customer registers.
A customer requests a reservation.
A customer confirms reservation.
A customer cancels a reservation.
A client picks up a vehicle.
The workshop sends a report of the returned vehicle.
A customer makes a payment. (F)
Monthly: System sends email with promotions of the month
8
to the clients.
Quarterly: System generates billing report for the
9
Management. (T)
10System issues low stock alert for Management (C)

IFTS 12 - 2nd E - Group A 5

CONTEXT DIAGRAM (LEVEL 0)

IFTS 12 - 2nd E - Group A 6

STIMULUS-RESPONSE TABLE

STIMULI ANSWERS
EVENTID STIMULUS EXTERNAL INTERNAL ENTITY (ACTIVITIES OR
TO AD AD PROCESSES THAT
EXTER EXTER INCLUDE)
NA NA
ORIGIN DESTI
N NO
1 Client Request for discharge Ok / Error Client Mandatory data loading.
Check availability of
Reservation vehicle.
Request
2 Client Available Client Generate reservation number
reservation
Error with customer and vehicle data
reserved.
-Check client data and
reservation.
Availability control of
reservation.
Confirmation Voucher of
3 Client Client -Rental registration with number
of reserve Alquiler / Error
of reservation, rates and data of
branch.
-Issue voucher with data from
rental.
Cancel
4 Client Ok / Error Client Cancel reservation number.
reservation
Update vehicle status.
5 Client Pick up car Ok / Error Client Register withdrawal date.
Vehicle delivery to the customer.
Check returned vehicle.
Generate status report of
Send report
vehículo .devuelto.
6 Workshop of vehicle Ok / Error Workshop
Register return date
returned
and eventual costs in
rentals.
Customer chooses payment method.
Import rental data.
7 Client Make payment Ok / Error Client
Register invoice.
Issue invoice.
Import email list from
Event clients
Mail
8 Dry - Client Import promotions
Promotions
the current
Send email to Clients.
Event Prepare Report
Report of Management
9 Tempor - Quarterly Billing.
Billing a
to Send report to Management.
Issue an alert to Management
Event Issue alert
Manage When the Quantity of
10 of - of Stock
a Vehicles Exceed the Minimum
Control Minimum
Stock allowed.

IFTS 12 - 2nd E - Group A 7

Data Flow Diagram (Level 1 and 2)

Level 1:

A CLIENT REGISTERS

2.- A CLIENT REQUESTS RESERVATION

IFTS 12 - 2nd E - Group A 8

3.- A CLIENT CONFIRMS RESERVATION

4.- A CLIENT CANCELS RESERVATION

5.- A CUSTOMER PICKS UP VEHICLE

6.- THE WORKSHOP SENDS REPORT OF RETURNED VEHICLE

IFTS 12 - 2nd E - Group A 9

7.- A CLIENT MAKES A PAYMENT

8.- MONTHLY: SYSTEM SENDS EMAIL WITH PROMOTIONS TO THE

CLIENTS

IFTS 12 - 2nd E - Group A 10

9.-QUARTERLY: SYSTEM GENERATES BILLING REPORT
FOR THE MANAGEMENT

10.- SYSTEM ISSUES LOW STOCK ALERT FOR MANAGEMENT.

IFTS 12 - 2nd E - Group A 11

DFDNIVEL2:
3.- CLIENT CONFIRMS RESERVATION

IFTS 12 - 2nd E - Group A 12

DFD: GROUPING

IFTS 12 - 2nd E - Group A 13

DICCIONARIO DE DATOS

caracter_válido := [letra | dígito | ‘ | - |]

dígito := [ 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 ]

letter := [uppercase_letter | lowercase_letter]

date := [digit / digit / digit ]

CLIENTES:= @IDCLI + NOMBRE + APELLIDO + DOMICILIO +

NACIONALIDAD + PASSWORD + EMAIL + TARJCRED

-@IDCLIE:= [1…9999999] *Key field – DNI number*

- NAME := 1 { valid_character } 30

LAST NAME := 1 { valid_character } 30

- ADDRESS := 1 { valid_character } 70

- NATIONALITY := 1 { valid_character } 30

PASSWORD := 1 { valid_character } 15 *Access password to

system

- EMAIL := 1 { carácter_ válido} 70

- TARJCRED := [0000 0000 0000 0000…9999 9999 9999 9999]

VEHICULOS:= @DOMINIO + MARCA + MODELO + AÑO +

KILOMETRAJE + ESTADO + TIEMPO_REPARACION + @SUCURSAL +
@CATEGORY

-@DOMAIN:= 1 { valid_character } 6 *Key field - No.

patent

- BRAND := 1 { valid_character } 30

- MODEL := 1 { valid_character } 30

- AÑO := 1 { dígito } 4

- KILOMETRAJE := 1 { dígito } 15

- ESTADO := 1 { DISPONIBLE | EN REPARACIÓN | ALQUILADO |

REMOVED

- TIEMPO_REPARACIÓN := 1 { dígito } 5 *En cantidad de días*

-@BRANCH:= [1…9999999] *Foreign key – Branch Id*

IFTS 12 - 2nd E - Group A 14

 -@CATEGORY:= [1…9999999] *Foreign key – Category Id*

RESERVAS:= @NRO + FEC_RESERVA + FEC_CONFIRMACION +

CANCELATION + @CLIENTID + @DOMAIN

-@NRO:= [1…9999999] *Key field – Reservation number*

- FEC_RESERVA := 1 { fecha }

- FEC_CONFIRMACIÓN := 1 { fecha }

- FEC_CANCELACIÓN := 1 { fecha }

-@CLIENTID:= [1…9999999] *Foreign key – DNI number*

-@DOMAIN:= 1 { valid_character } 6 *Foreign Key – License Number*

RENTALS:= @VOUCHERNUMBER + PICKUP_DATE + PICKUP_BRANCH +

FEC_DELIVERY + BRANCH_DELIVERY + @CLIENT_ID + @DOMAIN +
@NRORESERVA + ADDITIONAL_OBS + ADDITIONAL_EXPENSES

-@NROVOUCHER:= [1…9999999] *Key field - Voucher Number *

- FEC_RETIRO := 1 { fecha }

- SUC_RETIRO := [1…9999999]

- FEC_ENTREGA := 1 { fecha }

- SUC_ENTREGA := [1…9999999]

-@CLIENTID:= [1…9999999] *Foreign key – ID number*

-@DOMAIN:= 1 { valid_character } 6 *Foreign Key - License Number*

Foreign key - Reservation Number

- ADICIONAL_OBS := 1 { carácter_ válido } 256 *Observaciones del

vehicle delivery status*

- ADICIONAL_GASTOS := 1 { dígito } 6 *Costo total de adicionales*

SUCURSALES:= @ID + NOMBRE + DOMICILIO + LOCALIDAD +

STOCKTOTAL

-@ID:= [1…9999999] *Key field – Branch Number*

- NOMBRE := 1 { carácter_ válido } 30

- ADDRESS := 1 { valid_character } 30

IFTS 12 - 2nd E - Group A 15

 - LOCALIDAD := 1 { carácter_ válido} 70

- STOCKTOTAL := 1 { dígito } 30 *Cantidad total de vehículos en s

TARIFAS:= @IDCAT + PRECIO + PROMO_01 + PROMO_02

-@IDCAT:= [1…9999999] *Key field – Category Number*

- PRICE := 1 { digit } 6

- PROMO_01 := 1 { dígito } 6 *Promocion vigente 1*

- PROMO_02 := 1 { dígito } 6 *Promocion vigente 2*

INVOICES:= @NROFAC + @NROVOUCHER + DATE + AMOUNT +

STATUS + PAYMENT_METHOD

-@NROFAC:= [1…9999999] *Key field - Invoice Number *

-@NROVOUCHER:= [1…9999999] *Clave foránea – Nro Voucher *

- FECHA := 1 { fecha } *Fecha emisión de factura*

- AMOUNT := 1 { digit } 6

- ESTADO := { carácter_ válido} 30

- MEDIO_PAGO := { carácter_ válido} 30

IFTS 12 – 2º E – Grupo A 16
TABLE SETUP

IFTS 12 – 2nd E – Group A 17