bab ii

5
SMAN 3 Padmanaba Yogyakarta Teknologi Informasi dan Komunikasi 23 Bab II Membuat Query 1 TIK : Siswa mampu membuat relationship antara satu tabel dengan tabel yang lain. Materi Singkat: Dalam database Query adalah permintaan akan kumpulan data tertentu, misalnya daftar siswa dari jurusan IPA. Jawaban dari permintaan itu disebut Dynaset. Query dapat juga menjadi sumber data bagi query lain atau sumber untuk menentukan sebuah report (laporan). Sebuah basis data relasional tidak hanya terdiri dari sebuah tabel, melainkan beberapa buah tabel yang saling berhubungan dan membentuk sebuah sistem. Hubungan antara satu tabel dengan tabel yang lain disebut dengan relationship. Relatinship bisa terjadi antara dua buah tabel (binary relationship) atau lebih. Membuat tiga buah tabel dalam file basis data yang sudah dibuat sebelumnya. Dilanjutan dengan memasukkan isi tabel, membuat Relationship antar tabel dan membuat sebuah laporan . Langkah Praktikum 1. Bukalah database yang telah anda buat, kemudian klik Query. 2. Dari 2 kategori pembuatan query klik 2 kali pada Create Query in Design View, hingga ditampilkan sejumlah tabel yang telah dibuat (SHOW TABLE) 3. Pada kotak dialog Show Table, pilih table yang akan mendasari query baru, kita juga bisa memilih query lain sebagai dasar query baru. Pilih TSISWA kemudian klik ADD. Karena hanya menggunakan 1 tabel, kemudian klik Close hingga muncul seperti berikut :

Upload: maister-wister

Post on 11-Jul-2016

215 views

Category:

Documents


1 download

DESCRIPTION

Bab 2 Isi Pembahasan

TRANSCRIPT

Page 1: BAB II

SMAN 3 Padmanaba Yogyakarta

Teknologi Informasi dan Komunikasi 23

Bab II

Membuat Query 1 TIK :

Siswa mampu membuat relationship antara satu tabel dengan tabel yang lain.

Materi Singkat:

Dalam database Query adalah permintaan akan kumpulan data tertentu,

misalnya daftar siswa dari jurusan IPA. Jawaban dari permintaan itu disebut

Dynaset. Query dapat juga menjadi sumber data bagi query lain atau sumber

untuk menentukan sebuah report (laporan).

Sebuah basis data relasional tidak hanya terdiri dari sebuah tabel, melainkan

beberapa buah tabel yang saling berhubungan dan membentuk sebuah sistem.

Hubungan antara satu tabel dengan tabel yang lain disebut dengan relationship.

Relatinship bisa terjadi antara dua buah tabel (binary relationship) atau lebih.

Membuat tiga buah tabel dalam file basis data yang sudah dibuat sebelumnya.

Dilanjutan dengan memasukkan isi tabel, membuat Relationship antar tabel dan

membuat sebuah laporan . Langkah Praktikum

1. Bukalah database yang telah anda buat, kemudian klik Query.

2. Dari 2 kategori pembuatan query klik 2 kali pada Create Query in Design

View, hingga ditampilkan sejumlah tabel yang telah dibuat (SHOW TABLE)

3. Pada kotak dialog Show Table, pilih table yang akan mendasari query baru,

kita juga bisa memilih query lain sebagai dasar query baru. Pilih TSISWA

kemudian klik ADD. Karena hanya menggunakan 1 tabel, kemudian klik Close

hingga muncul seperti berikut :

Page 2: BAB II

SMAN 3 Padmanaba Yogyakarta

Teknologi Informasi dan Komunikasi 24

4. Pada Field klik ▼ untuk menentukan field yang akan ditampilkan, misal NIS

dan Nama Siswa.

5. Pada Table adalah sumber dari field yang ditampilakan. Sort untuk

menentukan cara pengurutan. Show, apabila dalam kotak yang diberi tanda √

dihilangkan berarti tidak akan ditampilkan. Criteria adalah untuk

menentukan hal-hal yang khusus, misal pada kolom Agama diberi criteria

“Islam” berarti akan ditampilkan data siswa yang beragama Islam.

6. Setelah beberapa criteria ditentukan, untuk menjalankan klik RUN atau

tanda !

Tugas

1. Buatlah Query yang akan menampilkan daftar Siswa dari jurusan IPA dan IPS

secara terpisah.

2. Dengan Query, kelompokkanlah siswa yang mempunyai agama tertentu.

3. Buatlah Query yang menampilkan daftar Guru yang berasal dari Yogyakarta

Pertanyaan

1. Jelaskan mengenai pengertian relationship! Sebutkan macam-macamnya dan apa

perannya dalam sebuah basis data?

2. Apa yang telah anda lakukan dan bagaimana hasil dari penentuan querynya?

Laporan

Tulislah laporan singkat pada halaman yangtersedia. Isi laporan meliputi jawaban

pertanyaan, pembahasan dan kesimpulan terhadap TIU (Tujuan Instruksional

Khusus). Laporan dibuat sesingkat mungkin, sertakan pembahasan jika diperlukan.

--o--

Page 3: BAB II

SMAN 3 Padmanaba Yogyakarta

Teknologi Informasi dan Komunikasi 25

Laporan Kegiatan Praktikum

................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. .................................................................................................................................................................

Page 4: BAB II

SMAN 3 Padmanaba Yogyakarta

Teknologi Informasi dan Komunikasi 26

................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. ................................................................................................................................................................. .................................................................................................................................................................

Yogyakarta, 2008 Guru Pembimbing

( ........................................................... )

Page 5: BAB II

SMAN 3 Padmanaba Yogyakarta

Teknologi Informasi dan Komunikasi 27