ENTITAS DAN RELASI

Rangkuman kk9 :)

ENTITAS DAN RELASI

Entitas dalam database untuk mendeskripsikan sesuatu dalam kenyataannya. Yang dimaksud entitas dalam database adalah kolom. Hubungan antara entitas disebut Relasi. Relasi dibuat berdasarkan kehidupan nyata.

contoh :

dalam suatu perusahaan ada entitas pegawai, departemen, dll,

untuk dibuatkan relasi, misalnya ada Pegawai A bekerja "di" Departemen A, apa-apa saja yang menjadi relasinya? Yaitu pekerjaan, gaji, dll.

rdbms : relational database management system

relational :

- one to one : satu pegawai bekerja pada satu departemen .

- one to many : bisa 1 pegawai bekerja di banyak departemen, bisa juga satu departemen banyak pegawai yang bekerja.

- many to many : harus ada primary key agar data tidak terduplikasi.

kolom dan atribut (field) contoh teks merah :

No. Pegawai	Nama	Pekerjaan
234	Bayu	Programmer
567	Amri	Programmer
456	Asti	Secretary
678	Budi	Office Boy

baris , record , tuple : satu kesatuan data dalam sebuah table

key (kunci) : identitas dari suatu tabel agar unik,

type key:

·        super key

·        candidate key

·        primary key digunakan untuk relational many to many

·        foreign key 

My Lovely Mom :*

ibuu. . .

kau telah mengandung ku selama 9 bulan 10 hari

kau membawa ku kemana pun kau pergi

kau tidak pernah merasa lelah untuk menjaga ku

tapi. . .

apa yang bisa aku berikan padamu?

mungkin tidak ada, yaah, aku tau itu

tapi, kau tetap memberikan cinta mu untuk ku

oh.. Tuhan. . .

tolong beri aku satu kesempatan

kesempatan untuk membuat Ibu ku bangga pada ku

Terima kasih Ibu, Aku menyayangi mu :*

Tutorial Membuat Database dengan Menggunakan CMD

open yaah Tutorial Membuat Database dengan Menggunakan CMD,,
if  You like, Share it, thank you :)
this is the link :
http://www.ziddu.com/download/18582960/TutorialMembuatDatabasedenganMenggunakanCMD.pdf.html

I'm only me when I'm with you - taylor swift

Friday night beneath the stars,
in a field behind your yard,
you and I are paintin' pictures in the sky.
And sometimes we don't say a thing;
just listen to the crickets sing.
Everything I need is right here by my side.
And I know everything about you
I don't wanna live without you.

[Chorus:]
I'm only up when you're not down.
Don't wanna fly if you're still on the ground.
It's like no matter what I do.
Well you drive me crazy half the time;
the other half I'm only trying to let you know that what I feel is true.
And I'm only me when I'm with you.

Just a small town boy and girl
livin' in a crazy world.
Tryin' to figure out what is and isn't true.
And I don't try to hide my tears.
The secrets or my deepest fears.
Through it all nobody gets me like you do.
And you know everything about me.
You say that you can't live without me.

[Chorus]
I'm only up when you're not down.
Don't wanna fly if you're still on the ground.
It's like no matter what I do.
Well you drive me crazy half the time;
the other half I'm only trying to let you know that what I feel is true.
And I'm only me when I'm with you.

When I'm with anybody else it's so hard to be myself.
Only you can tell.

[Chorus:]
That I'm only up when you're not down.
Don't wanna fly if you're still on the ground.
It's like no matter what I do.
Well you drive me crazy half the time;
the other half I'm only trying to let you know that what I feel is true.
And I'm only me
Who I wanna be
Well, I'm only me when I'm with you
With you
Uh huh
Yeah