databases rental mobil (join where)

create database Rental_Mobil_Argyan;
use Rental_mobil_Argyan;

create table tb_pegawai(id_pegawai char(4), nama_pegawai char(40), alamat_pegawai char(50), tgl_lahir date, jenis_kelamin char(1));
insert into tb_pegawai values('PW01','Sumanto','jalan banyak anak-anak No.25 kota.Semarang','1987-07-01','L'),
('PW02','Sarmini','jalan kecemplung jurang Kota.semarang','1988-03-22','P'),
('PW03','Parnomo','jalan 17+ kota.Semarang','1988-07-12','L');
desc tb_pegawai;
select * from tb_pegawai;


create table tb_mobil(id_mobil char(4) primary key, nama_mobil char(20), kondisi_mobil char(10), sewa_per_hari int(7));
insert into tb_mobil values('MB01','Avanza','Bagus','250.000'),
('MB02','APV','Bagus','200.000'),
('MB03','Xenia','Bagus','190.000');
desc tb_mobil;
select * from tb_mobil;

create table tb_sopir(ib_sopir char(4) primary key, id_mobil char(4), nama_sopir char(40), tgl_lahir_sopir date, jenis_kelamin char(1));
insert into tb_sopir values('SP01','MB01','Sukron','1980-06-22','L'),
('SP02','MB02','Sastro','1988-02-23','L'),
('SP03','MB03','Karyono','1987-03-26','L');
desc tb_sopir;
select * from tb_sopir;

create table tb_pelanggan(id_pegawai char(11) primary key, id_mobil char(4), nama_pelanggan char(40), alamat_pelanggan char(50), tgl_lahir_pelanggan date, jenis_kelamin char(1),status_pelanggan char(10));
insert into tb_pelanggan values('10015500073','MB01','Machrival Fidha H','Mranggen kota.Semarang','1980-07-21','L','Duda'),
('10015500075','MB02','Imam Nur Arif','jalan ambyar kota.Semarang','1990-07-06','L','Lajang'),
('10015500166','MB03','Gigih Aji','jalan tanda tanya kota.Kendal','1987-11-21','L','Menikah');
desc tb_pelanggan;
select * from tb_pelanggan;


select tb_mobil.nama_mobil, tb_mobil.kondisi_mobil, tb_mobil.sewa_per_hari,
tb_sopir.nama_sopir, tb_sopir.tgl_lahir_sopir, tb_sopir.jenis_kelamin,
tb_pelanggan.nama_pelanggan, tb_pelanggan.alamat_pelanggan, tb_pelanggan.tgl_lahir_pelanggan, tb_pelanggan.jenis_kelamin, tb_pelanggan.status_pelanggan
from tb_mobil,tb_sopir,tb_pelanggan where tb_mobil.id_mobil = tb_sopir.id_mobil and tb_mobil.id_mobil = tb_pelanggan.id_mobil;

databases rental dvd (join where)

create database rental;
use rental;
create table pegawai (id_pegawai varchar (5) primary key, alamat text, no_telepon varchar (12));
insert into pegawai values ('A0001','jl.bangkong','085727044697'),
('A0002','jl.peterongan','085123456789'),
('A0003','jl.pedurungan','085741373940');
select * from pegawai;

create table dvd (id_dvd varchar (4) primary key, nama_film varchar (20));
insert into dvd values ('D001','tali pocong perawan'),
('D002','namaku dick'),
('D003','sherlock holmes'),
('D004','ninja asasins');
select * from dvd;

create table pelanggan (id_pelanggan varchar (5),id_dvd varchar (4), nama varchar (20), alamat text);
insert into pelanggan values ('P0001','D001','congek','jl.gunungpati'),
('P0002','D002','adeseptiann','jl.muse'),
('P0003','D003','imam','jl.ndaun'),
('P0004','D004','nova','jl.terongan'),
('P0005','D002','rival','jl.telogosari');
select * from pelanggan;



select dvd.id_dvd, dvd.nama_film, pelanggan.id_pelanggan, pelanggan.id_dvd, pelanggan.nama, pelanggan.alamat from dvd, pelanggan where dvd.id_dvd=pelanggan.id_dvd;

spesifikasi basis data pertemuan k 3

create database penjualann;
use penjualann;
create table pelanggan (id_pelanggan varchar(5),nm_pelanggan varchar(40),alamat text, telepon varchar(20), email varchar(50));
desc pelanggan;
create table pesan (id_pesan int(5) auto_increment, id_pelanggan varchar(5), tgl_pesan date, primary key (id_pesan));
create table produk (id_produk varchar(5) primary key, nm_produk varchar(30), satuan varchar(10), harga decimal(10,0), stock int(3));
desc pesan;
desc produk;
create table detil_pesan (id_pesan int(5), id_produk varchar(5), jumlaj int(5), harga decimal(10,0), primary key (id_pesan, id_produk));
desc detil_pesan;
create table faktur (id_faktur int(5) not null auto_increment, id_pesan int(5), tgl_faktur date, primary key (id_faktur));
desc faktur;
create table kuitansi (id_kuitansi int(5) not null auto_increment, id_faktur int(5), tgl_kuitansi date, primary key (id_kuitansi));
desc kuitansi;