Form untuk pasien seperti di bawah ini :
1. Identifikasi dependensi fungsional atribut-atribut pada formulir
patientNo → fullName
wardNo → wardName
drugNo → name, description, dosage, methodOfAdmin
patientNo, drugNo, startDate → unitsPerDay, finishDate
2. Normalisasi
– SatuNF (1NF)
tabelPasien Rawat Inap dan Obat: patientNo, drugNo, startDate, fullName, wardNo, wardName, bedNo, name, description, dosage, methodOfAdmin, unitsPerDay, finishDate
Tabel Pasient Rawat Inap dan Obat
|
patientNo
|
fullName
|
bedNo
|
wardNo
|
wardName
|
drugNo
|
name
|
description
|
dosage
|
methodOfAdmin
|
unitPerDay
|
startDate
|
finishDate
|
|
P10034
|
Robert MacDonald
|
84
|
Ward 11
|
Orthopaedic
|
10223
|
Morphine
|
Pain Killer
|
10mg/ml
|
Oral
|
50
|
24/03/04
|
24/04/05
|
|
P10034
|
Robert MacDonald
|
84
|
Ward 11
|
Orthopaedic
|
10334
|
Tetracyclene
|
Antibiotic
|
0.5mg/ml
|
IV
|
10
|
24/03/04
|
17/04/04
|
|
P10034
|
Robert MacDonald
|
84
|
Ward 11
|
Orthopaedic
|
10223
|
MOrphine
|
Pain Killer
|
10mg/ml
|
Oral
|
10
|
25/04/05
|
02/05/06
|
– DuaNF (2NF)
Tabel Rawat Inap: patientNo, drugNo, startDate, wardNo, wardName, bedNo, unitsPerDay, finishDate
TabelRawatInap
|
patientNo
|
bedNo
|
wardNo
|
wardName
|
drugNo
|
unitPerDay
|
startDate
|
finishDate
|
|
P10034
|
84
|
Ward 11
|
Orthopaedic
|
10223
|
50
|
24/03/04
|
24/04/05
|
|
P10034
|
84
|
Ward 11
|
Orthopaedic
|
10334
|
10
|
24/03/04
|
17/04/04
|
|
P10034
|
84
|
Ward 11
|
Orthopaedic
|
10223
|
10
|
25/04/05
|
02/05/06
|
TabelObat: drugNo, name, description, dosage, methodOfAdmin
TabelObat
|
drugNo
|
name
|
description
|
dosage
|
methodOfAdmin
|
|
10223
|
Morphine
|
Pain Killer
|
10mg/ml
|
Oral
|
|
10334
|
Tetracyclene
|
Antibiotic
|
0.5mg/ml
|
IV
|
|
10223
|
MOrphine
|
Pain Killer
|
10mg/ml
|
Oral
|
TabelPasien: patientNo, fullName
TabelPasien
|
patientNo
|
fullName
|
|
P10034
|
Robert MacDonald
|
– TigaNF (3NF)
Tabel Rawat Inap: patientNo, drugNo, startDate, wardNo, bedNo, unitsPerDay, finishDate
TabelRawatInap
|
patientNo
|
bedNo
|
wardNo
|
drugNo
|
unitPerDay
|
startDate
|
finishDate
|
|
P10034
|
84
|
Ward 11
|
10223
|
50
|
24/03/04
|
24/04/05
|
|
P10034
|
84
|
Ward 11
|
10334
|
10
|
24/03/04
|
17/04/04
|
|
P10034
|
84
|
Ward 11
|
10223
|
10
|
25/04/05
|
02/05/06
|
TabelObat: drugNo, name, description, dosage, methodOfAdmin
TabelObat
|
drugNo
|
name
|
description
|
dosage
|
methodOfAdmin
|
|
10223
|
Morphine
|
Pain Killer
|
10mg/ml
|
Oral
|
|
10334
|
Tetracyclene
|
Antibiotic
|
0.5mg/ml
|
IV
|
TabelPasien: patientNo, fullName
TabelPasien
|
patientNo
|
fullName
|
|
P10034
|
Robert MacDonald
|
TabelRuangan: ward No, wardName
TabelRuangan
|
wardNo
|
wardName
|
|
Ward 11
|
Orthopaedic
|
3. Kunci primer dan tamu di setiap tabel (3NF)
Jika dilihat ke tabel-tabel diatas(pada jawaban no 2), maka kunci primer terlihat dengan tanda bergaris bawah, yaitu:
tabelRawatInap: patientNo, drugNo, startDate, wardNo, bedNo, unitsPerDay, finishDate
→ Kunci Tamu: patientNo(FK), drugN(FK), wardNo(FK)
tabelObat: drugNo, name, description, dosage, methodOfAdmin
tabelPasien: patientNo, fullName
tabelRuangan: ward No, wardName