jawaban tugas normalisasi 2

Unf :
NIM + NMMHS + TGLLHR + KDMTK + NMMTK + SKS + NILAI + BOBOT


@NIM + NMMHS + TGLLHR = MSMHS
@KDMTK + NMMTK + SKS = MSMTK
@NIM + @KDMTK + @SEMESTER + NILAI = TRNILAI
- Penambahan semester untuk menghindari jika terjadi mahasiswa yang ngulang dengan matakuliah yang sama

@KDBOBOT + BOBOT = TBLBOBOT
- @KDBOBOT BOBOT
<40 E
<60 D
<70 C
<80 B
<100 A

3. Select b.nim, c.nama
from MsMtk as a
inner join TrNilai as b on a.kdmtk = b.kdmtk
inner join MsMhs as c on c.nim = b.nim
where a.nmmtk = ‘Bahasa’

4. Select b.nim, c.nama
from MsMtk as a
inner join TrNilai as b on a.kdmtk = b.kdmtk
inner join MsMhs as c on c.nim = b.nim
where b.nilai >=60

5. Select b.nim, c.nama
from MsMtk as a
inner join TrNilai as b on a.kdmtk = b.kdmtk
inner join MsMhs as c on c.nim = b.nim
where Format(c.TglLhr,"mm") = 11

6. Select b.nim, c.nama
from MsMtk as a
inner join TrNilai as b on a.kdmtk = b.kdmtk
inner join MsMhs as c on c.nim = b.nim
where b.kdmtk = “TEL100” or b.kdmtk = “TEL101”



Seperti biasa juga .. masukin NPM, nama dan kelas

TQ