Personal Mind of ASEP

Sepercik Rasa yang Tercurah

Log Akdpsim

tabel Jadwal Kuliah
index di dosen
-Tahun AKademik
-Semester
-tanggal
-Sesi
-KodeRuang
-KodeDosen

07/09/05
– ditambah index kode ruang
– ditambah field flag
– ditambah field matrik

tabel uid
-ditambah filed dep

11/09/05

tabel TBB
KodeBB -> kode bimbingan
Ket -> keterangan bimbingan

Tabel TBBG
NPM
KodeDsn -> Kode dosen
KodeBB -> kode bimbingan
kete -> Keterangan

SELECT dbo.TBBG.NPM, dbo.TBBG.KodeBB AS PB2, dbo.TDosen.NamaDsn, dbo.TDosen.Title
FROM dbo.TBBG INNER JOIN
dbo.TMahasiswa ON dbo.TBBG.NPM = dbo.TMahasiswa.NPM INNER JOIN
dbo.TDosen ON dbo.TBBG.KOdeDsn = dbo.TDosen.KodeDsn
WHERE (dbo.TBBG.KodeBB = ‘KP’)

22/09/05

Tmahasiswa
-Tambah Field TglStat-> untuk memasukan tanggal perubahan status selain alumni(tglLulus)
-Tambah Field Descr -> Deskripsi user

September 26, 2005 - Posted by | Uncategorized

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: