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;

love song

Intro: (Am, G, F, Em)

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am home again

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am whole again

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am young again

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am fun again

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am fun again

Chorus

F G Am G

However far away, I will always love you

F G Am G

However long I stay, I will always love you

F G Am G

Whatever words I say, I will always love you

F G Am

I will always love you

Am G F, Em

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am free again

Am G F, Em

Whenever I'm alone with you

Am G F, Em

You make me feel like I am clean again

nunggu club lancer ... lamanyo ......

130cc vega new ku .... hihihi

waktu kumpul .. haha

abis bersih-bersih .... capek banget

nongkrong dulu ....

mobil dragku hihihihihi

hahaha ... iseng aja mbak mas bro ... kan emang aku drummer . hihihihi (sombong dikit)

mobil kesayanganku .. platnya 8118 krn 8+1=9 . kenapa angka 9   .. coz angka 9 dari fengshui merupakan angka tertinggi . dan angka 8 adlh angka keberuntungan , krn angka yg tak pernah putus

anxiety

faster, i dream with speeds of ashes
my heart, it beats and crashes
i’m running from the truth
cuz it fucks with my mi-i-ind.

the great, and, silly years so reckless
the city, its so heartless
a bottle full of cream
washed up in the ti-i-ide

don’t pressure us, anxiety
i’m a passenger
so serious, anxiety
just a passenger

hands up, callused, young believers
hiding from the schemers
and running out like fruit,
that was left here to di-i-ie

dark and, playing after-hours
the time has been an hour
falling to my knees,
to feel all safe insi-i-ide

don’t pressure us, anxiety
i’m a passenger
so dangerous, anxiety
just a passenger (2x)

don’t pressure us
don’t pressure us
don’t pressure us
don’t pressure us

don’t pressure us, anxiety
i’m a passenger
so dangerous, anxiety
just a passenger

don’t pressure us, anxiety
i’m a passenger
so serious, anxiety
just a passenger

won't go home without you

i asked her to stay
but she wouldn't listen
she left before i had the chance to say
oh
the words that would mend
the things that were broken
but now it's far too late, she's gone away

every night you cry yourself to sleep
thinking "why does this happen to me?
why does every moment have to be so hard?"
hard to believe that

it's not over tonight
just give me one more chance to make it right
i may not make it through the night
i won't go home without you

the taste of her breath, i'll never get over
and the noises that she made kept me awake
oh
the weight of things that remain unspoken
built up so much it crushed us everyday

every night you cry yourself to sleep
thinking "why does this happen to me?
why does every moment have to be so hard?"
hard to believe that

it's not over tonight
just give me one more chance to make it right
i may not make it through the night
i won't go home without you

it's not over tonight
just give me one more chance to make it right
i may not make it through the night
i won't go home without you

of all the things i felt i've never really showed
perhaps the worst is that i ever let you go
should not ever let you go, oh oh oh

it's not over tonight
just give me one more chance to make it right
i may not make it through the night
i won't go home without you

it's not over tonight
just give me one more chance to make it right
i may not make it through the night
i won't go home without you, ohh

it's not over tonight
just give me one more chance to make it right
i may not make it through the night
i won't go home without you
and i won't go home without you
and i won't go home without you
and i won't go home without you

step right up

Intro: Bb , Eb , Bb , A , G , Eb , G , F

Verse I:

 Bb        Eb                    

Please aim show, I know it's not like you

             Eb

To take the fall, For anyone but yourself

Refrain:

   Bb

Let me show you a world

          

                   Eb

That you've never seen, Let me help you around

                             Bb            Eb

What you meant to say, There is no time to waste

Well if I love you can't hesitate

Chorus:

  Bb             Eb

Step right up, Shoot an arrow at the target

 Bb          A 

My heart is an easy thing for you to ht

  G

Don't worry

   Eb

If you miss I'll get you shoot again

 G             F

My heart is an easy thing for you to win

Verse II: (Do Verse Chords)

Whoa you know you did it again

And everytime I hear your voice

Well know I had no choice but

To let you in

Life's shot, Don't pretend

(Repeat Refrain)

(Repeat Chorus 2x)

Bridge:

 F   G        Eb        F 

How could I see you , To let you know every day

  G       Eb     F          

I am grateful, I wish I ould turn back time

 G                Eb

Or maybe rewind, I would find you when we were younger

F-Eb-G 

So we could spend all the time on earth together longer

(Repeat Chorus 2x)

Chorus 2: (Do Chorus Chords)

Step right up again, And if I love you can't hesitate

Step right up again, My heart is aching I can barely wait

Step right up again, when if I love you can't hesitate

Step right up again, My heart is aching I an barely wait

your guardian angel

Intro

F     C     D     B     C#

Verse

F      C        D

When I see your smile

B                 F      C     D     B

Tears run down my face I can't replace

F                              C

And now that I'm stronger I've figured out

         D                    B

How this world turns cold and breaks through my soul

      F         C         D               B

And I know I'll find deep inside me I can be the one

F            C

I will never let you fall

D                      B

I'll stand up with you forever

F                     C

I'll be there for you through it all

D                  B                 F

Even if saving you sends me to heaven

    C        D        B

It's ok. It's ok. It's ok.

F

Seasons are changing

    C

And waves are crashing

    D                 B

And stars are falling all for us

F                    C

Days grow longer and nights grow shorter

  D                 B

I can show you I'll be the one

F            C

I will never let you fall

D                      B

I'll stand up with you forever

F                     C

I'll be there for you through it all

D                  B

Even if saving you sends me to heaven

    F          C          D

Cuz you're my, you're my, my true love, my whole heart

B                       C#

Please don't throw that away

    F        C

Cuz I'm here for you

D

Please don't walk away,

B                     C#

Please tell me you'll stay, stay

F        C       D       B        C#

F             C

Use me as you will

         D                 B

Pull my strings just for a thrill

F                   C

And I know I'll be ok

          D                 B

Though my skies are turning gray

F            C

I will never let you fall

D                      B

I'll stand up with you forever

F                     C

I'll be there for you through it all

D                  B

Even if saving you sends me to heaven

(Keep repeating as long as you want)