Catatan - Basis Data #2
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 KE-2
TABEL PROYEK
NoProyek
|
NamaProyek
|
NP001
|
BRR
|
NP002
|
PEMDA
|
NP003
|
DIKNAS
|
NP004
|
LINTANG
|
NP005
|
LITBANG
|
NP006
|
WWR
|
NP007
|
RCTI
|
NP008
|
ITC
|
NP009
|
GIANT
|
NP010
|
NRP
|
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 PROYEK PEGAWAI
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
TABEL PROYEK
NoProyek
|
NamaProyek
|
NP001
|
BRR
|
NP002
|
PEMDA
|
NP003
|
DIKNAS
|
NP004
|
LINTANG
|
NP005
|
LITBANG
|
NP006
|
WWR
|
NP007
|
RCTI
|
NP008
|
ITC
|
NP009
|
GIANT
|
NP010
|
NRP
|
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 PROYEK PEGAWAI
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 Proyek Pegawai
-> Header
Tabel Golongan ->
Detail
Tipe Data
TABEL PROYEK
Field
|
Tipe Data
|
NoProyek
|
Int
|
NamaProyek
|
Karakter
|
TABEL PEGAWAI
NoPegawai
|
Int
|
NamaPegawai
|
Karakter
|
TABEL NO PROYEK PEGAWAI
NoPegawai(PK)
|
int
|
BesarGaji
|
Int
|
Golongan
|
Karakter
|
TABEL GOLONGAN
Golongan
|
Karakter
|
Besar Gaji
|
Int
|
Komentar