7/21/2019 Assessment 2 Rama Febryan

http://slidepdf.com/reader/full/assessment-2-rama-febryan 1/1

Nomor 1:

mysql> select tbl_dokter.kd_dokter, tbl_dokter.nama_dokter, tbl_dokter.sex, tbl_ specialis.spesialis from tbl_dokter, tbl_specialis where tbl_dokter.kd_spesialis=tbl_specialis.kd_spesialis and (spesialis='Anak' or spesialis='Mata');+-----------+-------------------+-----+-----------+| kd_dokter | nama_dokter | sex | spesialis |

+-----------+-------------------+-----+-----------+| D07 | dr.Dedi Suntri | L | Mata || D08 | dr.Mawar Herawati | P | Anak || D13 | dr.Budiawan Kanto | L | Anak |+-----------+-------------------+-----+-----------+3 rows in set (0.00 sec)

Nomor 2:

mysql> select tbl_dokter.kd_dokter, tbl_dokter.nama_dokter, tbl_dokter.sex, tbl_ praktek.hari, tbl_specialis.spesialis from tbl_dokter, tbl_praktek, tbl_speciali

s where tbl_dokter.kd_dokter=tbl_praktek.kd_dokter and tbl_dokter.kd_spesialis=tbl_specialis.kd_spesialis;+-----------+----------------------+-----+--------+-----------+| kd_dokter | nama_dokter | sex | hari | spesialis |+-----------+----------------------+-----+--------+-----------+| D01 | dr.Arifin Nur | L | Senin | Umum || D09 | dr.Yeni Warni | P | Senin | Umum || D11 | dr.Tanto Sutioso | L | Senin | Umum || D03 | dr.Baranuly Sitepu | L | Selasa | Bedah || D08 | dr.Mawar Herawati | P | Selasa | Anak || D04 | dr.Iwan Kurniawan | L | Selasa | Jantung || D05 | dr.Krista Wijaya | P | Selasa | Kandungan || D15 | dr.Sugeng Fiitrianto | L | Selasa | Kandungan |

| D13 | dr.Budiawan Kanto | L | Rabu | Anak || D12 | dr.Zein Kapensky | L | rabu | Bedah || D14 | dr.Indah Indriayanti | P | rabu | Umum || D06 | dr.Mawardi Konro | L | kamis | Syaraf || D07 | dr.Dedi Suntri | L | jumat | Mata || D10 | dr.Hana Angraini | P | sabtu | Bedah || D02 | dr.Agung Sutopo | L | minggu | Dalam |+-----------+----------------------+-----+--------+-----------+15 rows in set (0.05 sec)

Nomor 3:

mysql> select tbl_dokter.nama_dokter, tbl_dokter.sex, tbl_praktek.hari, tbl_specialis.spesialis from tbl_dokter, tbl_praktek, tbl_specialis where tbl_dokter.kd_ dokter=tbl_praktek.kd_dokter and tbl_dokter.kd_spesialis=tbl_specialis.kd_spesialis and hari='Selasa';+----------------------+-----+--------+-----------+| nama_dokter | sex | hari | spesialis |+----------------------+-----+--------+-----------+| dr.Baranuly Sitepu | L | Selasa | Bedah || dr.Mawar Herawati | P | Selasa | Anak || dr.Iwan Kurniawan | L | Selasa | Jantung || dr.Krista Wijaya | P | Selasa | Kandungan || dr.Sugeng Fiitrianto | L | Selasa | Kandungan |

+----------------------+-----+--------+-----------+5 rows in set (0.00 sec)