0
Normalisasi Data Pembelian Breadtalk
Posted by jujur
on
10:39 AM
TUGAS BASIS DATA
Nim : 10112672 (Jujur Soaloon)
Nim :10112700 (Andrianto)
Normalisasi Data Pembelian Breadtalk
- Struk Pembelian Breadtalk (Toko Roti)
Studi Kasus
Step I Bentuk Unnormalized
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
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
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
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
|
