basis data

A B C D E F G H I J

No_fak	Tgl_faktur	Nm_kons	Almt_kons	Kota_kons	Kode_brg	Nama_brg	Jml	Hrg_sat	bayar
101	10-01-08	Ali	Jl. A. Yani No. 10	Semarang	1101	Sandal	10	15000	150000
101	10-01-08	Ali	Jl. A. Yani No. 10	Semarang	1100	Sepatu	7	100000	700000
101	10-01-08	Ali	Jl. A. Yani No. 10	Semarang	1102	Kaos	15	30000	450000
102	11-01-08	Rudi	Jl. Seroja Raya 1	Solo	1101	Sandal	20	15000	300000
102	11-01-08	Rudi	Jl. Seroja Raya 1	Solo	1103	Jaket	4	200000	800000

1. Carilah KF-2 Tabel Tersebut!
2. Carilah Superkey, Candidate Key, dan Primary Key!

Jawab :

Berdasarkan Ketergantungan Fungsionalnya :

Kode_brg --> nama_brg, hrg_sat

Nm_kons --> almt_kons, kota_kons

No_fak --> nm_kons, tgl_faktur

No_faktur, kode_brg --> jml, bayar

Maka Tabel tersebut dapat didekomposisi menjadi 4 Tabel :

Faktur

A B C

No_fak	Tgl_faktur	Nm_kons
101	10-01-08	Ali
102	11-01-08	Rudi

Konsumen

C D E

Nm_kons	Almt_kons	Kota_kons
Ali	Jl. A. Yani No. 10	Semarang
Rudi	Jl. Seroja Raya 1	Solo

Rincian

A F H J

No_fak	Kode_brg	Jml	bayar
101	1101	10	150000
101	1100	7	700000
101	1102	15	450000
102	1101	20	300000
102	1103	4	800000

Barang

F G I

Kode_brg	Nama_brg	Hrg_sat
1100	Sepatu	100000
1101	Sandal	15000
1102	Kaos	30000
1103	Jaket	200000

R (A, B, C, D, E, F, G, H, I, J)

Tabel Faktur (A, B, C) = A --> BC

A --> BC

A --> A

A --> ABC (Union)

Super Key = A

Candidate Key = A

Primary Key = A

Foreign Key = C

Tabel Konsumen (C, D, E) = C --> DE

C --> DE

C --> C

C --> CDE (Union)

Super Key = C

Candidate Key = C

Primary Key = C

Foreign Key = -

Tabel Rincian (A, F, H, J) = AF --> HJ

AF --> HJ

AF --> AF

AF --> AFHJ (Union)

Super Key = AF

Candidate Key = -

Primary Key = -

Foreign Key = A dan F

Tabel Barang (F, G, I) = F --> GI

F --> GI

F --> F

F --> FGI (Union)

Super Key = F

Candidate Key = F

Primary Key = F

Foreign Key = -

A --> BC

C --> DE

A --> BCDE

A --> A

A --> ABCDE (Union)

F --> GI

F --> F

F --> FGI (Union)

AF --> HJ

Karena A --> ABCDE

AF --> ABCDEHJ

Karena F --> GI

AF --> ABCDEGHIJ

AF --> R

Jadi

Super Key = AF

Candidate Key = -

Primary Key = -