Data UNNORMALISASI
|
NoProyek
|
NamaProyek
|
NoPegawai
|
NamaPegawai
|
Golongan
|
BesarGaji
|
|
NP001
|
BRR
|
Peg01
|
Anton
|
A
|
1.000.000
|
|
|
|
Peg02
|
Jery
|
B
|
500.000
|
|
|
|
Peg11
|
Siska
|
C
|
350.000
|
|
NP002
|
PEMDA
|
Peg03
|
Fery
|
B
|
500.000
|
|
|
|
Peg04
|
Kiki
|
B
|
500.000
|
|
|
|
Peg12
|
Husem
|
A
|
1.000.000
|
|
NP003
|
DIKNAS
|
Peg05
|
Anditha
|
A
|
1.000.000
|
|
|
|
Peg06
|
Ririn
|
C
|
350.000
|
|
|
|
Peg13
|
Rani
|
C
|
350.000
|
|
NP004
|
LINTANG
|
Peg07
|
Irma
|
B
|
500.000
|
|
|
|
Peg08
|
Indra
|
C
|
350.000
|
|
|
|
Peg14
|
Joni
|
A
|
1.000.000
|
|
NP005
|
LITBANG
|
Peg09
|
Josua
|
A
|
1.000.000
|
|
|
|
Peg10
|
Jinkan
|
B
|
500.000
|
|
|
|
Peg15
|
Fitri
|
C
|
350.000
|
|
NP006
|
WWR
|
Peg16
|
Andin
|
C
|
350.000
|
|
|
|
Peg17
|
Amrin
|
B
|
500.000
|
|
|
|
Peg21
|
Bella
|
B
|
500.000
|
|
NP007
|
RCTI
|
Peg18
|
Bunda
|
B
|
500.000
|
|
|
|
Peg19
|
Bisma
|
A
|
1.000.000
|
|
|
|
Peg22
|
Nery
|
A
|
1.000.000
|
|
NP008
|
ITC
|
Peg20
|
Bery
|
A
|
1.000.000
|
|
|
|
Peg23
|
Mery
|
B
|
500.000
|
|
|
|
Peg24
|
Maya
|
C
|
350.000
|
|
NP009
|
GIANT
|
Peg25
|
Zaki
|
B
|
500.000
|
|
|
|
Peg26
|
Putri
|
C
|
350.000
|
|
|
|
Peg30
|
Ryan
|
B
|
500.000
|
|
|
|
Peg27
|
Lutfi
|
A
|
1.000.000
|
|
NP010
|
NRP
|
Peg28
|
Ziska
|
C
|
350.000
|
Normalisasi ke-1
|
NoProyek
|
NamaProyek
|
NoPegawai
|
NamaPegawai
|
Golongan
|
BesarGaji
|
|
NP001
|
BRR
|
Peg01
|
Anton
|
A
|
1.000.000
|
|
NP001
|
BRR
|
Peg02
|
Jery
|
B
|
500.000
|
|
NP001
|
BRR
|
Peg11
|
Siska
|
C
|
350.000
|
|
NP002
|
PEMDA
|
Peg03
|
Fery
|
B
|
500.000
|
|
NP002
|
PEMDA
|
Peg04
|
Kiki
|
B
|
500.000
|
|
NP002
|
PEMDA
|
Peg12
|
Husem
|
A
|
1.000.000
|
|
NP003
|
DIKNAS
|
Peg05
|
Anditha
|
A
|
1.000.000
|
|
NP003
|
DIKNAS
|
Peg06
|
Ririn
|
C
|
350.000
|
|
NP003
|
DIKNAS
|
Peg13
|
Rani
|
C
|
350.000
|
|
NP004
|
LINTANG
|
Peg07
|
Irma
|
B
|
500.000
|
|
NP004
|
LINTANG
|
Peg08
|
Indra
|
C
|
350.000
|
|
NP004
|
LINTANG
|
Peg14
|
Joni
|
A
|
1.000.000
|
|
NP005
|
LITBANG
|
Peg09
|
Josua
|
A
|
1.000.000
|
|
NP005
|
LITBANG
|
Peg10
|
Jinkan
|
B
|
500.000
|
|
NP005
|
LITBANG
|
Peg15
|
Fitri
|
C
|
350.000
|
|
NP006
|
WWR
|
Peg16
|
Andin
|
C
|
350.000
|
|
NP006
|
WWR
|
Peg17
|
Amrin
|
B
|
500.000
|
|
NP006
|
WWR
|
Peg21
|
Bella
|
B
|
500.000
|
|
NP007
|
RCTI
|
Peg18
|
Bunda
|
B
|
500.000
|
|
NP007
|
RCTI
|
Peg19
|
Bisma
|
A
|
1.000.000
|
|
NP007
|
RCTI
|
Peg22
|
Nery
|
A
|
1.000.000
|
|
NP008
|
ITC
|
Peg20
|
Bery
|
A
|
1.000.000
|
|
NP008
|
ITC
|
Peg23
|
Mery
|
B
|
500.000
|
|
NP008
|
ITC
|
Peg24
|
Maya
|
C
|
350.000
|
|
NP009
|
GIANT
|
Peg25
|
Zaki
|
B
|
500.000
|
|
NP009
|
GIANT
|
Peg26
|
Putri
|
C
|
350.000
|
|
NP009
|
GIANT
|
Peg30
|
Ryan
|
B
|
500.000
|
|
NP009
|
GIANT
|
Peg27
|
Lutfi
|
A
|
1.000.000
|
|
NP010
|
NRP
|
Peg28
|
Ziska
|
C
|
350.000
|
Normalisasi kedua
|
NoProyek
|
NamaProyek
|
|
NP001
|
BRR
|
|
NP002
|
PEMDA
|
|
NP003
|
DIKNAS
|
|
NP004
|
LINTANG
|
|
NP005
|
LITBANG
|
|
NP006
|
WWR
|
|
NP007
|
RCTI
|
|
NP008
|
ITC
|
|
NP009
|
GIANT
|
|
NP010
|
NRP
|
Tabel proyek
Tabel pegawai
|
NoPegawai
|
NamaPegawai
|
Golongan
|
BesarGaji
|
|
Peg01
|
Anton
|
A
|
1.000.000
|
|
Peg02
|
Jery
|
B
|
500.000
|
|
Peg11
|
Siska
|
C
|
350.000
|
|
Peg03
|
Fery
|
B
|
500.000
|
|
Peg04
|
Kiki
|
B
|
500.000
|
|
Peg12
|
Husem
|
A
|
1.000.000
|
|
Peg05
|
Anditha
|
A
|
1.000.000
|
|
Peg06
|
Ririn
|
C
|
350.000
|
|
Peg13
|
Rani
|
C
|
350.000
|
|
Peg07
|
Irma
|
B
|
500.000
|
|
Peg08
|
Indra
|
C
|
350.000
|
|
Peg14
|
Joni
|
A
|
1.000.000
|
|
Peg09
|
Josua
|
A
|
1.000.000
|
|
Peg10
|
Jinkan
|
B
|
500.000
|
|
Peg15
|
Fitri
|
C
|
350.000
|
|
Peg16
|
Andin
|
C
|
350.000
|
|
Peg17
|
Amrin
|
B
|
500.000
|
|
Peg21
|
Bella
|
B
|
500.000
|
|
Peg18
|
Bunda
|
B
|
500.000
|
|
Peg19
|
Bisma
|
A
|
1.000.000
|
|
Peg22
|
Nery
|
A
|
1.000.000
|
|
Peg20
|
Bery
|
A
|
1.000.000
|
|
Peg23
|
Mery
|
B
|
500.000
|
|
Peg24
|
Maya
|
C
|
350.000
|
|
Peg25
|
Zaki
|
B
|
500.000
|
|
Peg26
|
Putri
|
C
|
350.000
|
|
Peg30
|
Ryan
|
B
|
500.000
|
|
Peg27
|
Lutfi
|
A
|
1.000.000
|
|
Peg28
|
Ziska
|
C
|
350.000
|
No ProyekPegawai
|
NoProyek
|
NoPegawai
|
|
NP001
|
Peg01
|
|
NP001
|
Peg02
|
|
NP001
|
Peg11
|
|
NP002
|
Peg03
|
|
NP002
|
Peg04
|
|
NP002
|
Peg12
|
|
NP003
|
Peg05
|
|
NP003
|
Peg06
|
|
NP003
|
Peg13
|
|
NP004
|
Peg07
|
|
NP004
|
Peg08
|
|
NP004
|
Peg14
|
|
NP005
|
Peg09
|
|
NP005
|
Peg10
|
|
NP005
|
Peg15
|
|
NP006
|
Peg16
|
|
NP006
|
Peg17
|
|
NP006
|
Peg21
|
|
NP007
|
Peg18
|
|
NP007
|
Peg19
|
|
NP007
|
Peg22
|
|
NP008
|
Peg20
|
|
NP008
|
Peg23
|
|
NP008
|
Peg24
|
|
NP009
|
Peg25
|
|
NP009
|
Peg26
|
|
NP009
|
Peg30
|
|
NP009
|
Peg27
|
|
NP010
|
Peg28
|
Normalisasi ke-3
|
NoProyek
|
NamaProyek
|
|
NP001
|
BRR
|
|
NP002
|
PEMDA
|
|
NP003
|
DIKNAS
|
|
NP004
|
LINTANG
|
|
NP005
|
LITBANG
|
|
NP006
|
WWR
|
|
NP007
|
RCTI
|
|
NP008
|
ITC
|
|
NP009
|
GIANT
|
|
NP010
|
NRP
|
Tabel proyek
Tabel pegawai
|
NoPegawai
|
NamaPegawai
|
Golongan
|
|
Peg01
|
Anton
|
A
|
|
Peg02
|
Jery
|
B
|
|
Peg11
|
Siska
|
C
|
|
Peg03
|
Fery
|
B
|
|
Peg04
|
Kiki
|
B
|
|
Peg12
|
Husem
|
A
|
|
Peg05
|
Anditha
|
A
|
|
Peg06
|
Ririn
|
C
|
|
Peg13
|
Rani
|
C
|
|
Peg07
|
Irma
|
B
|
|
Peg08
|
Indra
|
C
|
|
Peg14
|
Joni
|
A
|
|
Peg09
|
Josua
|
A
|
|
Peg10
|
Jinkan
|
B
|
|
Peg15
|
Fitri
|
C
|
|
Peg16
|
Andin
|
C
|
|
Peg17
|
Amrin
|
B
|
|
Peg21
|
Bella
|
B
|
|
Peg18
|
Bunda
|
B
|
|
Peg19
|
Bisma
|
A
|
|
Peg22
|
Nery
|
A
|
|
Peg20
|
Bery
|
A
|
|
Peg23
|
Mery
|
B
|
|
Peg24
|
Maya
|
C
|
|
Peg25
|
Zaki
|
B
|
|
Peg26
|
Putri
|
C
|
|
Peg30
|
Ryan
|
B
|
|
Peg27
|
Lutfi
|
A
|
|
Peg28
|
Ziska
|
C
|
No ProyekPegawai
|
NoProyek
|
NoPegawai
|
|
NP001
|
Peg01
|
|
NP001
|
Peg02
|
|
NP001
|
Peg11
|
|
NP002
|
Peg03
|
|
NP002
|
Peg04
|
|
NP002
|
Peg12
|
|
NP003
|
Peg05
|
|
NP003
|
Peg06
|
|
NP003
|
Peg13
|
|
NP004
|
Peg07
|
|
NP004
|
Peg08
|
|
NP004
|
Peg14
|
|
NP005
|
Peg09
|
|
NP005
|
Peg10
|
|
NP005
|
Peg15
|
|
NP006
|
Peg16
|
|
NP006
|
Peg17
|
|
NP006
|
Peg21
|
|
NP007
|
Peg18
|
|
NP007
|
Peg19
|
|
NP007
|
Peg22
|
|
NP008
|
Peg20
|
|
NP008
|
Peg23
|
|
NP008
|
Peg24
|
|
NP009
|
Peg25
|
|
NP009
|
Peg26
|
|
NP009
|
Peg30
|
|
NP009
|
Peg27
|
|
NP010
|
Peg28
|
Tabel Golongan
|
Golongan
|
BesarGaji
|
|
A
|
1.000.000
|
|
B
|
500.000
|
|
C
|
350.000
|
Jenis tabel:
Tabel proyek ->Master
Tabel pegawai ->Master
Tabel No ProyekPegawai ->header
Tabel Golongan ->detail
Tipe data
Tabel Proyek
|
Field
|
Tipe Data
|
|
NoProyek
|
Int
|
|
NamaProyek
|
Karakter
|
Tabel Pegawai
|
NoPegawai
|
Int
|
|
NamaPegawai
|
Karakter
|
Tabel No proyekpegawai
|
NoPegawai(PK)
|
int
|
|
BesarGaji
|
Int
|
|
Golongan
|
Karakter
|
Tabel Golongan
|
Golongan
|
Karakter
|
|
Besar Gaji
|
Int
|
Tidak ada komentar:
Posting Komentar