1 / 7

kasus normalisasi

kasus normalisaasi

AnjasMahesa
Download Presentation

kasus normalisasi

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Kasus Normalisasi Rina Kurniawati, S.Kom., MT

  2. DOKUMEN DASAR FAKTUR PEMBELIAN PT. SANTA PURI FAKTUR PEMBELIAN BARANG Jl. Senopati 11 Bandung Kode Supplier : G01 Tanggal: 07/02/90 Nama Supplier : GobelNustraNomor: 998 JatuhTempo faktur : 09/03/90

  3. BENTUK UNNORMAL – NORMAL 1

  4. MENENTUKAN KETERGANTUNGAN ATRIBUT Atribut Kunci : No_fak  Nama_Supp Nama_brg Tgl_fak Qty Harga_sat Jumlah Total JTF Atribut Kunci : Kode_Supp  Nama_Supp Nama_brg Qty Harga_sat Jumlah Atribut Kunci : Kode_brg Nama_brg • Qty Harga_sat • Jumlah

  5. BENTUK NORMAL KE 2

  6. BENTUK NORMAL KE 3 SUPPLIER BARANG FAKTUR TRANSAKSI

  7. ERD n n FAKTUR BARANG n TRANSAKSI membeli JTF No_fak Kode_brg Harga_sat Nama_brg nama_supp total No_fak Kode_supp No_fak Kode_brg total total Kode_supp Tgl_fak 1 SUPPLIER

More Related