1.tampilkan matakuliah yang sksnya >= 3
mysql> select * from matakuliah
-> where sks = 3;
+--------+--------+------+
| kodemk | namamk | sks |
+--------+--------+------+
| 2 | java | 3 |
+--------+--------+------+
1 row in set (0.00 sec)
2. tampilkan nip, nama dosen pada programstd = 'tinformatika
mysql> select dosen.nip, dosen.nama, dosen.kodeps, programstd.namaps from dosen,
-> programstd where dosen.kodeps=programstd.kodeps
-> and programstd.namaps='tinformatika';
+------+------+--------+--------------+
| nip | nama | kodeps | namaps |
+------+------+--------+--------------+
| 1234 | tono | 1 | TInformatika |
+------+------+--------+--------------+
1 row in set (0.09 sec)
3.tampilkan nim, nama mahasiswa dan nama programstudinya
mysql> select mahasiswa.nim, mahasiswa.nama, programstd.namaps from mahasiswa, p
rogramstd
-> where mahasiswa.kodeps=programstd.kodeps;
+------------+-------+--------------+
| nim | nama | namaps |
+------------+-------+--------------+
| 1443290022 | yakub | TInformatika |
| 1443290023 | agus | Manajemen |
| 1443290024 | bagas | psikologi |
| 1443290025 | bagus | akuntansi |
| 1443290026 | joko | sipil |
+------------+-------+--------------+
5 rows in set (0.00 sec)
4.tampilkan nip, nama dosen dan nama programstudinya
mysql> select dosen.nip, dosen.nama, programstd.namaps from dosen,programstd
-> where dosen.kodeps=programstd.kodeps;
+------+------+--------------+
| nip | nama | namaps |
+------+------+--------------+
| 1234 | tono | TInformatika |
| 1235 | tini | Manajemen |
| 1236 | tino | psikologi |
| 1237 | tina | akuntansi |
| 1238 | tine | sipil |
+------+------+--------------+
5 rows in set (0.00 sec)
mysql> select mahasiswa.nim, mahasiswa.nama, programstd.namaps from mahasiswa, p
rogramstd
-> where mahasiswa.kodeps=programstd.kodeps;
+------------+-------+--------------+
| nim | nama | namaps |
+------------+-------+--------------+
| 1443290022 | yakub | TInformatika |
| 1443290023 | agus | Manajemen |
| 1443290024 | bagas | psikologi |
| 1443290025 | bagus | akuntansi |
| 1443290026 | joko | sipil |
+------------+-------+--------------+
5 rows in set (0.00 sec)
5.tampilkan kode matakuliah, nama matakuliah serta sks yang di buka pada tahun akademik 2014 semester genap/2
mysql> select matakuliah.namamk, matakuliah.sks, kuliah.thnakademik, kuliah.seme
ster, kuliah.kodemk from matakuliah, kuliah
-> where matakuliah.kodemk = kuliah.kodemk
-> and kuliah.semester=2;
+------------+------+-------------+----------+--------+
| namamk | sks | thnakademik | semester | kodemk |
+------------+------+-------------+----------+--------+
| basis data | 5 | 0000-00-00 | 2 | 1 |
+------------+------+-------------+----------+--------+
1 row in set (0.00 sec)
6. spt soal no 5 yg diambil oleh mahasiswa dengan nama 'yakub'
mysql> select matakuliah.namamk, matakuliah.sks, mahasiswa.nama, kuliah.thnakade
mik, kuliah.semester, kuliah.kodemk, kuliah.nim from matakuliah,mahasiswa,kuliah
-> where matakuliah.kodemk=kuliah.kodemk
-> and kuliah.semester=2
-> and mahasiswa.nama='yakub';
+------------+------+-------+-------------+----------+--------+------------+
| namamk | sks | nama | thnakademik | semester | kodemk | nim |
+------------+------+-------+-------------+----------+--------+------------+
| basis data | 5 | yakub | 0000-00-00 | 2 | 1 | 1443290022 |
+------------+------+-------+-------------+----------+--------+------------+
1 row in set (0.00 sec)
