4.
select nim, nama_mhs, jurusan, nama_dsn from dosen_pa, mahasiswa, registrasi,
matakuliah
where
dosen_pa.nip=matakuliah.nip
and
matakuliah.kd_mk=registrasi.kd_mk
and
mahasiswa.nim=registrasi.nim
and
sks = 3
Query Tree
6.
misal:
harga = 3.000.000 ↔ a
nama_barang = televisi ↔ b
a
ᴠ ( ⌐b ᴧ ( b ᴠ ⌐b) ᴧ b)
a
ᴠ ( ⌐b ᴧ true ᴧ b)
a
ᴠ ( ⌐b ᴧ b)
a
ᴠ false
a
jadi:
select nama_barang from barang where harga = “3.000.000”
Class Diagram
Tidak ada komentar:
Posting Komentar