Kuis Perancangan Basis Data

SOAL

Model Relasi Tabel

Jawaban nomor 4

Select nim,nama_mhs,jurusan,nama_dosen

Where Mahasiswa M,Matakuliah MK,Dosen_PA DP,Registrasi R

From     M.nim=R.nim AND

                MK.kd_mk=R.kd_mk AND

                DP.nip=MK.nip AND

                MK.sks=3

Normalisasi

M.nim=R.nim Ʌ MK.kd_mk= R.kd_mk Ʌ DP.nip= MK.nip  Ʌ DP.nip =MK.nip Ʌ MK.sks=3

Jawaban nomor 5

Query Graph

Query Tree

Jawaban nomor 6

A = harga = 3.000.000

B = nama barang = “Televisi”

A V ( -(B) Ʌ (B V B) Ʌ  -(B))

A V (-B Ʌ TRUE Ʌ B)
A V (-B Ʌ B)

A V FALSE
A

Solusinya harga = 3.000.000

Jawaban nomor 7

Class Diagram

Entity Relationship Diagram