Contoh referensi cara membuat ERD Entity Relationship diagram SISTEM PERKULIAHAN

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

;