0

Normalisasi Data Pembelian Breadtalk

Posted by Jujur Sitanggang on 10:39 AM

TUGAS BASIS DATA

Nim     : 10112672 (Jujur Soaloon)
Nim    :10112700 (Andrianto)

Normalisasi Data Pembelian Breadtalk

  • Struk Pembelian Breadtalk (Toko Roti)

C:\Users\Jus\Pictures\fa.png
Studi Kasus
Step I Bentuk Unnormalized

Kode Roti
Nama Roti
Post Pembayaran
No Check
Petugas Kasir
Tanggal beli
Banyak
Harga
Total
A44H
Floss n Roll
Post1
2274076
Novi
08 Feb 14
1
10.500
10.500
A33F
Mushrome Pizza
1
10.000
10.000
Q46Z
Butter Sugar
Post2
2274098
Elisa
09 Jan 14
2
15.000
30.000
T21O
Fire Floss
Post3
2274116
Felisaria
10 Nov 14
3
10.000
30.000


Studi Kasus
Step II Bentuk 1stNF

Kode Roti
Nama Roti
Post Pembayaran
No Check
Petugas Kasir
Tanggal Beli
Banyak
Harga
Total
A44H
Floss n Roll
Post1
2274076
Novi
08 Feb 14
1
10.500
10.500
A33H
Mushrome Pizza
Post1
2274076
Novi
08 Feb 2014
1
10.000
10.000
Q46Z
Butter Sugar
Post2
2274098
Elisa
09 Jan 14
2
15.000
30.000
T21O
Fire Floss
Post3
2274116
Felisaria
10 Nov 14
3
10.000
30.000


Studi Kasus
Step III Bentuk 2ndNF

Post Pembayaran
Petugas Kasir
Post1
Novi
Post2
Elisa
Post3
Felisaria
Kode Roti
Nama Roti
Harga
A44H
Floss n Roll
10.500
A33H
Mushrome Pizza
10.000
Q46Z
Butter Sugar
15.000
T21O
Fire Floss
10.000


No Check
Tanggal Beli
Banyak
Harga
Total
Kode Roti
Post Pembayaran
2274076
08 Feb 14
1
10.500
10.500
A44H
Post1
2274076
08 Feb 14
1
10.000
10.000
A33H
Post1
2274098
09 Jan 14
2
15.000
30.000
Q46Z
Post2
2274116
10 Nov 14
3
10.000
30.000
T21O
Post3

Post Pembayaran
Petugas Kasir
Post1
Novi
Post2
Elisa
Post3
Felisaria
Kode Roti
Nama Roti
Harga
A44H
Floss n Roll
10.500
A33H
Mushrome Pizza
10.000
Q46Z
Butter Sugar
15.000
T21O
Fire Floss
10.000
Studi Kasus
Step IV Bentuk 3rdNF






No Check
Tanggal Beli
Banyak
Total
Kode Roti
2274076
08 Feb 14
1
10.500
A44H
2274076
08 Feb 14
1
10.000
A33H
2274098
09 Jan 14
2
30.000
Q46Z
2274116
10 Nov 14
3
30.000
T21O
No Check
Banyak
Kode Roti
2274076
1
A44H
2274076
1
A33H
2274098
2
Q46Z
2274116
3
T21O

   



0 Comments

Copyright Jujur Soaloon Sitangang Lipan All rights reserved. Theme by Sitanggang. | Bloggerized by Soalparna.