Download - Database Sistem Rental Mobil
![Page 1: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/1.jpg)
DATA B A S E S I S T E M R E N TA L M O B I L
FINAL PROJECTSISTEM BASIS DATA
![Page 2: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/2.jpg)
RANCANGAN DATABASE
1. Entity Reletionship Diagram
( ERD )
2. Normalisasi
3. Relasi Antar Tabel
4. Struktur Tabel
![Page 3: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/3.jpg)
ENTITY RELATIONSHIP DIAGRAM ( ERD )
1. Entitas
• Karyawan
• Customer
• Mobil
• Sewa
2. Kardinalitas
• Seorang karyawan mengelola banyaknya sewa
• Seorang customer melakukan banyak penyewaan
• Banyaknya penyewaan dikelola oleh seorang karyawaan
• Banyaknya penyewaan dilakukan oleh seorang customer
• Banyak penyewaan mempunyai sebuah mobil yang sama
• Sebuah mobil mempunyai banyak penyewaan
![Page 4: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/4.jpg)
ENTITY RELATIONSHIP DIAGRAM ( ERD )
![Page 5: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/5.jpg)
MAPPING DARI ERD KE TABEL
Id_karyawan
Nama Depan
Nama Tengah
Nama Belakang
Alamat Jk No_telp
PK
Id_customer
Nama Depan
Nama Tengah
Nama Belakang
Alamat Jk No_telp
PK
Id_mobil No_platjenis_mobi
lMerk Thn_buat Warna
PK
Id_sew
a
Id_karyaw
an
Id_custom
er
Id_mobi
l
Tgl_pinja
m
Tgl_Kemb
ali
Tot_by
r
Dend
a
PK FK FK FK
• Tabel Karyawan
• Tabel Customer
• Tabel Mobil
• Tabel Sewa
![Page 6: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/6.jpg)
NORMALISASI
1. Bentuk Normal Pertama (1NF) Masukan semua nya ke dalam satu kolom
![Page 7: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/7.jpg)
NORMALISASI
2. Bentuk Normal Kedua (2NF) Memisahkan berdasarkan Paling banyak ketergantungan
![Page 8: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/8.jpg)
NORMALISASI
2. Bentuk Normal Ketiga (3NF)
![Page 9: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/9.jpg)
RELASI ANTAR TABEL
![Page 10: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/10.jpg)
STRUKTUR TABEL
Nama Field Tipe Data Ukuran
Keterangan
Id_karyawan Int 5 Not null primary key
Nama Varchar 30 Nama Karyawan
Alamat Varchar 30 Alamat Karyawan
Jk Varchar 10 Jenis Kelamin
No_telp Varchar 15 Nomer Telephone
Nama Field Tipe Data Ukuran
Keterangan
Id_mobil Int 5 Not null primary key
No_plat varchar 10 No plat kendaraan
jenis Varchar 10 Jenis Mobil
Merk Varchar 10 Merk Mobil
Thn_buat Int 4 Tahun Membuat Mobil
Warna varchar 10 Warna Mobil
Harga Int Harga Mobil
Tabel Mobil :Tabel 4.2 Tabel
Mobil
Tabel Karyawan :Tabel 4.1 Tabel Karyawan
![Page 11: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/11.jpg)
STRUKTUR TABEL
Nama Field Tipe Data Ukuran
Keterangan
Id_customer Int 5 Not null primary key
Nama Varchar 30 Nama Customer
Alamat Varchar 30 Alamat Customer
Jk Varchar 10 Jenis Kelamin Customer
No_telp Varchar 15 Nomer Telephone Customer
Nama Field Tipe Data
Ukuran
Keterangan
Id_sewa Int 5 Not null primary key
Id_karyawan Int 5 Foreign Key
Id_customer Int 5 Foreign Key
Id_mobil Int 5 Foreign Key
Tgl_pinjam Datetime 30 Tanggal Pinjam
Tgl_Kembali Datetime 30 Tanggal Kembali
Tot_byr Int 10 Total Bayar
Denda Int 10 Denda
Tabel Customer :Tabel 4.3 Tabel Customer
Tabel Sewa :Tabel 4.4 Tabel
Sewa
![Page 12: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/12.jpg)
LAMPIRAN SCRIPT
create database rental_mobil use rental_mobil create table karyawan (id_karyawan int not null primary key,nama varchar(30) not null,alamat varchar(30),jk varchar(10),no_telp varchar(15) ) create table mobil (id_mobil int not null primary key,no_plat varchar(10),jenis varchar(10),merk varchar (10),thn_buat int,warna varchar(10),Harga int)
![Page 13: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/13.jpg)
LAMPIRAN SCRIPT
create table customer (id_customer int not null primary key,nama varchar(30) not null,alamat varchar(30),jk varchar(10),no_telp varchar(15) ) create table sewa (id_sewa int not null primary key,id_karyawan int not null foreign key references karyawan,id_customer int not null foreign key references customer,id_mobil int not null foreign key references mobil,tgl_pinjam datetime,tgl_kembali datetime,tot_byr int,denda int)
![Page 14: Database Sistem Rental Mobil](https://reader035.vdokumen.com/reader035/viewer/2022081719/557c2637d8b42a925b8b4f01/html5/thumbnails/14.jpg)
SEKIAN