LAPORAN

DESAIN SISTEM INFORMASI

“RENTAL MOBIL BERBASIS WEB”

OLEH
DARWIS
1920557011

JURUSAN SISTEM INFORMASI

SEKOLAH TINGGI ILMU KOMPUTER 22 JANUARI
KENDARI
TAHUN AKADEMIK 2021/2022
 Tabel boking
Id
Tabel user Boking_number
Tabel admin User_email
id Id
Full_name Vehicleld
Staf From_date
Name _admin Email
Password To_date
Name _user messange
First_name Contact
dob Status
last_name Posting_date
Mobile_number Addres
City Last_updation_date
Email
Status Country
Photo Reg_date
Password Updation_date
Admin _reg_date Tabel orders
Tabel brands
Id
Id
Id_product
Brands_name
Tabel vehicles Quantity
Creation_date
Id Invoice_number
Updation_date
Vehicles_title Customer_name
Vehicles_brands Customer_contact
Vehicles_owerview Payment_mode
Price_per_day Invoce_gen_date
Fuel_type
Model_year
Seating_capacity
Vimage_1
Vimage_2
Vimage_3
Vimage_4
Vimage_5
Air_conditioner
Power_dock_loks
Anti_dock_braking_system
Breaks_asist
Power_stering
Diver_airbang
Passenger_airbang
Power_windows
Cd_player
Central_looking
Crash_sensor
Leather_seats
Reg_date
Updation_date
 SISTEM INFORMASI RENTAL MOBIL BERBASIS WEB
Entity Relationship Diagram (ERD)

Entity Relationship Diagram pada sistem informasi web rental mobil yang dirancang ini adalah seperti
pada gambar berikut:
KAMUS DATA

1. Tabel admin n Nama field type panjang

Primary key:id o
1 id Intiger 13
2 Staf Varchar 14
3 Name _admin Varchar 34
4 Name _user Varchar 35
5 First_name Varchar 36
6 last_name Varchar 56
7 Mobile_number Intiger 57
8 Email Varchar 57
9 Status Varchar 57
10 Photo Varchar 34
11 Password Varchar 43
12 Admin _reg_date Varchar 32

2. Tabel user
Primary key:id

No Nama Field Tipe Panjang

1 Id Integer 15
2 Full_name Varchar 255
3 Email varchar 15
4 Password varchar 15
5 Contact varchar 15
6 dob integer 34
7 Addres varchar 35
8 City varchar 46
9 Country varchar 67
10 Reg_date Integer 36
11 Updation_date integer 25
3. Tabel brands
Primary key:id

No Nama Field Tipe Panjang

1 Id Integer 13
2 Brands_name Varchar 34
3 Creation_date Date 25
4 Updation_date date 21
 4. Tabel boking
Primary key:id

No Nama Field Tipe Panjang

1 Id Integer 15
2 Boking_number Integer 255
3 User_email varchar 15
4 Vehicleld Enum 15
5 From_date Date 15
6 To_date Date 34
7 messange varchar 35
8 Status enum 46
9 Posting_date Integer 67
10 Last_updation_date Integer 36

5. Tabel orders
Primary key:id

No Nama Field Tipe Panjang

1 Id Integer 15
2 Id_product Integer 255
3 Quantity integer 15
4 Invoice_number varchar 15
5 Customer_name Date 15
6 Customer_contact integer 34
7 Payment_mode varchar 35
8 Invoce_gen_date integer 46
 6. Tabel vehicles
Primary key:id

n Nama field type panjang

o
1 Id Intiger 13
2 Vehicles_title Varchar 14
3 Vehicles_brands Varchar 34
4 Vehicles_owerview Varchar 35
5 Price_per_day integer 36
6 Fuel_type Varchar 56
7 Model_year Intiger 57
8 Seating_capacity integer 57
9 Vimage_1 Varchar 57
10 Vimage_2 Varchar 34
11 Vimage_3 Varchar 43
12 Vimage_4 Varchar 32
13 Vimage_5 Varchar 57
14 Air_conditioner Intiger 23
15 Power_dock_loks Intiger 12
16 Anti_dock_braking_system Intiger 23
17 Breaks_asist Intiger 24
18 Power_stering Intiger 52
19 Diver_airbang Intiger 62
20 Passenger_airbang Intiger 78
21 Power_windows Intiger 34
22 Cd_player Intiger 13
23 Central_looking Intiger 34
24 Crash_sensor Intiger 23
25 Leather_seats Intiger 54
26 Reg_date Intiger 46
27 Updation_date Intiger 67

DIAGRAM KONTEKS
DATA FLOW DIAGRAM(DFD LEVEL1)

RANCANGAN ANTAR MUKA (INTERFASE)

Tampilan dasboasrd
Tampilan login

Tampilan search

Tampilan penyewahan mobil

Tampilan transaksi

Car name Form date to date Total Rent/day

 days

BMW.5 series 2018 2021-07-26 20-070-28 9 1000

Gran total 9000

Tampilan admin