normalisasi tabel dari sebuah faktur (studi kasus)
DESCRIPTION
NORMALISASI TABEL DARI SEBUAH FAKTUR (STUDI KASUS)COpyright..,Only For Sample.., not t be downloaded.., coz the data isnt valid..,TRANSCRIPT
NORMALISASI TABEL DARI FAKTUR
DISUSUN OLEH : ANDI INSANUDIN (1010804
TUGAS
NORMALISASI TABEL DARI FAKTUR SERVICE MOTOR (STUDI KASUS
MATA KULIAH BASIS DATA
10108048); WILDAN SHOLEH (10108061); DAENG ROSANDA (
STUDI KASUS)
; DAENG ROSANDA (10108088)
TUGAS
NORMALISASI TABEL DARI FAKTUR SERVICE MOTOR (STUDI KASUS)
MATA KULIAH BASIS DATA
TABEL ASAL
HONDA ASTRA HONDA AUTHORIZED SERVICE STATION
AHASS 2509
VICI MOTOR JL. PURWAKARTA NO. 91 TELP.(022) 7200764 - BANDUNG
TANDA PEMBAYARAN NO FAKTUR FK06091249 NO POLISI D 4570 GR
TGL FAKTUR 28-06-09 MEKANIK W. GUNAWAN
NO WO WO05248 TIPE MOTOR BLADE
COSTUMER SUPENDI SUJANAEDI
JL. CIBATU 2 NO. 43 RT 02/18 ANPN
NAMA PART HARGA QTY DISKON TOTAL
OLI FEDERAL REXTRON CC 0 1 0 0
ASS I 0 1 0 0
BANDUNG, 28 JUNI 2009 SUBTOTAL : 0
DISKON : 0
TOTAL : 0
( )
TERIMAKASIH ATAS KEPERCAYAAN ANDA HAL.1/1
TU
GA
S
NO
RM
ALI
SA
SI
TA
BE
L D
AR
I F
AK
TU
R S
ER
VIC
E M
OT
OR
(S
TU
DI
KA
SU
S)
MA
TA
KU
LIA
H B
AS
IS D
AT
A
BE
NT
UK
TID
AK
NO
RM
AL
NO
FA
KT
UR
T
AN
GG
AL
FA
KT
UR
NO
WO
N
O P
OLI
SI
ME
KA
NIK
T
IPE
MO
TO
R
CU
ST
OM
ER
N
AM
A P
AR
T
HA
RG
A
QT
Y
DIS
KO
N
SU
BT
OT
AL
TO
TA
L
FK
06
09
12
49
2
8-0
6-0
9
WO
05
34
8
D 4
57
0 G
R
W.
GU
NA
WA
N
BLA
DE
SU
PE
ND
I S
UJA
NA
ED
I
JL.
CIB
AT
U 2
NO
. 4
3 R
T 0
2/1
8
AN
TA
PA
NI
OLI
FE
DE
RA
L R
EX
TR
ON
CC
0
1
0
0
0
AS
S I
0
1
0
0
0
FK
06
09
12
50
2
8-0
6-0
9
WO
05
34
9
D 3
72
9 G
X
AS
EP
S.
VA
RIO
D
JAJA
NG
AB
DU
RA
HM
AN
JL.
PU
RW
AK
AR
TA
NO
.11
9 R
T 1
/04
AN
TA
PA
NI
BE
LT T
RA
NS
MIS
SIO
N S
ET
9
00
00
1
0
9
00
00
9
00
00
BE
NT
UK
NO
RM
AL K
E 1
NO
FA
KT
UR
T
AN
GG
AL
FA
KT
UR
NO
WO
N
O
PO
LIS
I
ME
KA
NIK
T
IPE
MO
TO
R
CU
ST
OM
ER
N
AM
A P
AR
T
HA
RG
A
QT
Y
DIS
KO
N
SU
BT
OT
AL
TO
TA
L
NA
MA
A
LAM
AT
FK
06
09
12
49
2
8-0
6-0
9
WO
05
34
8
D
45
70
GR
W.
GU
NA
WA
N
BLA
DE
S
UP
EN
DI
SU
JAN
AE
DI
JL.
CIB
AT
U 2
NO
. 4
3 R
T 0
2/1
8 A
NT
AP
AN
I O
LI F
ED
ER
AL
RE
XT
RO
N C
C
0
1
0
0
0
FK
06
09
12
49
2
8-0
6-0
9
WO
05
34
8
D
45
70
GR
W.
GU
NA
WA
N
BLA
DE
S
UP
EN
DI
SU
JAN
AE
DI
JL.
CIB
AT
U 2
NO
. 4
3 R
T 0
2/1
8 A
NT
AP
AN
I A
SS
I
0
1
0
0
0
FK
06
09
12
50
2
8-0
6-0
9
WO
05
34
9
D
37
29
GX
AS
EP
S.
VA
RIO
D
JAJA
NG
AB
DU
RA
HM
AN
JL.
PU
RW
AK
AR
TA
NO
.11
9 R
T 1
/04
AN
TA
PA
NI
BE
LT
TR
AN
SM
ISS
ION
SE
T
90
00
0
1
0
90
00
0
90
00
0
BE
NT
UK
NO
RM
AL K
E 2
NO
FA
KT
UR
T
AN
GG
AL
FA
KT
UR
N
O W
O
NO
PO
LIS
I N
AM
A P
AR
T
QT
Y
DIS
KO
N
SU
BT
OT
AL
TO
TA
L
FK
06
09
12
49
2
8-0
6-0
9
WO
05
34
8
D 4
57
0 G
R
OLI
FE
DE
RA
L R
EX
TR
ON
CC
1
0
0
0
FK
06
09
12
49
2
8-0
6-0
9
WO
05
34
8
D 4
57
0 G
R
AS
S I
1
0
0
0
FK
06
09
12
50
2
8-0
6-0
9
WO
05
34
9
D 3
72
9 G
X
BE
LT T
RA
NS
MIS
SIO
N S
ET
1
0
9
00
00
9
00
00
NO
FA
KT
UR
N
O W
O
ME
KA
NIK
FK
06
09
12
48
W
O0
53
47
G
UN
-GU
N H
.
FK
06
09
12
49
W
O0
53
48
W
. G
UN
AW
AN
FK
06
09
12
50
W
O0
53
49
A
SE
P S
.
NO
PO
LIS
I T
IPE
MO
TO
R
NA
MA
CU
ST
OM
ER
A
LAM
AT
C
OST
UM
ER
D 4
57
0 G
R
BLA
DE
S
UP
EN
DI
SU
JAN
AE
DI
JL.
CIB
AT
U 2
NO
. 4
3 R
T 0
2/1
8 A
NT
AP
AN
I
D 3
72
9 G
X
VA
RIO
D
JAJA
NG
AB
DU
RA
HM
AN
JL
. P
UR
WA
KA
RT
A N
O.1
19
RT
1/0
4 A
NT
AP
AN
I
NA
MA
PA
RT
H
AR
GA
OLI
FE
DE
RA
L S
UP
RE
ME
ULT
RA
TE
C
29
00
0
OLI
FE
DE
RA
L R
EX
TR
ON
CC
3
50
00
AS
TR
A C
HA
IN S
ET
BE
BE
K
40
00
0
AS
TR
A R
UN
NIN
G G
EA
R S
ET
BE
BE
K
56
00
0
AS
S I
7
50
0
BE
LT T
RA
NS
MIS
SIO
N S
ET
9
00
00
GR
EA
SE
2
00
00
PA
CK
ING
SE
T
55
00
BR
AK
E P
AD
1
25
00
TU
GA
S
NO
RM
ALI
SA
SI
TA
BE
L D
AR
I F
AK
TU
R S
ER
VIC
E M
OT
OR
(S
TU
DI
KA
SU
S)
MA
TA
KU
LIA
H B
AS
IS D
AT
A
BE
NT
UK
NO
RM
AL K
E 3
NO
FA
KT
UR
T
AN
GG
AL
FA
KT
UR
N
O P
OLI
SI
TO
TA
L
FK
06
09
12
49
2
8-0
6-0
9
D 4
57
0 G
R
0
FK
06
09
12
50
2
8-0
6-0
9
D 3
72
9 G
X
90
00
0
NO
FA
KT
UR
T
AN
GG
AL
FA
KT
UR
NA
MA
PA
RT
Q
TY
D
ISK
ON
S
UB
TO
TA
L
FK
06
09
12
49
2
8-0
6-0
9
OLI
FE
DE
RA
L R
EX
TR
ON
CC
1
0
0
FK
06
09
12
49
2
8-0
6-0
9
AS
S I
1
0
0
FK
06
09
12
50
2
8-0
6-0
9
BE
LT T
RA
NS
MIS
SIO
N S
ET
1
0
9
00
00
NO
FA
KT
UR
N
O W
O
ME
KA
NIK
FK
06
09
12
48
W
O0
53
47
G
UN
-GU
N H
.
FK
06
09
12
49
W
O0
53
48
W
. G
UN
AW
AN
FK
06
09
12
50
W
O0
53
49
A
SE
P S
.
NO
PO
LIS
I T
IPE
MO
TO
R
NA
MA
CU
ST
OM
ER
A
LAM
AT
C
OST
UM
ER
D 4
57
0 G
R
BLA
DE
S
UP
EN
DI
SU
JAN
AE
DI
JL.
CIB
AT
U 2
NO
. 4
3 R
T 0
2/1
8 A
NT
AP
AN
I
D 3
72
9 G
X
VA
RIO
D
JAJA
NG
AB
DU
RA
HM
AN
JL
. P
UR
WA
KA
RT
A N
O.1
19
RT
1/0
4 A
NT
AP
AN
I
NA
MA
PA
RT
H
AR
GA
OLI
FE
DE
RA
L S
UP
RE
ME
ULT
RA
TE
C
29
00
0
OLI
FE
DE
RA
L R
EX
TR
ON
CC
3
50
00
AS
TR
A C
HA
IN S
ET
BE
BE
K
40
00
0
AS
TR
A R
UN
NIN
G G
EA
R S
ET
BE
BE
K
56
00
0
AS
S I
7
50
0
BE
LT T
RA
NS
MIS
SIO
N S
ET
9
00
00
GR
EA
SE
2
00
00
PA
CK
ING
SE
T
55
00
BR
AK
E P
AD
1
25
00