Basis Data

SELECT pendidikan FROM dosen, mengajar, matakuliah WHERE sks>2 AND dosen.kd_dosen=mengajar.kd_dosen AND matakuliah.kd_matakul=mengajar.kd_matakul

SELECT nama FROM dosen, mengajar, matakuliah WHERE matakul="Sistem informasi" AND dosen.kd_dosen=mengajar.kd_dosen AND mengajar.kd_matakul=matakuliah.kd_matakul

SELECT nama FROM dosen, penilaian,mengajar WHERE nilai_uts<50 AND penilaian.no_ajar=mengajar.no_ajar AND mengajar.kd_dosen=dosen.kd_dosen

SELECT nilai_uts, nilai_uas FROM penilaian, mengajar,dosen WHERE alamat="semarang" AND penilaian.no_ajar=mengajar.no_ajar AND mengajar.kd_dosen=dosen.kd_dosen