Contoh referensi cara membuat ERD Entity Relationship diagram SISTEM PERKULIAHAN

Contoh referensi cara membuat ERD Entity Relationship diagram SISTEM PERKULIAHAN

Diposkan oleh vautsan on Senin, 22 Juli 2013

Contoh referensi cara membuat ERD Entity Relationship diagram SISTEM PERKULIAHAN

1. Contex diagram
2. Hierarchy chat
3. Dfd
4. Flowchat
5. Erd/normalisasi
6. Table/databases

 1.       Contex diagram




7.Hierarchy chat


ERD

NIPY
NM_DOSEN
Jab
NIM
NM_MHS
Kelas
JUR
KD_Mk
Nm_MK
SKS


NIM
NIM
NM_MHS
Kelas
JUR

NIM
NIPY
NIPY
NIPY
NM_DOSEN
Jab
KD_MK
NIPY
KD_MK
KD_Mk
Nm_MK
SKS

A
Field
Type/size
ket
NIM
Char(8)
Null primary key
NM_MHS
Varchar(30)

KElas
Varchar(20)

Jur
Varchar(30)


B
Field
Type/size
ket
NIPY
Char(8)
Null primary key
NM_Dosen
Varchar(30)

Jab
Varchar(20)

C
Field
Type/size
ket
KD_MK
Char(5)
Null primary key
NM_MK
Varchar(30)

SKS
Float




D
Field
Type/size
ket
Id_dos
Int(3)
Null primary key auto_increment
NIM
Char(8)

NIPY
Char(8)


E
Field
Type/size
ket
Id_mk
Int(3)
Null primary key auto_increment
KD_MK
Char(5)

NIPY
Char(8)



Select  A.NIM, B.NIPY, C.kd_MK
From A,B,C,D,E
Where A.NIM=D.NIM
And B.NIPY=D.NIPY
And C.KD_MK=E.KD_MK
And B.NIPY=E.NIPY
;


Comments
0 Comments

{ 0 komentar... read them below or add one }

Posting Komentar

komentar akan ditanggapi dengan ramah klem aza iaa :>

insya alloh saya coment balik brow :)

link download heking

Popular Posts

Pengikut

category