Normalisasi 2
Normalisasi Perpustakaan
- UNF
| Id_pinjam |
| Nm_Peminjam | Jm_hr_pj |
| Biaya_pinjam |
|
| Id_buku |
| Nm_buku |
| Penerbit | Thn_terbit |
|
| pj001 |
| Boediyono | 3 |
| 6000 |
|
| Bk001 |
| Matematika |
| Erlangga | 2010 |
|
|
|
|
|
|
|
|
|
| Visual |
|
|
|
| ||
|
|
|
| 1 |
| 2000 |
|
| Bk003 |
| basic |
| Gramedia | 2012 |
|
| pj002 |
| Mulyadi |
|
|
|
|
|
|
|
|
| Tinta |
|
|
|
| 2 |
| 4000 |
|
| Bk002 |
| Basis data |
| emas | 2009 |
| ||
|
|
|
|
|
|
|
|
|
| ||||||
| pj003 |
| Burhan | 5 |
| 9000 |
|
| Bk001 |
| Matematika |
| Erlangga | 2010 |
|
|
|
|
|
|
|
|
|
| Struktur |
| Smart |
|
| ||
|
|
|
| 1 |
| 2000 |
|
| Bk005 |
| data |
| book | 2011 |
|
| pj004 |
| Alex |
|
|
|
|
|
|
|
|
| Penebar |
|
|
|
| 3 |
| 6000 |
|
| Bk004 |
| Jaringan |
| swadaya | 2008 |
| ||
|
|
|
|
|
|
|
|
|
| ||||||
| pj005 |
| Suparman |
|
|
|
|
|
|
|
|
| Tinta |
|
|
|
| 2 |
| 4000 |
|
| Bk002 |
| Basis data |
| emas | 2009 |
| ||
|
|
|
|
|
|
|
|
|
|
- 1NF
| Id_pinjam |
| Nm_Peminjam | Jm_hr_pj |
| Biaya_pinjam |
|
| Id_buku |
| Nm_buku |
| Penerbit | Thn_terbit |
|
| pj001 |
| Boediyono | 3 |
| 6000 |
|
| Bk001 |
| Matematika |
| Erlangga | 2010 |
|
| pj001 |
| Boediyono |
|
|
|
|
|
|
| Visual |
|
|
|
|
|
| 1 |
| 2000 |
|
| Bk003 |
| basic |
| Gramedia | 2012 |
| ||
|
|
|
|
|
|
|
|
|
| ||||||
| pj002 |
| Mulyadi |
|
|
|
|
|
|
|
|
| Tinta |
|
|
|
| 2 |
| 4000 |
|
| Bk002 |
| Basis data |
| emas | 2009 |
| ||
|
|
|
|
|
|
|
|
|
| ||||||
| pj003 |
| Burhan | 5 |
| 9000 |
|
| Bk001 |
| Matematika |
| Erlangga | 2010 |
|
| pj003 |
| Burhan |
|
|
|
|
|
|
| Struktur |
| Smart |
|
|
|
| 1 |
| 2000 |
|
| Bk005 |
| data |
| book | 2011 |
| ||
|
|
|
|
|
|
|
|
|
| ||||||
| pj004 |
| Alex |
|
|
|
|
|
|
|
|
| Penebar |
|
|
|
| 3 |
| 6000 |
|
| Bk004 |
| Jaringan |
| swadaya | 2008 |
| ||
|
|
|
|
|
|
|
|
|
| ||||||
| pj005 |
| Suparman |
|
|
|
|
|
|
|
|
| Tinta |
|
|
|
| 2 |
| 4000 |
|
| Bk002 |
| Basis data |
| emas | 2009 |
| ||
|
|
|
|
|
|
|
|
|
|
- 2NF
T_Peminjam
Id_pinjam | Nm_Peminjam |
pj001 | Boediyono |
pj002 | Mulyadi |
pj003 | Burhan |
pj004 | Alex |
pj005 | Suparman |
| Id_buku |
| Nm_buku | Penerbit |
|
| Thn_terbit |
| ||
| Bk001 | Matematika | Erlangga |
| 2010 |
| ||||
| Bk003 | Visual basic | Gramedia |
| 2012 |
| ||||
| Bk002 | Basis data | Tinta emas |
| 2009 |
| ||||
| Bk005 | Struktur data | Smart book |
| 2011 |
| ||||
|
|
|
|
| Penebar |
|
|
|
| |
| Bk004 | Jaringan | swadaya |
| 2008 |
| ||||
T_Pinjaman |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| ||
| Id_pinjam |
| Id_buku |
| Jm_hr_pj |
| Biaya_pinjam |
| ||
| pj001 |
| Bk001 |
| 3 |
| 6000 |
| ||
| pj001 |
| Bk003 |
| 1 |
| 2000 |
| ||
| pj002 |
| Bk002 |
| 2 |
| 4000 |
| ||
| pj003 |
| Bk001 |
| 5 |
| 9000 |
| ||
| pj003 |
| Bk005 |
| 1 |
| 2000 |
| ||
| pj004 |
| Bk004 |
| 3 |
| 6000 |
| ||
| pj005 |
| Bk002 |
| 2 |
| 4000 |
| ||
Komentar
Posting Komentar