This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Senin, 12 November 2012

Tugas 5 Basis Data


TUGAS 5 BASIS DATA
DCL DAN NORMALISASI

1.    Praktekan perintah2 pada DCL.
a.    GRANT
Ø  SELECT

Ø  ALL PRIVILEGES

Ø  ALL

Ø  SHOW GRANT

Ø  CREATE


Ø  DELETE

Ø  UPDATE

Ø  INSERT


               b.    REVOKE

Ø  CREATE

Ø  SELECT

Ø  ALL


         2.    Berikan contoh normalisasi pada kasus lain.

     Relasi tidak normal :


       Relasi normal :


      3.    Dari tabel data yang dihasilkan pada perancangan basis data, lakukanlah normalisasi pada tabel-tabel tersebut sampai bentuk normal ketiga !




Normalisasi Pertama :


Normalisasi Kedua :






Normalisais Ketiga :





Senin,  12 November 2012
Pukul 19:55